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»