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.
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:
- 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 !
Continuar leyendo «Oracle Golden Gate on Exadata | Configure OGG»
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.
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
- Set the X variables and execute the OGG installation.
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.
Continuar leyendo «Oracle Golden Gate on Exadata | Install OGG on 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!
|Oracle Golden Gate
|Exadata Image Version
|Oracle Grid Infrastructure
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:
On the next screen, we can see the name of the candidate DG.
Generally, we find typically three disk groups.