INSTALL Oracle Golden Gate 12C on Exadata USING ACFS

Good Morning Guys ! I am started on a new challenge, and my articles will be write in English Mode, because the best part of my public, and messages that I receive every day are from India, England, USA and many countrys from world.

I love the Community and promess continuing givin support and answers to a lots of mails on Spanish that I receive every week. Let’s start!

Matrix Installation

Pre Requisites

We’ll start with an summary of tasks that we need keep in mind to start with confguration and installation of Oracle Golden Gate on a RAC environment. It’s necessary :

• An a share file system, we choice ACFS (ASM Cluster File System) under grid infrastructure 12.1.0
• Oracle Golden Gate.

Creating and configuring ACFS on Exadata

When we working on an Oracle RAC environment, we must install an OGG on a cluster file system. As part of the architecture design, we choose the ACFS, but we could use NFS or DBFS.

My desicion was based on my experience with this FS and listening the council from others partners , that were used on ODA implementations.

Basically, my procedure are same that on Non Exadata Environments:

export DISPLAY=xxx.xxx.xxx.xxx:0
. oraenv
asmca
复制

On the next screen, we can see the name of the candidate DG.

Generally, we find typically three disk groups.

• We choose the DBFS_DG .

• Choose the Volume tab.
• Click the Create button to create a new Volume (remember that we need the OGG FS).
• Complete Create Volume.

1. Volume Name: ogg_exa2a
2. Disk Group: DBFS_DG
3. Size: 80 GB (Realize the necessary Capacity Planning)

• Once the creation’s process finish succesful you ‘ll see an similiar screen.

1. Check if the Volume and Volume device are rigth.

• Now,  after the Volume was created, its necessary create the ACFS.
• Choose the ASM Cluster File Systems tab.
• Chosse the Create button, at bottom.

• Complete the fields (pay attention on Mount Point, must be exist before execute the mount command).
• Remember choose the FS created on the last step.

I love check some steps on background and review the oracle logs.

It’s not necessary, but I love them =D

• Great ! Now, you need execute the following  script as root or some user that have the enough privileges.

• Here, the command execution in the firt node only, and the output.

• Good ! Here the screen with ACFS is mount !

Now, we are ready to start with the Oracle Golden Gate installation.

Well, once installed ACFS Cluster File system, continues installing to the graphical Oracle Golden Gate Product.

Before start this task, I recommend him that check the following links. Good, Lets start.

• Download the software OGG.

http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html

• Create the OGG paths.

cd /ggate
mkdir -p /ggate/OGG/11.2.0/$ORACLE_SID
mkdir -p /ggate/OGG/STAGE
复制

• Move the file V861007-01.zip to the shared file system and unzip the file.

mv  V861007-01.zip /ggate/OGG/STAGE
cd /ggate/OGG/STAGE
unzip V861007-01.zip
复制

• Set the X variables and execute the OGG installation.

cd fbo_ggs_Linux_x64_shiphome
export DISPLAY=xxx.xxx.xxx.xxx:0
export $OGG_HOME=/ggate/OGG/11.2.0/$ORACLE_SID
./runInstaller
复制

Note Tip: You have the option to realize the silent mode installation. Check Here OGG Silent Mode

• Select the Database Version Button (we choose the 11g, because we’ll replicate between 11g and 12c)

Remember, it’s depends of the site where you install the OGG binaries, you need choose the adecuated version supported to your database.

• Complete the fields:

1. Software location: $OGG_HOME , here you need input the path , where you ‘ll install the OGG binaries.
2. Start Manager Check: If yo ucheck here, when you finish the installation, the Manager OGG process ‘ll start
3. Database Location: $ORACLE_HOME
4. manager Port: The port used by OGG (Remeber enable the firewall rules)

• Click on Next button.

This screen could appear, So if you check the correct FS and all it’s rigth, you can continues without problems.

• Click on YES, if you can install the Cluster File System and create the $OGG_HOME without problems.

• Verificating the paths and Details.

1. Click on Install button.

The progress bar, indicate the steps that are running on background.

• Oracle Golden Gate was installed.

Finally Installed.

Now, login on the OGG to test if the Manager its works.

• Set the variables.

$ export ORACLE_HOME=/u01/app/dbhome/11.2.0.4/
$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib
复制

• Login and execute info all command.

$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.2.2 OGGCORE_12.2.0.2.0_PLATFORMS_170630.0419_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jun 30 2017 14:42:26
Operating system character set identified as UTF-8.
Copyright © 1995, 2017, Oracle and/or its affiliates. All rights reserved.
GGSCI (exa2adbadm01) 1>

GGSCI (exa2adbadm01) 2> INFO MANAGER
Manager is running (IP port exa2adbadm01.7809, Process ID 41704).
GGSCI (exa2adbadm01) 3> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

GGSCI (exa2adbadm01) 4> exit

复制

Are you ready for the configuration ?