Oracle Golden Gate on Exadata | Configure OGG

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

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

Also for easy administration and execution of OGG command line, its recommend set the environment variables.

Usually, I set the env variables for 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 use an simple env variable script on the user home) an script.

The config used on the prevously step, avoid some error that will be 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 subdirs [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 !

2 comments on “Oracle Golden Gate on Exadata | Install OGG on ACFS”

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 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.

Golden Gate || When we start REPLICAT with AFTERCSN or ATCSN

Start REPLICAT with AFTERCSN or ATCSN ?

Buenas Tardes Amigos, esta semana estuve en un cliente donde pude observar en sus instalaciones muchos issues o configuraciones no correctas.

No es culpa del cliente en ningun momento, solamente verifico que parte del equipo tenia muchos erroes de conceptos acerca de Golden Gate como de otros productos.

En parte de mis experiencias, esta semana tuvimos que recuperar varias replicaciones por caidas de plataformas con Golden Gate que no tenian monitoreo ni contaban con politicas de backup adecuadas.

En parte de la recuperacion de las replicas, una en particular debimos hacer nuevamente los Initial Load de tablas, ya que no se encontraban los trails necesarios para aplicar.

Por parte de uno de los DBA locales surgio el siguiente cuestionamiento:

Que debemos utilizar para la comenzar la replica ?? AFTERCSN o ATCSN ??

Y mi respuesta fue:

Cuando instanciamos una nueva base de datos TARGET, con datos provenientes de un SOURCE database, el proceso de REPLICAT debe coincidir y ser coherente con el methodo que elegimos para realizar el INITIAL LOAD.

Por ello:

  • AFTERCSN es utilizado para comenzar el REPLICAT (START REPLICAT) si la metodologia escogida para instanciar el target , fue datapump.
    El export es ejecutado, y debe ser consistente en un valor FLASHBACK_SCN.
    Debe ser pasado como parametro en el archivo de par file o en la sentencia de ejecucion.

Install Oracle Golden Gate 12c on Silent Mode

oracle-goldengate-monitoring-featured

This week I had to install the Oracle Golden Gate product on a client and the DBA that was on site, was deprived of the access to a graphical environment to execute the installation with the Oracle Universal Install method.

The first thing that this young man tells me is that he had thought about uploading the software and doing the unzip and voila!

With that I would have the binaries ready to be used and start with the configurations.

But we were before a version of OGG 12c and this is not possible.

It is so that it appeals to the traditional installation in SILENT MODE.

Starting of Installation

I asked you to follow the following steps:

  1. Create the path for the software installation.
  2. Deploy the installation binaries with the unzip command.
  3. Identify the Response File.
  4. Execute the installation in silent mode.

Path for software installation

It helps to create a mnemonic path in case we will contain more instances of OGG in the future.

 /home/oracle/CDBAR/OGG_Ins1