INSTALLATION DOCUMENTS BY RAVI

Showing posts with label Oracle Golden Gate. Show all posts
Showing posts with label Oracle Golden Gate. Show all posts

Saturday, December 23, 2017

Step by step oracle golden gate integrated extract

Creating OGGUSER and granting permissions:









Creating OGGSRC and granting permissions:










Creating OGGTRG and granting permissions:









Altering database supplemental log data:
















Applying patch:



















Creating parameter file:















OGG Extract:





































ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory

When we tried to start ggsci prompt in oracle golden gate some times we got the below error

ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory





To resolve this create a soft link as below








Now again try to start the manager










Step by step installing oracle golden gate

Download and stage the software
Oracle GoldenGate 12.2.0.2.2 for Oracle on Linux x86-64 (584 MB)

Installing required rpms:











Installing the Oracle Golden Gate software for the replication source

Login as oracle user

Create a directory for installing ogg for source as below




Change to software directory and run the installer as below






















Select database and click Next



















Provide the details and click next



















Click on install





































Click close to finish the installation

Installing the Oracle Golden Gate software for the replication target

Create a directory for installing ogg for target as below






Change to software directory and run the installer as below






















Click next



















Provide details and click next



















Click install





































Click close to complete the installation

Starting manager:

Login to ggsci prompt










Now start the manager as below








  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...