2014-12-03 Set Up goldengate1


Overview

Setting up the first system ( goldengate1 ) to investigate Oracle GoldenGate .

References

Procedure

Clone VM Image

I cloned OEL6u3 Base as Goldengate1 . This was a full clone.

Modify VM Image

I made the following changes to the Goldengate1 VM image:

  1. Increase RAM to 2GB
  2. Add a 20GB disk. This will be mounted as /u01
  3. Add a shared folder pointing to Downloads .
  4. Change the Promiscuous Mode on Network Adapter 1 to Allow All .

Initial Changes to GOLDENGATE1

Update SUDOERS

The /etc/sudoers was updated using visudo as root to include the following line:

%wheel ALL=(ALL) NOPASSWD: ALL

Update Host Name

The /etc/sysconfig/network was updated to change:

HOSTNAME=randwick.yaocm.id.au

to

HOSTNAME=goldengate1.yaocm.id.au

Update ETH1

The interface eth1 is updated to have:

  1. a static IP address of 192.168.1.150
  2. default route of 192.168.1.1
  3. DNS Servers are 192.168.1.252,10.1.1.1
  4. domain name of yaocm.id.au

Update HOSTS

Appended the following lines to /etc/hosts :

# GoldenGate Trial
192.168.1.150 goldengate1 goldengate1.yaocm.id.au
192.168.1.151 goldengate2 goldengate2.yaocm.id.au

Add Additional Storage

Initialize Physical Volume

Following the procedure in 17.3.1 Initializing and Managing Physical Volumes , I initialized the new disk drive as follows:

pvcreate /dev/sdb

Extend Volume Group

Used vgdisplay without any parameters to find the name(s) of the current volume groups. There was only one (1): vg_randwick .

Following the procedure in 17.3.2 Creating and Managing Volume Groups , I extended the existing volume group ( vg_randwick ) to include the new physical volume:

vgextend vg_randwick /dev/sdb

Create Logical Volume

Following the procedure in 17.3.3 Creating and Managing Logical Volumes , I created a new logical volume of size 12GB:

lvcreate -v --size 12g --name lv_u01 vg_randwick

Create Mount Point for Oracle Products

Create File System

Following the procedure in 18.1 Making File Systems , I formatted the new logical volume lv_u01 as follows:

mkfs -t ext4 -L oracle /dev/mapper/vg_randwick-lv_u01

Mount File System

Following the procedure in 18.2 Mounting File Systems ,

mkdir /u01
mount -t ext4 /dev/mapper/vg_randwick-lv_u01 /u01