Preparing Environment for Oracle Golden Gate Extract and Replication

Following Steps should be done to use Oracle Golden Gate Extract and Replication.

  1. Two Servers : 1 for extract and 1 for replicat.
  2. Oracle Installation in both Server [I am using Oracle 12C Release 2]
  3. Database Creation in both Servers
  4. Listener Configuration
  5. Oracle Golden Gate Installation
  6. User Creation for Oracle Golden Gate configuration

Assumptions :

First 4 steps are already done.

So here I will start with Golden Gate Installation :

Server Details :

Process IP Hostname
Extract 192.168.1.10 extserver
Replicat 192.168.1.5 repserver

Step 1: Download Golden Gate software from oracle site

Note: I have downloaded Oracle Golden Gate 12.3

Step 2: Create a setup directory.

Step 3: Transfer Golden Gate Software to extserver using FTP.

Step 4: Unzip Golden Gate Software

Step 5: Create a directory for golden gate installation

Step 6: Change Directory to  fbo_ggs_Linux_x64_shiphome/Disk1/

Step 7: Use runInstaller to install oracle golden gate :

Step 8: Choose Oracle 12c and click on next

Step 9: Provide software location as a /u02/ggate and Database location as a db_home location :

Step 10: Verify the details and save response file if you need it for future reference and click on install :

You can check progress in this screen.

Step 11: Once the installation is completed you will get a screen saying Oracle Golden Gate Installation is completed.

Click on the close button.

Oracle Golden Gate Installation on extserver is successfully done. Perform the same steps on repserver to install oracle golden gate.

If you want to be updated with all our articles send us an Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp



Tagged:

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.