In this post we’ll cover step by step approach for installing Golden Gate Software on both Windows based and Unix based operating system. Below are some requirements that should be met before installing the
Golden Gate software:-
Memory Requirements:
At least between 25 and 55 Mb of RAM memory is required for each GoldenGate Replicat and Extract process. Oracle Goldengate supports up to 300 concurrent processes for Extract and Replicat per Goldengate instance. As a rule of thumb, you will need to take into consideration that at least 1–2 Extract processes and multiple Replicat processes will be required in addition to manager processes for a basic Oracle Goldengate installation. The best way to assess total memory requirement is to run the GGSCI command to view the current report file and to examine the PROCESS AVAIL VM FROM OS (min) to determine if you have sufficient swap memory for your platform.
Disk Space Requirements:
Following are some things you should do to ensure having enough disk space to support your Goldengate replication needs:
• Allocate at least 50–150 MB of disk space for the Oracle GoldenGate software binaries.
• Allocate 40 MB of disk space per instance of Goldengate for working directories and files per server. For a basic configuration with Oracle Goldengate, you will need to allocate 40 MB on the source and 40 MB on the target system for a total requirement of 80 MB of disk space.
• Allocate sufficient disk space to temporary files to accommodate GoldenGate operations. By default, Goldengate stores temporary files in the dirtmp directory under the default installation directory. A good rule of thumb to use for temp file space is around 10 GB of disk space.
• Plan on at least 10 MB per trail file. As a rule of thumb, we recommend that you start with at least 1 GB of disk space allocated per system for trail files. Alternatively, use the following formula that Oracle provides to determine the amount of disk space to set aside:
[log volume in one hour] x [number of hours downtime] x 0.4 = trail disk space.
One way to calculate the total amount required for trail file space is by querying the V$ARCHIVED_LOG view from within the source Oracle database. The following query shows you how to do so:
SQL>select trunc(COMPLETION_TIME),count(*)*100 size_in_MB
from v$archived_log
group by trunc(COMPLETION_TIME);
TRUNC(COM SIZE_IN_MB
--------- ----------
15-MAY-11 500
Run tests after installing Goldengate to measure your specific transaction mix and
load, and to gauge the total disk space required for trail files.
Network Requirements:
Since Oracle Goldengate software operates between source and target systems over networks, you must configure TCP/IP networking to accommodate all hosts within DNS to include host names that will be included in the Oracle Goldengate infrastructure deployed. In the event of firewalls, hosts must be allowed to send and receive data for open ports that the manager, Extract, and Replicat processes require access to in order to send and receive data. This range of ports must be allocated for the Goldengate environments. Also allocate ports for Goldengate manager, Extract, and Replicat processes. By default, manager uses port 7840. The recommendation is that you keep this port available. In addition, keep a record of ports allocated to Goldengate processes to avoid port conflicts.
Operating System Requirements
Linux or UNIX:
Source DB Server:ggate1
DB Name: ORCL1
Target DB Server:ggate2
DB Name: ORCL2
Download Oracle GoldenGate 12.2.0.1.1 for Oracle on Linux X86_64(454MB) Binary file from Oracle official website under Oracle GoldenGate 12.2.0.1 tab
Once we have downloaded, We need to transfer file from your local desk top to Linux Machine where source DB/Target was running
I have transffered golden gate binaries to source DB server and hosted on /home/oracle
[oracle@ggate1]$ cd /home/oracle
[oracle@ggate1]$ ls -lrt
-rw-r----- 1 oracle oinstall 475611228 Dec 31 13:02 fbo_ggs_x64_shiphome.zip
[oracle@ggate1]$ cd /home/oracle
[oracle@ggate12]$ ls -lrt
-rw-r----- 1 oracle oinstall 475611228 Dec 31 13:02 fbo_ggs_x64_shiphome.zip
Source Side Installation: goldengate1
Unzip binary file
[oracle@ggate1]$pwd
/home/oracle
[oracle@ggate1]$ unzip fbo_ggs_x64_shiphome.zip
Once we unzip tha binary file, A directory will be created with name:fbo_ggs_x64_shiphome
[oracle@ggate1]$ ls -lrt
-rw-r----- 1 oracle oinstall 475611228 Dec 31 13:02 fbo_ggs_x64_shiphome.zip
drwxr-r--r-- 1 oracle oinstall 475611228 Dec 31 13:02 fbo_ggs_x64_shiphome
Just for installation purpose, we don't require more than 5GB disk space
Once uzip file go to fbo_ggs_x64_shiphome inside directory
[oracle@ggate1]$ cd fbo_ggs_x64_shiphome
[oracle@ggate1]$ ls
Disk1
[oracle@ggate1]$ cd Disk1
[oracle@ggate1]$ ls
install responce runInstaller stage
Let us set the display as root user to enable GUI mode
[root@ggate1]# xhost+
access control disabled, clients can connect from any host
[root@ggate1]#
From 12c onwards golden gate introduced GUI based installation, Till 11gR2 it was command line installation.
Create directory for GG_HOME
[oracle@ggate1]$ cd /u01/app/oracle/product/12.1.0
[oracle@ggate1]$ mkdir ggsource1
Now run runInstaller from oracle user
[oracle@ggate1]$ cd /home/oracle/fbo_ggs_x64_shiphome/Disk1
[oracle@ggate1]$ ls
install responce runInstaller stage
[oracle@ggate1]$./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be grater than 120 MB. Actual 7109 MB Passed
Checking Swap space: must be grater than 150 MB. Actual 8190 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 167777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-05-24 10-20-35PM. Please wait...[oracle@ggate1]$
First it checks prerequesites like temp space and swap space, Once all prerequesites are passed it wll open the GUI window
Oracle 12GoldenGate binaries will support for both 12c and 11g Databases
If database is 10g or 9i or any other lower version, We need to use lower than 12c GoldenGate binaries
In our case my Oracle databse is 12
Select Oracle GoldenGate for Oracle Database 12c and then click on next button
Once we click on next button it will ask us location for software installation(GG Home),Database Location(ORACLE_HOME) and Manager port(Default-7809)
Provide Location details as below
Software Location:/u01/app/oracle/product/12.1.0/ggsource1
Database Location:/u01/app/oracle/product/12.1.0/db_1
Manager Port:7809
Select Start Manager check box
If we select Start Manager check box , Manager will start
Port 7809 should be open and provided by the network team
Once all locations defined, Click on Next button
Now it will ask us to review all Locations , Once reviewed click on install button
Now installtion in progress
Once installtion complted we will get the message "GoldedGate installation was successfuly", Now click on close
Till now installtion completed successfully
Now got to location where we have installed GG and connect GG prompt by executing ./ggsci (GoldenGate Software Command Interface)
[oracle@ggate1]$ cd /u01/app/oracle/product/12.1.0/ggsource1
[oracle@ggate1]$./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Sep 25 2015 00:31:13
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (ggate1) 1>
Now to check what processes are configured run "info all"
GGSCI (ggate1) 1>
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER Running
Target Side Installation: ggate2
Unzip binary file
[oracle@ggate2]$pwd
/home/oracle
[oracle@ggate2]$ unzip fbo_ggs_x64_shiphome.zip
Once we unzip tha binary file, A directory will be created with name:fbo_ggs_x64_shiphome
[oracle@ggate2]$ ls -lrt
-rw-r----- 1 oracle oinstall 475611228 Dec 31 13:02 fbo_ggs_x64_shiphome.zip
drwxr-r--r-- 1 oracle oinstall 475611228 Dec 31 13:02 fbo_ggs_x64_shiphome
Just for installation purpose, we don't require more than 5GB disk space
Once uzip file go to fbo_ggs_x64_shiphome inside directory
[oracle@ggate2]$ cd fbo_ggs_x64_shiphome
[oracle@ggate2]$ ls
Disk1
[oracle@ggate2]$ cd Disk1
[oracle@ggate2]$ ls
install responce runInstaller stage
Let us set the display as root user to enable GUI mode
[root@ggate2]# xhost+
access control disabled, clients can connect from any host
[root@ggate2]#
From 12c onwards golden gate introduced GUI based installation, Till 11gR2 it was command line installation.
Create directory for GG_HOME
[oracle@ggate2]$ cd /u01/app/oracle/product/12.1.0
[oracle@ggate2]$ mkdir ggtarget2
Now run runInstaller from oracle user
[oracle@ggate2]$ cd /home/oracle/fbo_ggs_x64_shiphome/Disk1
[oracle@ggate2]$ ls
install responce runInstaller stage
[oracle@ggate2]$./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be grater than 120 MB. Actual 7109 MB Passed
Checking Swap space: must be grater than 150 MB. Actual 8190 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 167777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-05-24 10-20-35PM. Please wait...[oracle@ggate2]$
First it checks prerequesites like temp space and swap space, Once all prerequesites are passed it wll open the GUI window
Oracle 12GoldenGate binaries will support for both 12c and 11g Databases
If database is 10g or 9i or any other lower version, We need to use lower than 12c GoldenGate binaries
In our case my Oracle databse is 12
Select Oracle GoldenGate for Oracle Database 12c and then click on next button
Once we click on next button it will ask us location for software installation(GG Home),Database Location(ORACLE_HOME) and Manager port(Default-7809)
Provide Location details as below
Software Location:/u01/app/oracle/product/12.1.0/ggtarget2
Database Location:/u01/app/oracle/product/12.1.0/db_1
Manager Port:7809
Select Start Manager check box
Here we will uncheck Start Manager check box
If we uncheck Start Manager check box , Port and Database location will be disabled and Manager won't start automaticall after installation
Port 7809 should be open and provided by the network team
Once all locations defined, Click on Next button
Now it will ask us to review all Locations , Once reviewed click on install button
Now installtion in progress
Once installtion complted we will get the message "GoldedGate installation was successfuly", Now click on close
Till now installtion completed successfully
Now got to location where we have installed GG and connect GG prompt by executing ./ggsci (GoldenGate Software Command Interface)
[oracle@ggate2]$ cd /u01/app/oracle/product/12.1.0/ggtarget2
[oracle@ggate2]$./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Sep 25 2015 00:31:13
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (ggate2) 1>
Now to check what processes are configured run "info all"
GGSCI (ggate2) 1>info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
Here Manager stoped , Since we have unchecked "Start Manager check box during installation process"
To start manager we need to define the port number and need to create subdirectories.
GGSCI (ggate2) 1>create subdirs
Creating subdirectories under current directory ggtarget2/u01/app/oracle/product/12.1.0/ggtarget2
Parameter files /u01/app/oracle/product/12.1.0/ggtarget2/dirprm: created
Report files /u01/app/oracle/product/12.1.0/ggtarget2/dirrpt: created
Checkpoint files /u01/app/oracle/product/12.1.0/ggtarget2/dirchk: created
Process status files /u01/app/oracle/product/12.1.0/ggtarget2/dirpcs: created
SQL script files /u01/app/oracle/product/12.1.0/ggtarget2/dirsql: created
Database definitions files /u01/app/oracle/product/12.1.0/ggtarget2/dirdef: created
Extract data files /u01/app/oracle/product/12.1.0/ggtarget2/dirdat: created
Temporary files /u01/app/oracle/product/12.1.0/ggtarget2/dirtmp: created
Credenttial store files /u01/app/oracle/product/12.1.0/ggtarget2/dircrd: created
Masterkey wallet files /u01/app/oracle/product/12.1.0/ggtarget2/dirwlt: created
Dump files /u01/app/oracle/product/12.1.0/ggtarget2/dirdmp: created
Subdirectories create , Now define port numer by editing MGR process and save and quite param file
GGSCI (ggate2) 1>edit param mgr
Now start manager and check
GGSCI (ggate2) 1>start mgr
Manager started.
GGSCI (ggate2) 1>info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
Finally Manager process is successfully running at source and target
DML Replication using GoldenGate 12c Multitenant Architecture:
Aim:Replicate data from TEST1@ORACL1 to TEST2@ORACL2
Prerequisites:
At Database Level:
At Source DB Side:
1. SQL>alter system set enable_goldengate_replication=True;
System altered.
We need to create new user for Goldengate on both source and target, Which is responsible to read data from multiple schemas.
In 12c in multitenant architecture it needs to be created on a container database.
So create a user in container database with prefix c##.
In 12c this user is common to all the pluggable presents
2. SQL>create user c##ggadmin1 identified by ggadmin1 default tablespace gg_tbps;
If it's non multitenant architecure we can use any name, no need any prefix.
3. SQL>grant dba to c##ggadmin1 container=ALL;
Grant succeeded.
We need to add supplemental logging .
4. SQL>Alter database add supplemental log data(all) columns.
Database altered.
We can check whether supplemental enabled or not using below query
SQL>select supplemental_Log_data_all from v$database;
SUP
----
YES
5. DB must be in archivelog mode.
SQL>select log_mode from v$database;
LOG_MODE
---------
ARCHIVELOG
At Target DB Side:
1. SQL>alter system set enable_goldengate_replication=True;
System altered.
2. SQL>create user c##ggadmin2 identified by ggadmin2 default tablespace gg_tbps;
3. SQL>grant dba to c##ggadmin1;
Grant succeeded.
Golden Gate software:-
Memory Requirements:
At least between 25 and 55 Mb of RAM memory is required for each GoldenGate Replicat and Extract process. Oracle Goldengate supports up to 300 concurrent processes for Extract and Replicat per Goldengate instance. As a rule of thumb, you will need to take into consideration that at least 1–2 Extract processes and multiple Replicat processes will be required in addition to manager processes for a basic Oracle Goldengate installation. The best way to assess total memory requirement is to run the GGSCI command to view the current report file and to examine the PROCESS AVAIL VM FROM OS (min) to determine if you have sufficient swap memory for your platform.
Disk Space Requirements:
Following are some things you should do to ensure having enough disk space to support your Goldengate replication needs:
• Allocate at least 50–150 MB of disk space for the Oracle GoldenGate software binaries.
• Allocate 40 MB of disk space per instance of Goldengate for working directories and files per server. For a basic configuration with Oracle Goldengate, you will need to allocate 40 MB on the source and 40 MB on the target system for a total requirement of 80 MB of disk space.
• Allocate sufficient disk space to temporary files to accommodate GoldenGate operations. By default, Goldengate stores temporary files in the dirtmp directory under the default installation directory. A good rule of thumb to use for temp file space is around 10 GB of disk space.
• Plan on at least 10 MB per trail file. As a rule of thumb, we recommend that you start with at least 1 GB of disk space allocated per system for trail files. Alternatively, use the following formula that Oracle provides to determine the amount of disk space to set aside:
[log volume in one hour] x [number of hours downtime] x 0.4 = trail disk space.
One way to calculate the total amount required for trail file space is by querying the V$ARCHIVED_LOG view from within the source Oracle database. The following query shows you how to do so:
SQL>select trunc(COMPLETION_TIME),count(*)*100 size_in_MB
from v$archived_log
group by trunc(COMPLETION_TIME);
TRUNC(COM SIZE_IN_MB
--------- ----------
15-MAY-11 500
Run tests after installing Goldengate to measure your specific transaction mix and
load, and to gauge the total disk space required for trail files.
Network Requirements:
Since Oracle Goldengate software operates between source and target systems over networks, you must configure TCP/IP networking to accommodate all hosts within DNS to include host names that will be included in the Oracle Goldengate infrastructure deployed. In the event of firewalls, hosts must be allowed to send and receive data for open ports that the manager, Extract, and Replicat processes require access to in order to send and receive data. This range of ports must be allocated for the Goldengate environments. Also allocate ports for Goldengate manager, Extract, and Replicat processes. By default, manager uses port 7840. The recommendation is that you keep this port available. In addition, keep a record of ports allocated to Goldengate processes to avoid port conflicts.
Operating System Requirements
Linux or UNIX:
Source DB Server:ggate1
DB Name: ORCL1
Target DB Server:ggate2
DB Name: ORCL2
Download Oracle GoldenGate 12.2.0.1.1 for Oracle on Linux X86_64(454MB) Binary file from Oracle official website under Oracle GoldenGate 12.2.0.1 tab
Once we have downloaded, We need to transfer file from your local desk top to Linux Machine where source DB/Target was running
I have transffered golden gate binaries to source DB server and hosted on /home/oracle
[oracle@ggate1]$ cd /home/oracle
[oracle@ggate1]$ ls -lrt
-rw-r----- 1 oracle oinstall 475611228 Dec 31 13:02 fbo_ggs_x64_shiphome.zip
[oracle@ggate1]$ cd /home/oracle
[oracle@ggate12]$ ls -lrt
-rw-r----- 1 oracle oinstall 475611228 Dec 31 13:02 fbo_ggs_x64_shiphome.zip
Source Side Installation: goldengate1
Unzip binary file
[oracle@ggate1]$pwd
/home/oracle
[oracle@ggate1]$ unzip fbo_ggs_x64_shiphome.zip
Once we unzip tha binary file, A directory will be created with name:fbo_ggs_x64_shiphome
[oracle@ggate1]$ ls -lrt
-rw-r----- 1 oracle oinstall 475611228 Dec 31 13:02 fbo_ggs_x64_shiphome.zip
drwxr-r--r-- 1 oracle oinstall 475611228 Dec 31 13:02 fbo_ggs_x64_shiphome
Just for installation purpose, we don't require more than 5GB disk space
Once uzip file go to fbo_ggs_x64_shiphome inside directory
[oracle@ggate1]$ cd fbo_ggs_x64_shiphome
[oracle@ggate1]$ ls
Disk1
[oracle@ggate1]$ cd Disk1
[oracle@ggate1]$ ls
install responce runInstaller stage
Let us set the display as root user to enable GUI mode
[root@ggate1]# xhost+
access control disabled, clients can connect from any host
[root@ggate1]#
From 12c onwards golden gate introduced GUI based installation, Till 11gR2 it was command line installation.
Create directory for GG_HOME
[oracle@ggate1]$ cd /u01/app/oracle/product/12.1.0
[oracle@ggate1]$ mkdir ggsource1
Now run runInstaller from oracle user
[oracle@ggate1]$ cd /home/oracle/fbo_ggs_x64_shiphome/Disk1
[oracle@ggate1]$ ls
install responce runInstaller stage
[oracle@ggate1]$./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be grater than 120 MB. Actual 7109 MB Passed
Checking Swap space: must be grater than 150 MB. Actual 8190 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 167777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-05-24 10-20-35PM. Please wait...[oracle@ggate1]$
First it checks prerequesites like temp space and swap space, Once all prerequesites are passed it wll open the GUI window
Oracle 12GoldenGate binaries will support for both 12c and 11g Databases
If database is 10g or 9i or any other lower version, We need to use lower than 12c GoldenGate binaries
In our case my Oracle databse is 12
Select Oracle GoldenGate for Oracle Database 12c and then click on next button
Once we click on next button it will ask us location for software installation(GG Home),Database Location(ORACLE_HOME) and Manager port(Default-7809)
Provide Location details as below
Software Location:/u01/app/oracle/product/12.1.0/ggsource1
Database Location:/u01/app/oracle/product/12.1.0/db_1
Manager Port:7809
Select Start Manager check box
If we select Start Manager check box , Manager will start
Port 7809 should be open and provided by the network team
Once all locations defined, Click on Next button
Now it will ask us to review all Locations , Once reviewed click on install button
Now installtion in progress
Once installtion complted we will get the message "GoldedGate installation was successfuly", Now click on close
Till now installtion completed successfully
Now got to location where we have installed GG and connect GG prompt by executing ./ggsci (GoldenGate Software Command Interface)
[oracle@ggate1]$ cd /u01/app/oracle/product/12.1.0/ggsource1
[oracle@ggate1]$./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Sep 25 2015 00:31:13
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (ggate1) 1>
Now to check what processes are configured run "info all"
GGSCI (ggate1) 1>
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER Running
Target Side Installation: ggate2
Unzip binary file
[oracle@ggate2]$pwd
/home/oracle
[oracle@ggate2]$ unzip fbo_ggs_x64_shiphome.zip
Once we unzip tha binary file, A directory will be created with name:fbo_ggs_x64_shiphome
[oracle@ggate2]$ ls -lrt
-rw-r----- 1 oracle oinstall 475611228 Dec 31 13:02 fbo_ggs_x64_shiphome.zip
drwxr-r--r-- 1 oracle oinstall 475611228 Dec 31 13:02 fbo_ggs_x64_shiphome
Just for installation purpose, we don't require more than 5GB disk space
Once uzip file go to fbo_ggs_x64_shiphome inside directory
[oracle@ggate2]$ cd fbo_ggs_x64_shiphome
[oracle@ggate2]$ ls
Disk1
[oracle@ggate2]$ cd Disk1
[oracle@ggate2]$ ls
install responce runInstaller stage
Let us set the display as root user to enable GUI mode
[root@ggate2]# xhost+
access control disabled, clients can connect from any host
[root@ggate2]#
From 12c onwards golden gate introduced GUI based installation, Till 11gR2 it was command line installation.
Create directory for GG_HOME
[oracle@ggate2]$ cd /u01/app/oracle/product/12.1.0
[oracle@ggate2]$ mkdir ggtarget2
Now run runInstaller from oracle user
[oracle@ggate2]$ cd /home/oracle/fbo_ggs_x64_shiphome/Disk1
[oracle@ggate2]$ ls
install responce runInstaller stage
[oracle@ggate2]$./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be grater than 120 MB. Actual 7109 MB Passed
Checking Swap space: must be grater than 150 MB. Actual 8190 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 167777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-05-24 10-20-35PM. Please wait...[oracle@ggate2]$
First it checks prerequesites like temp space and swap space, Once all prerequesites are passed it wll open the GUI window
Oracle 12GoldenGate binaries will support for both 12c and 11g Databases
If database is 10g or 9i or any other lower version, We need to use lower than 12c GoldenGate binaries
In our case my Oracle databse is 12
Select Oracle GoldenGate for Oracle Database 12c and then click on next button
Once we click on next button it will ask us location for software installation(GG Home),Database Location(ORACLE_HOME) and Manager port(Default-7809)
Provide Location details as below
Software Location:/u01/app/oracle/product/12.1.0/ggtarget2
Database Location:/u01/app/oracle/product/12.1.0/db_1
Manager Port:7809
Select Start Manager check box
Here we will uncheck Start Manager check box
If we uncheck Start Manager check box , Port and Database location will be disabled and Manager won't start automaticall after installation
Port 7809 should be open and provided by the network team
Once all locations defined, Click on Next button
Now it will ask us to review all Locations , Once reviewed click on install button
Now installtion in progress
Once installtion complted we will get the message "GoldedGate installation was successfuly", Now click on close
Till now installtion completed successfully
Now got to location where we have installed GG and connect GG prompt by executing ./ggsci (GoldenGate Software Command Interface)
[oracle@ggate2]$ cd /u01/app/oracle/product/12.1.0/ggtarget2
[oracle@ggate2]$./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Sep 25 2015 00:31:13
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (ggate2) 1>
Now to check what processes are configured run "info all"
GGSCI (ggate2) 1>info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
Here Manager stoped , Since we have unchecked "Start Manager check box during installation process"
To start manager we need to define the port number and need to create subdirectories.
GGSCI (ggate2) 1>create subdirs
Creating subdirectories under current directory ggtarget2/u01/app/oracle/product/12.1.0/ggtarget2
Parameter files /u01/app/oracle/product/12.1.0/ggtarget2/dirprm: created
Report files /u01/app/oracle/product/12.1.0/ggtarget2/dirrpt: created
Checkpoint files /u01/app/oracle/product/12.1.0/ggtarget2/dirchk: created
Process status files /u01/app/oracle/product/12.1.0/ggtarget2/dirpcs: created
SQL script files /u01/app/oracle/product/12.1.0/ggtarget2/dirsql: created
Database definitions files /u01/app/oracle/product/12.1.0/ggtarget2/dirdef: created
Extract data files /u01/app/oracle/product/12.1.0/ggtarget2/dirdat: created
Temporary files /u01/app/oracle/product/12.1.0/ggtarget2/dirtmp: created
Credenttial store files /u01/app/oracle/product/12.1.0/ggtarget2/dircrd: created
Masterkey wallet files /u01/app/oracle/product/12.1.0/ggtarget2/dirwlt: created
Dump files /u01/app/oracle/product/12.1.0/ggtarget2/dirdmp: created
Subdirectories create , Now define port numer by editing MGR process and save and quite param file
GGSCI (ggate2) 1>edit param mgr
Now start manager and check
GGSCI (ggate2) 1>start mgr
Manager started.
GGSCI (ggate2) 1>info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
Finally Manager process is successfully running at source and target
DML Replication using GoldenGate 12c Multitenant Architecture:
Aim:Replicate data from TEST1@ORACL1 to TEST2@ORACL2
Prerequisites:
At Database Level:
At Source DB Side:
1. SQL>alter system set enable_goldengate_replication=True;
System altered.
We need to create new user for Goldengate on both source and target, Which is responsible to read data from multiple schemas.
In 12c in multitenant architecture it needs to be created on a container database.
So create a user in container database with prefix c##.
In 12c this user is common to all the pluggable presents
2. SQL>create user c##ggadmin1 identified by ggadmin1 default tablespace gg_tbps;
If it's non multitenant architecure we can use any name, no need any prefix.
3. SQL>grant dba to c##ggadmin1 container=ALL;
Grant succeeded.
We need to add supplemental logging .
4. SQL>Alter database add supplemental log data(all) columns.
Database altered.
We can check whether supplemental enabled or not using below query
SQL>select supplemental_Log_data_all from v$database;
SUP
----
YES
5. DB must be in archivelog mode.
SQL>select log_mode from v$database;
LOG_MODE
---------
ARCHIVELOG
At Target DB Side:
1. SQL>alter system set enable_goldengate_replication=True;
System altered.
2. SQL>create user c##ggadmin2 identified by ggadmin2 default tablespace gg_tbps;
3. SQL>grant dba to c##ggadmin1;
Grant succeeded.
