01 Set Up goldengate1

Overview

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

References

• Oracle® Linux Administrator's Guide for Release 6
  • III Storage and File Systems
    • 17 Storage Management
      • 17.3 About Logical Volume Manager
        • 17.3.1 Initializing and Managing Physical Volumes
        • 17.3.2 Creating and Managing Volume Groups
        • 17.3.3 Creating and Managing Logical Volumes
    • 18 File System Administration
      • 18.1 Making File Systems
      • 18.2 Mounting File Systems
• Michael Kerrisk - man7.org
  • df
  • lvcreate
  • lvdisplay
  • mkdir
  • mkfs
  • mount
  • pvcreate
  • vgdisplay
  • vgextend

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