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.

[oracle@localhost ~]$ mkdir -p /u02/setup/

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

[oracle@localhost setup]$ ll
total 332176
-rw-r--r-- 1 oracle oinstall 339837611 Oct  1 16:35 123014_fbo_ggs_Linux_x64_shiphome.zip

Step 4: Unzip Golden Gate Software

[oracle@localhost setup]$ unzip -q 123014_fbo_ggs_Linux_x64_shiphome.zip

Step 5: Create a directory for golden gate installation

[oracle@localhost setup]$ mkdir -p /u02/ggate/

Step 6: Change Directory to  fbo_ggs_Linux_x64_shiphome/Disk1/

[oracle@localhost setup]$ cd fbo_ggs_Linux_x64_shiphome/Disk1/

Step 7: Use runInstaller to install oracle golden gate :

[oracle@localhost Disk1]$ ./runInstaller 
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 11654 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 2998 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /appndb/tmp/OraInstall2018-10-01_04-39-16PM. Please wait ...

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.