Oracle Golden Gate on Exadata | Configure OGG

In the previous article  Install OGG, we noticed that the installation of the software Oracle GoldenGate finished fine and could observe that the manager runs fine.

So, We need to start with the following steps to continue with the awaited moment, replication.

Also for easy administration and execution of the OGG command line, it recommends setting the environment variables.

Usually, I set the env variables to avoid issues.

export OGG_HOME=/ggate/OGG/11.2.0/<$ORACLE_SID>
export ORACLE_HOME=/u01/app/dbhome/11.2.0.4
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$OGG_HOME

You can set it, on the .bash_profile or (I preferred using a simple env variable script on the user home) an script.

The config used in the previous step, avoid some error that will appear, for example:

./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file

Keep in mind this check:

  • tnsnames
  • Define TNS_ADMIN
  • Create sub dirs [OGG_CONSOLE]
  • Prepare the Source Database
  • Configure Parameters on Source and Target Databases for Golden Gate.
  • Configure Users on Source and Target Databases.

Let’s start!

Seguir leyendo «Oracle Golden Gate on Exadata | Configure OGG»

Oracle Golden Gate on Exadata | Install OGG on ACFS

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

Before starting this task, I recommend that check the following links. Good, let’s 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 depends on the site where you install the OGG binaries, you need to choose the adequate version supported by your database.

Seguir leyendo «Oracle Golden Gate on Exadata | Install OGG on ACFS»

Oracle Golden Gate on Exadata | Configuring ACFS

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

I love the Community and promise to continue giving support and answers to a lot of mails in Spanish that I receive every week. Let’s start!

Matrix Installation

Product Version
Oracle Golden Gate 12.2.0.2.2
Exadata Image Version 12.1.2.3.6.170713
Oracle Grid Infrastructure 12.1.0.2

Pre Requisites

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

  • As a share file system, we chose 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 decision was based on my experience with this FS and listening to the council from others partners, that was used on ODA implementations.

Basically, my procedure is 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 .