Golden Gate – Part 1 (Install)

Replication using GOLDEN GATE
-----------------------------

I have on the same server 12C and 11g, i will install GG for both. 
The idea is replicate information from Windows to Linux on Oracle Database 11g and
replicate information from Oracle 11g Linux to Oracle 12c linux (both DBs on the same Linux Server)

The first part is install GG on all servers.

Environment:
a.) Windows 64 - Oracle Database 12c Enterprise Edition
b.) Linux x86 64 - Oracle Database 11g Enterprise Edition
c.) Linux x86 64 - Oracle Database 12c Enterprise Edition - Multitenant

/etc/oratab

CDB:/oracle/product/12.1.0.2/db_1:N
+ASM:/oracle/grid:N             
db11:/oracle/product/11.2/db_1:N       

Download:
http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html
Reference:
https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/install.htm#GIORA976
Files:
Oracle GoldenGate V12.2.0.1.1 for Oracle on Linux x86-64 (454 MB)
Oracle GoldenGate V12.2.0.1.1 for Oracle on Windows (64 bit) (213 MB) 

--------------------------------------------------------------------------

1.) Linux Installation:

==> Golden Gate Home for 12c:

id
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba)
mkdir -p /oracle/product/GG/12c

export GG_HOME_12c=/oracle/product/GG/12c
export GG_HOME_11g=/oracle/product/GG/11g
-- include on .bash_profile

==> LD_LIBRARY_PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$GG_HOME_12c/11.0:$GG_HOME_11g/11.0
-- include on .bash_profile

==> Unzip

cd /data03/install
unzip fbo_ggs_Linux_x64_shiphome.zip

[oracle@lnx01 install]$ ls -ltr
total 464752
drwxr-xr-x 3 oracle oinstall      4096 Dec 12 08:58 fbo_ggs_Linux_x64_shiphome
-rw-r--r-- 1 oracle oinstall      1559 Jan 18 18:12 OGG-12.2.0.1-README.txt
-rw-r--r-- 1 oracle oinstall    282294 Jan 18 18:13 OGG-12.2.0.1.1-ReleaseNotes.pdf
-rw-r--r-- 1 oracle oinstall 475611228 Apr 12 04:46 fbo_ggs_Linux_x64_shiphome.zip

==> runInstaller - 12c

- set ENV variables for Database 12c:
ORACLE_HOME=/oracle/product/12.1.0.2/db_1
ORACLE_BASE=/oracle

- runInstaller 

[oracle@lnx01 Disk1]$ ls -ltr
total 16
drwxr-xr-x  4 oracle oinstall 4096 Dec 12 08:58 install
drwxr-xr-x 11 oracle oinstall 4096 Dec 12 08:58 stage
-rwxr-xr-x  1 oracle oinstall  918 Dec 12 08:58 runInstaller
drwxrwxr-x  2 oracle oinstall 4096 Dec 12 08:58 response
[oracle@lnx01 Disk1]$ pwd
/data03/install/fbo_ggs_Linux_x64_shiphome/Disk1

./runInstaller

- Options:
GG for 12c

Software Location: /oracle/product/GG/12c
Start Manager - checked
Database Location: $ORACLE_HOME (for 12c)
Manager Port: 7809

==> runInstaller - 11g

- set ENV variables for Database 11g:
ORACLE_HOME=/oracle/product/11.2/db_1
ORACLE_BASE=/oracle

- runInstaller

[oracle@lnx01 Disk1]$ pwd
/data03/install/fbo_ggs_Linux_x64_shiphome/Disk1
[oracle@lnx01 Disk1]$ ls -ltr
total 16
drwxr-xr-x  4 oracle oinstall 4096 Dec 12 08:58 install
drwxr-xr-x 11 oracle oinstall 4096 Dec 12 08:58 stage
-rwxr-xr-x  1 oracle oinstall  918 Dec 12 08:58 runInstaller
drwxrwxr-x  2 oracle oinstall 4096 Dec 12 08:58 response

./runInstaller

- options:
GG for 11g

Software Location: /oracle/product/GG/11g
Start Manager - checked
Database Location: $ORACLE_HOME (for 11g)
Manager Port: 7810  <-- Different port 

==> Checking:

[oracle@lnx01 Disk1]$ ps -ef | grep GG
oracle    2672     1  0 05:04 ?        00:00:00 ./mgr PARAMFILE /oracle/product/GG/12c/dirprm/mgr.prm REPORTFILE /oracle/product/GG/12c/dirrpt/MGR.rpt PROCESSID MGR USESUBDIRS
oracle    3047     1  0 05:14 ?        00:00:00 ./mgr PARAMFILE /oracle/product/GG/11g/dirprm/mgr.prm REPORTFILE /oracle/product/GG/11g/dirrpt/MGR.rpt PROCESSID MGR USESUBDIRS

At this time we have both installations OK, for 12c and 11g.
Now we need install on Windows 64

2.) Windows Installation:

- First we need to set env variables for ORACLE_HOME and ORACLE_SID:

ORACLE_HOME: d:\app\candrade\product\12.1.0\dbhome_1
ORACLE_SID: DB01

    On the Desktop or Start menu (depending on the Windows version), right-click My Computer, and then select Properties.
    In Properties, click the Advanced tab.
    Click Environment Variables.
    Under System Variables, click New.
    For Variable Name, type ORACLE_HOME.
    For Variable Value, type the path to the Oracle binaries.
    Click OK.
    Click New again.
    For Variable Name, type ORACLE_SID.
    For Variable Value, type the instance name.
    Click OK.

    - To check you can open a CMD and execute the command below:
    
    C:\Users\candrade>set | findstr /i ORACLE
    ORACLE_HOME=d:\app\candrade\product\12.1.0\dbhome_1
    ORACLE_SID=DB01

- Setup.exe

My dir: C:\Magno\Techs\GoldenGate\Soft\Windows\ggs_Windows_x64_shiphome\Disk1

GG_HOME: C:\Magno\Techs\GoldenGate\home
i put this variable also on SYSTEM VARIABLES, like we did before for ORACLE_HOME and SID

Double click on setup.exe

- option:

GG for 12c
Software Location: C:\Magno\Techs\GoldenGate\home
Start Manager: checked
Database Location: D:\app\candrade\product\12.1.0\dbhome_1
Manager Port: 7809

After installation a Window will appear with the information bellow:

***********************************************************************
                 Oracle GoldenGate Manager for Oracle
      Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401
      Windows x64 (optimized), Oracle 12c on Dec 18 2015 20:31:38

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

                    Starting at 2016-04-12 11:43:50
***********************************************************************

Operating System Version:
Microsoft Windows 8 , on x64
Version 6.2 (Build 9200)

Process id: 620

Parameters...

PORT 7809

***********************************************************************
**                     Run Time Messages                             **
***********************************************************************

2016-04-12 11:43:50  WARNING OGG-01877  Missing explicit accessrule for server collector.

2016-04-12 11:43:50  INFO    OGG-00960  Access granted (rule #26).

2016-04-12 11:43:50  INFO    OGG-00983  Manager started (port 7809).

----------------------------------------------------------------------------
Configuration steps..
Advertisements