Change private interconnect network interface in Database 12c CRS GPnP
Submitted by Ewan on
How to start CRS when the private interconnect's netmask has changed. This HowTo will describe how to update the OLR with the new netmask.
Submitted by Ewan on
How to start CRS when the private interconnect's netmask has changed. This HowTo will describe how to update the OLR with the new netmask.
Submitted by Ewan on
How to recreate a lost OCR ASM disk group from scratch. This HowTo applies to Database 12c RAC. We will rebuild the disk group, restore the OCR, replace the voting disks, and recreate the ASM parameter and password files.
Submitted by Ewan on
This HowTo demonstrates migrating a RAC cluster to Flex ASM from 'traditional' ASM.
The prerequisites are that the OCR files, ASM parameter file and ASM password file are stored in an ASM disk group with asm.compatible set to at least 12.1. We will confirm the ASM cluster mode before we begin and after we have finished.
Submitted by Ewan on
Oracle Database 12c Release 1 fully supports IPv6. Here is how to add IPv6 support to VIPs and SCANs in a 12c RAC cluster. The VIPs, SCANs and their listeners will support both IPv4 and IPv6 and addresses from both families will relocate between RAC nodes as normal. It is only assumed that the servers already have a host IPv6 address assigned via auto-configuration.
Submitted by Ewan on
We will create a database and populate it with UK streets and incidents of street crime. We will then plot the crimes on an interactive map for further analysis.
We will create a PostgreSQL PostGIS database on the local machine. Eventually all our spatial data will be stored here.
Submitted by Ewan on
Below I will annotate an example using SQL to extract and chart some tablespace trending data using GNU Plot.
Oracle's Grid Control collects, stores, and manages historical metric data for hosts, databases, and all sorts of targets. This data is difficult to retrieve, especially the historical data. Creating a report in Grid Control results in a small bitmapped image. If you need, say, a year of CPU data, this small bitmap is difficult to interpret.
If the data is extracted from Grid Control's Oracle Management Service (OMS) then graphically representing the data can also be performed externally. One such tool that can be used to graph the data is GNU Plot.
Submitted by Ewan on
By using a checkpoint table in the OGG replicat database, you can retrospectively review the replicat's lag using flashback query (with some limitations if you do not utilise a heart beat table).
Picture the scenario. You receive observations that the Oracle GoldenGate (OGG) replicat system that you are responsible for had fallen behind overnight and all overnight processing was performed against incorrect data. What do you do? Perhaps the observation was erroneous. How can you demonstrate this?
Submitted by Ewan on
This HowTo converts a working 32 bit installation into a 64 bit system. You keep all programs, settings and data. You start with a 32 bit system that can run 64 bit programs, and finish with a 64 bit system that can run 32 bit programs. We firstly demonstrate an upgrade from 6.0 Squeeze 32 bit to 7 Wheezy because Debian 7 is a pre-requisite.
With the recent release of Debian GNU/Linux 7.0 Wheezy, a new feature called multiarch has been introduced. The facility permits the installation of executable files (such as libraries and programs) from multiple architectures simultaneously on the same system. The primary use of this is to allow 32 bit programs to be run on a 64 bit system, but there are more interesting possibilities. We can turn this on its head, allowing 64 bit programs to run on a 32 bit system, then ultimately replace all 32 bit programs with their 64 bit equivalents. No other operating system can provide this flexible feature.
Submitted by Ewan on
This brief HOWTO shows how to take a working 32 bit 12.04 installation and convert it into a 64 bit system. You will be able to keep all your programs, settings and data. You start with a 32 bit system that can run 64 bit programs, then convert it to a 64 bit system that can run 32 bit programs.
With the upcoming release of Debian GNU/Linux wheezy, a new feature called multiarch is being introduced. The facility permits the installation of executable files (such as libraries and programs) from multiple architectures simultaneously on the same system. The primary use of this is to allow 32 bit programs to be run on a 64 bit system, but it has other uses.
With the release of Ubuntu LTS 12.04 (Precise Pangolin), this feature is available now.
Submitted by Ewan on
There are various articles describing how to install and run Debian GNU/Linux on USB flash memory on an Asus WL-500W. This guide differs in that it will provide a complete end-to-end set of instructions. All you need is an Asus WL-500W, USB flash memory (say, 2 GB in size), a computer to build the firmware and Debian root filesystem, and an Internet connection to get the source code for OpenWRT and packages for Debian.
Submitted by Ewan on
Finding information on setting up the Grandstream Handy Tone 503 (HT 503) analogue telephone adapter (ATA) for the UK on Virgin Media telephone network was a difficult and time consuming task. An overall summary is available for FreePBX. The specific settings were not covered and are summarised below.
Submitted by Ewan on
It is now time to start preparing for the Chelmsford summer beer and cider festival 2015. It starts earlier this year at 12pm (noon) on Tuesday 7th of July and finishes at 11pm on Saturday 11th July. Just as last year, the event will be held at Admirals Park, Rainsford Road, Chelmsford, Essex CM1 2LY.
Please read on or see the official CAMRA site for further information.