{"id":57020,"date":"2024-11-05T22:30:06","date_gmt":"2024-11-05T22:30:06","guid":{"rendered":"https:\/\/dbtut.com\/?p=57020"},"modified":"2024-11-05T22:30:06","modified_gmt":"2024-11-05T22:30:06","slug":"install-oracle-goldengate-12-2-0-0-0","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/","title":{"rendered":"Install Oracle GoldenGate 12.2.0.0.0"},"content":{"rendered":"

In today’s article, we will be talking about how to install Oracle GoldenGate 12.2.0.0.0.<\/p>\n

Before starting the GoldenGate installation, GRID, RDBMS and Database are installed on both SOURCE and TARGET servers.<\/p>\n

In addition, there are Schemas, Tables and data in them on the SOURCE database.<\/p>\n

After this, the steps for the GOLDENGATE installation are as follows.<\/p>\n

1. A user is created for GoldenGate on the operating system side (Source1-2, Target1-2).<\/p>\n

\/usr\/sbin\/useradd -u 503 -c \"Oracle RDBMS Owner\" -g oinstall -G dba,oper,asmdba goldengate\r\n\u00a0\r\npasswd goldengate\r\n\u00a0\r\nPassw0rd4<\/pre>\n
2. Goldengate users’ BASH_PROFILE files are set as follows (Source1-2, Target1-2).<\/p>\n
su - goldengate\r\nvi .bash_profile\r\n\u00a0\r\n\u00a0\r\n-- SOURCE1 ---------------------------------------------------------------------------------------------------------------------------------------------------\r\n\u00a0\r\n# .bash_profile\r\n\u00a0\r\n# Get the aliases and functions\r\nif [ -f ~\/.bashrc ]; then\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 . ~\/.bashrc\r\nfi\r\n\u00a0\r\n# User specific environment and startup programs\r\n\u00a0\r\nORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0\/db_1; export ORACLE_HOME\r\nORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE\r\nORACLE_SID=primary1; export ORACLE_SID\r\nCRS_HOME=\/u01\/11.2.0\/grid; export CRS_HOME\r\nOGG_HOME=\/dbpmp\/goldengate_source; export OGG_HOME\r\nLD_LIBRARY_PATH=\/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\nPATH=$ORACLE_HOME\/bin:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib:$ORACLE_HOME\/bin:$CRS_HOME\/bin:$PATH:$HOME\/bin; export PATH\r\nJAVA_HOME=\/usr\/java\/jre1.6.0_45; export JAVA_HOME\r\n\u00a0\r\n\u00a0\r\n\u00a0\r\n-- SOURCE2 ---------------------------------------------------------------------------------------------------------------------------------------------------\r\n\u00a0\r\n# .bash_profile\r\n\u00a0\r\n# Get the aliases and functions\r\nif [ -f ~\/.bashrc ]; then\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 . ~\/.bashrc\r\nfi\r\n\u00a0\r\n# User specific environment and startup programs\r\n\u00a0\r\nORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0\/db_1; export ORACLE_HOME\r\nORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE\r\nORACLE_SID=primary2; export ORACLE_SID\r\nCRS_HOME=\/u01\/11.2.0\/grid; export CRS_HOME\r\nOGG_HOME=\/dbpmp\/goldengate_source; export OGG_HOME\r\nLD_LIBRARY_PATH=\/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\nPATH=$ORACLE_HOME\/bin:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib:$ORACLE_HOME\/bin:$CRS_HOME\/bin:$PATH:$HOME\/bin; export PATH\r\nJAVA_HOME=\/usr\/java\/jre1.6.0_45; export JAVA_HOME\r\n\u00a0\r\n\u00a0\r\n-- TARGET1 ---------------------------------------------------------------------------------------------------------------------------------------------------\r\n\u00a0\r\n# .bash_profile\r\n\u00a0\r\n# Get the aliases and functions\r\nif [ -f ~\/.bashrc ]; then\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 . ~\/.bashrc\r\nfi\r\n\u00a0\r\n# User specific environment and startup programs\r\n\u00a0\r\nORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0\/db_1; export ORACLE_HOME\r\nORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE\r\nORACLE_SID=standby1; export ORACLE_SID\r\nCRS_HOME=\/u01\/11.2.0\/grid; export CRS_HOME\r\nOGG_HOME=\/dbpmp\/goldengate_target; export OGG_HOME\r\nLD_LIBRARY_PATH=\/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\nPATH=$ORACLE_HOME\/bin:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib:$ORACLE_HOME\/bin:$CRS_HOME\/bin:$PATH:$HOME\/bin; export PATH\r\nJAVA_HOME=\/usr\/java\/jre1.6.0_45; export JAVA_HOME\r\n\u00a0\r\n\u00a0\r\n\u00a0\r\n-- TARGET2 ---------------------------------------------------------------------------------------------------------------------------------------------------\r\n\u00a0\r\n# .bash_profile\r\n\u00a0\r\n# Get the aliases and functions\r\nif [ -f ~\/.bashrc ]; then\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 . ~\/.bashrc\r\nfi\r\n\u00a0\r\n# User specific environment and startup programs\r\n\u00a0\r\nORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0\/db_1; export ORACLE_HOME\r\nORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE\r\nORACLE_SID=standby2; export ORACLE_SID\r\nCRS_HOME=\/u01\/11.2.0\/grid; export CRS_HOME\r\nOGG_HOME=\/dbpmp\/goldengate_target; export OGG_HOME\r\nLD_LIBRARY_PATH=\/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\nPATH=$ORACLE_HOME\/bin:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib:$ORACLE_HOME\/bin:$CRS_HOME\/bin:$PATH:$HOME\/bin; export PATH\r\nJAVA_HOME=\/usr\/java\/jre1.6.0_45; export JAVA_HOME\r\n\u00a0\r\n\u00a0\r\n$ . .bash_profile<\/pre>\n
3. GoldenGate software needs to be installed in a SHARED area in RAC systems.<\/p>\n
Therefore, Shared areas should be MOUNTED to all servers. Shared area should be NFS. (Source1-2, Target1-2).<\/p>\n
# mkdir \/dbpmp\r\n# mount 172.20.31.245:DB_test \/dbpmp<\/pre>\n
4. The OGG_HOME folder is created on the SOURCE side (Source1-2).<\/p>\n
# mkdir -p \/dbpmp\/goldengate_source\r\n# chown -R goldengate:oinstall \/dbpmp\/goldengate_source\/\r\n# chmod -R 775 \/dbpmp\/goldengate_source<\/pre>\n
5. The OGG_HOME folder is created on the TARGET side (Target1-2).<\/p>\n
# mkdir -p \/dbpmp\/goldengate_target\r\n# chown -R goldengate:oinstall \/dbpmp\/goldengate_target\/\r\n# chmod -R 775 \/dbpmp\/goldengate_target<\/pre>\n
\"\"<\/p>\n
6. The ZIP file we downloaded is opened in the Shared area (Source1, Target1).<\/p>\n
# su - goldengate\r\n\u00a0\r\n$ cd \/dbpmp\/goldengate_source\/\r\n\u00a0\r\n$ ls\r\nfbo_ggs_Linux_x64_shiphome.zip\r\n\u00a0\r\n$ unzip fbo_ggs_Linux_x64_shiphome.zip\r\nArchive:\u00a0 fbo_ggs_Linux_x64_shiphome.zip\r\n\u00a0\u00a0 creating: fbo_ggs_Linux_x64_shiphome\/\r\n\u00a0\u00a0 creating: fbo_ggs_Linux_x64_shiphome\/Disk1\/\r\n\u00a0 inflating: fbo_ggs_Linux_x64_shiphome\/Disk1\/runInstaller\r\n\u00a0 inflating: fbo_ggs_Linux_x64_shiphome\/Disk1\/response\/oggcore.rsp\r\n\u00a0 inflating: OGG-12.2.0.1-README.txt\r\n\u00a0 inflating: OGG-12.2.0.1.1-ReleaseNotes.pdf\r\n\u00a0\r\n\u00a0\r\n\u00a0\r\n\u00a0\r\n# su - goldengate\r\n\u00a0\r\n$ cd \/dbpmp\/goldengate_target\/\r\n\u00a0\r\n$ ls\r\nfbo_ggs_Linux_x64_shiphome.zip\r\n\u00a0\r\n$ unzip fbo_ggs_Linux_x64_shiphome.zip\r\nArchive:\u00a0 fbo_ggs_Linux_x64_shiphome.zip\r\n\u00a0\u00a0 creating: fbo_ggs_Linux_x64_shiphome\/\r\n\u00a0\u00a0 creating: fbo_ggs_Linux_x64_shiphome\/Disk1\/\r\n\u00a0 inflating: fbo_ggs_Linux_x64_shiphome\/Disk1\/runInstaller\r\n\u00a0 inflating: fbo_ggs_Linux_x64_shiphome\/Disk1\/response\/oggcore.rsp\r\n\u00a0 inflating: OGG-12.2.0.1-README.txt\r\n\u00a0 inflating: OGG-12.2.0.1.1-ReleaseNotes.pdf<\/pre>\n
\"\"<\/p>\n
7. Now we can install GoldenGate on both SOURCE and TARGET sides (Source1 , Target1).<\/p>\n
# xhost +\r\n# su - goldengate\r\n$ cd \/dbpmp\/goldengate_source\/fbo_ggs_Linux_x64_shiphome\/Disk1\r\n$ .\/runInstaller<\/pre>\n
a. We perform the installation process on only 1 node on both the source and target sides.<\/p>\n
\"\"<\/p>\n
b. The database we are installing is Oracle 11g R2, I choose the second option below.<\/p>\n
\"\"<\/p>\n
c. We determine the Software location where the GoldenGate application will be installed.<\/p>\n
This location must be a SHARED area in RAC systems and must be accessible from both server sides.<\/p>\n
These locations are as follows for me;<\/p>\n
\/dbpmp\/goldengate_source\u00a0 - SOURCE taraf i\u00e7in\r\n\/dbpmp\/goldengate_target \u00a0\u00a0- TARGET taraf i\u00e7in<\/pre>\n
\"\"<\/p>\n
After determining the location where the software will be installed, the MANAGER PORT needs to be specified.<\/p>\n
I specified 7809 for source and 7810 for target.<\/p>\n
Before giving these ports, it is necessary to check if the ports below are used.<\/p>\n
$ netstat -na | grep 7809\u00a0\u00a0\u00a0 (SOURCE side control)\r\n$ netstat -na | grep 7810\u00a0\u00a0\u00a0 (TARGET side control)<\/pre>\n
\"\"<\/p>\n
f. After completing the above operations, when we pass with “NEXT”, it may give a warning as below. We can pass this with “YES”.<\/p>\n
 <\/p>\n
\"\"<\/p>\n
g. When we click the Install button, the installation will start.<\/p>\n
\"\"<\/p>\n
h. Let’s pass with “YES”.<\/p>\n
\"\"<\/p>\n
8. After the installation is completed on both sides, we check whether the MANAGER Ports are in use.<\/p>\n
(SOURCE)\r\n[goldengate@primary1 goldengate_target]$ netstat -na | grep 7809\r\ntcp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0.0.0.0:7809\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.0.0.0:*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTEN\r\n\u00a0\r\n(TARGET)\r\n[goldengate@standby1 goldengate_target]$ netstat -na | grep 7810\r\ntcp\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0.0.0.0:7810\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.0.0.0:*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTEN<\/pre>\n
9. We can control goldengate usage with GGSCI.<\/p>\n
(SOURCE)\r\nUsing username \"root\".\r\nLast login: Tue Mar 15 15:38:46 2016 from 172.25.20.17\r\n[root@primary1 ~]# su - goldengate\r\n[goldengate@primary1 ~]$ \/dbpmp\/goldengate_source\/ggsci\r\n\u00a0\r\nOracle GoldenGate Command Interpreter for Oracle\r\nVersion 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO\r\nLinux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38\r\nOperating system character set identified as UTF-8.\r\n\u00a0\r\nCopyright (C) 1995, 2015, Oracle and\/or its affiliates. All rights reserved.\r\n\u00a0\r\n\u00a0\r\n\u00a0\r\nGGSCI (primary1.hhuyanlab.local) 1> info all\r\n\u00a0\r\nProgram\u00a0\u00a0\u00a0 \u00a0Status\u00a0\u00a0\u00a0\u00a0\u00a0 Group\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Lag at Chkpt\u00a0 Time Since Chkpt\r\n\u00a0\r\nMANAGER\u00a0\u00a0\u00a0\u00a0 RUNNING\r\n\u00a0\r\n\u00a0\r\nGGSCI (primary1.hhuyanlab.local) 2> help add extract\r\n\u00a0\r\n\u00a0\r\nADD EXTRACT\r\n\u00a0\r\nUse ADD EXTRACT to create an Extract group. Unless a SOURCEISTABLE task or an alias\r\nExtract is specified, ADD EXTRACT creates an online group that uses checkpoints so that\r\nprocessing continuity is maintained from run to run.\r\n\u00a0\r\n\u00a0\r\n(TARGET)\r\nUsing username \"root\".\r\nLast login: Tue Mar 15 13:48:33 2016 from 172.25.11.19\r\n[root@standby1 ~]# su - goldengate\r\n[goldengate@standby1 ~]$ \/dbpmp\/goldengate_target\/ggsci\r\n\u00a0\r\nOracle GoldenGate Command Interpreter for Oracle\r\nVersion 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO\r\nLinux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38\r\nOperating system character set identified as UTF-8.\r\n\u00a0\r\nCopyright (C) 1995, 2015, Oracle and\/or its affiliates. All rights reserved.\r\n\u00a0\r\n\u00a0\r\n\u00a0\r\nGGSCI (standby1.hhuyanlab.local) 1> info all\r\n\u00a0\r\nProgram\u00a0\u00a0\u00a0\u00a0 Status\u00a0\u00a0\u00a0\u00a0\u00a0 Group\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Lag at Chkpt\u00a0 Time Since Chkpt\r\n\u00a0\r\nMANAGER\u00a0\u00a0\u00a0\u00a0 RUNNING\r\n\u00a0\r\n\u00a0\r\nGGSCI (standby1.hhuyanlab.local) 2> info mgr\r\n\u00a0\r\nManager is running (IP port standby1.hhuyanlab.local.7810, Process ID 26479).<\/pre>\n
10. We create a tablespace and user for GG in the Source database. Then we give DBA permission to this user (SOURCE1).<\/p>\n
[root@primary1 ~]# su - oracle\r\n[oracle@primary1 ~]$ sqlplus \/ as sysdba\r\n\u00a0\r\nSQL> create tablespace gg_tbs datafile '+DATA' size 1024M autoextend on next 100M maxsize unlimited;\r\n\u00a0\r\nTablespace created.\r\n\u00a0\r\nSQL> create user gguser identified by \"Passw0rd4\" default tablespace gg_tbs;\r\n\u00a0\r\nUser created.\r\n\u00a0\r\nSQL> grant dba to gguser;\r\n\u00a0\r\nGrant succeeded.<\/pre>\n
11. We do the same operations as above for the Target side (TARGET1).<\/p>\n
[root@standby1 ~]# su - oracle\r\n[oracle@standby1 ~]$ sqlplus \/ as sysdba\r\n\u00a0\r\nSQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 16 10:12:30 2016\r\n\u00a0\r\nCopyright (c) 1982, 2013, Oracle.\u00a0 All rights reserved.\r\n\u00a0\r\n\u00a0\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\n\u00a0\r\nSQL> create tablespace gg_tbs datafile '+DATA' size 1024M autoextend on next 100M maxsize unlimited;\r\n\u00a0\r\nTablespace created.\r\n\u00a0\r\nSQL> create user gguser identified by \"Passw0rd4\" default tablespace gg_tbs;\r\n\u00a0\r\nUser created.\r\n\u00a0\r\nSQL>\u00a0 grant dba to gguser;\r\n\u00a0\r\nGrant succeeded.<\/pre>\n
12. Putting the database in archive mode will be good for GoldenGate replication. This can be done as follows (SOURCE1).<\/p>\n
SQL> select name, total_mb, free_mb from v$asm_diskgroup;\r\n\u00a0\r\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TOTAL_MB\u00a0\u00a0\u00a0 FREE_MB\r\n------------------------------ ---------- ----------\r\nOCR_VOTE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 61419\u00a0\u00a0\u00a0\u00a0\u00a0 60493\r\nDATA\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 204796\u00a0\u00a0\u00a0\u00a0\u00a0 91888\r\nFRA\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 51199\u00a0\u00a0\u00a0\u00a0\u00a0 51104\r\n\u00a0\r\n\u00a0\r\nSQL> alter system set db_recovery_file_dest_size=45G sid='*' scope=both;\r\n\u00a0\r\nSystem altered.\r\n\u00a0\r\nSQL> alter system set db_recovery_file_dest='+FRA' sid='*' scope=both;\r\n\u00a0\r\nSystem altered.\r\n\u00a0\r\nSQL> shutdown immediate;\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\n\u00a0\r\nSQL> startup mount;\r\nORACLE instance started.\r\n\u00a0\r\nTotal System Global Area 7265497088 bytes\r\nFixed Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2267264 bytes\r\nVariable Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1342179200 bytes\r\nDatabase Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5905580032 bytes\r\nRedo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 15470592 bytes\r\nDatabase mounted.\r\n\u00a0\r\nSQL> alter database archivelog;\r\n\u00a0\r\nDatabase altered.\r\n\u00a0\r\nSQL> alter database open;\r\n\u00a0\r\nDatabase altered.\r\n\u00a0\r\nSQL> select log_mode from v$database;\r\n\u00a0\r\nLOG_MODE\r\n------------\r\nARCHIVELOG<\/pre>\n
13. We perform SUPPLEMENTAL LOGGING and FORCE LOGGING operations in the source database (SOURCE1).<\/p>\n
SQL> alter database add supplemental log data;\r\n\u00a0\r\nDatabase altered.\r\n\u00a0\r\nSQL> alter database force logging;\r\n\u00a0\r\nDatabase altered.\r\n\u00a0\r\nSQL> alter system switch logfile;\r\n\u00a0\r\nSystem altered.\r\n\u00a0\r\nSQL> select supplemental_log_data_min, force_logging from v$database;\r\n\u00a0\r\nSUPPLEME FOR\r\n-------- ---\r\nYES\u00a0\u00a0\u00a0\u00a0\u00a0 YES<\/pre>\n
14. We do the same operations as above in the Target database (TARGET1).<\/p>\n
SQL> alter database add supplemental log data;\r\n\u00a0\r\nDatabase altered.\r\n\u00a0\r\nSQL> alter database force logging;\r\n\u00a0\r\nDatabase altered.\r\n\u00a0\r\nSQL> alter system switch logfile;\r\n\u00a0\r\nSystem altered.\r\n\u00a0\r\nSQL> select supplemental_log_data_min, force_logging from v$database;\r\n\u00a0\r\nSUPPLEME FOR\r\n-------- ---\r\nYES\u00a0\u00a0\u00a0\u00a0\u00a0 YES<\/pre>\n
15. On the source side, I set the TNS file as follows (SOURCE1-2).<\/p>\n
(SOURCE1)\r\n$ vi \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/tnsnames.ora\r\n\u00a0\r\n\u00a0\r\nASM =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (DESCRIPTION =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = BEQ)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (PROGRAM = \/u01\/11.2.0\/grid\/bin\/oracle)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ARGV0 = oracle+ASM1)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(ENVS = 'ORACLE_HOME=\/u01\/11.2.0\/grid,ORACLE_SID=+ASM1')\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVICE_NAME\u00a0 = +ASM)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (INSTANCE_NAME = +ASM1)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\r\n\u00a0\r\n\t\t\u00a0\r\n\t\t\u00a0\r\n[oracle@primary1 ~]$ tnsping ASM\r\n\u00a0\r\nTNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 16-MAR-2016 14:46:45\r\n\u00a0\r\nCopyright (c) 1997, 2013, Oracle.\u00a0 All rights reserved.\r\n\u00a0\r\nUsed parameter files:\r\n\u00a0\r\n\u00a0\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = BEQ) (PROGRAM = \/u01\/11.2.0\/grid\/bin\/oracle) (ARGV0 = oracle+ASM1) (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))') (ENVS = 'ORACLE_HOME=\/u01\/11.2.0\/grid,ORACLE_SID=+ASM1')) (CONNECT_DATA = (SERVICE_NAME = +ASM) (INSTANCE_NAME = +ASM1)))\r\nOK (60 msec)\r\n\u00a0\r\n(SOURCE2)\r\n$ vi \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/tnsnames.ora\r\n\u00a0\r\n\u00a0\r\nASM =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (DESCRIPTION =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = BEQ)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (PROGRAM = \/u01\/11.2.0\/grid\/bin\/oracle)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ARGV0 = oracle+ASM1)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ENVS = 'ORACLE_HOME=\/u01\/11.2.0\/grid,ORACLE_SID=+ASM2')\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(SERVICE_NAME\u00a0 = +ASM)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (INSTANCE_NAME = +ASM2)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\r\n\u00a0\r\n\t\t\u00a0\r\n\t\t\u00a0\r\n[oracle@primary1 ~]$ tnsping ASM\r\n\u00a0\r\nTNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 16-MAR-2016 14:46:45\r\n\u00a0\r\nCopyright (c) 1997, 2013, Oracle.\u00a0 All rights reserved.\r\n\u00a0\r\nUsed parameter files:\r\n\u00a0\r\n\u00a0\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = BEQ) (PROGRAM = \/u01\/11.2.0\/grid\/bin\/oracle) (ARGV0 = oracle+ASM1) (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))') (ENVS = 'ORACLE_HOME=\/u01\/11.2.0\/grid,ORACLE_SID=+ASM1')) (CONNECT_DATA = (SERVICE_NAME = +ASM) (INSTANCE_NAME = +ASM1)))\r\nOK (60 msec)<\/pre>\n
16. On the target side, the TNS file was edited as above (TARGET1-2).<\/p>\n
(TARGET1)\r\n$ vi \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/tnsnames.ora\r\n\u00a0\r\n\u00a0\r\nASM =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (DESCRIPTION =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = BEQ)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (PROGRAM = \/u01\/11.2.0\/grid\/bin\/oracle)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ARGV0 = oracle+ASM1)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ENVS = 'ORACLE_HOME=\/u01\/11.2.0\/grid,ORACLE_SID=+ASM1')\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVICE_NAME\u00a0 = +ASM)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (INSTANCE_NAME = +ASM1)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\r\n\u00a0\r\n\t\t\u00a0\r\n\t\t\u00a0\r\n[oracle@primary1 ~]$ tnsping ASM\r\n\u00a0\r\nTNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 16-MAR-2016 14:46:45\r\n\u00a0\r\nCopyright (c) 1997, 2013, Oracle.\u00a0 All rights reserved.\r\n\u00a0\r\nUsed parameter files:\r\n\u00a0\r\n\u00a0\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = BEQ) (PROGRAM = \/u01\/11.2.0\/grid\/bin\/oracle) (ARGV0 = oracle+ASM1) (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))') (ENVS = 'ORACLE_HOME=\/u01\/11.2.0\/grid,ORACLE_SID=+ASM1')) (CONNECT_DATA = (SERVICE_NAME = +ASM) (INSTANCE_NAME = +ASM1)))\r\nOK (60 msec)\r\n\u00a0\r\n(TARGET2)\r\n$ vi \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/tnsnames.ora\r\n\u00a0\r\n\u00a0\r\nASM =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (DESCRIPTION =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ADDRESS = (PROTOCOL = BEQ)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (PROGRAM = \/u01\/11.2.0\/grid\/bin\/oracle)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ARGV0 = oracle+ASM1)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (ENVS = 'ORACLE_HOME=\/u01\/11.2.0\/grid,ORACLE_SID=+ASM2')\r\n\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (CONNECT_DATA =\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (SERVICE_NAME\u00a0 = +ASM)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (INSTANCE_NAME = +ASM2)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\r\n\u00a0\r\n\t\t\u00a0\r\n\t\t\u00a0\r\n[oracle@primary1 ~]$ tnsping ASM\r\n\u00a0\r\nTNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 16-MAR-2016 14:46:45\r\n\u00a0\r\nCopyright (c) 1997, 2013, Oracle.\u00a0 All rights reserved.\r\n\u00a0\r\nUsed parameter files:\r\n\u00a0\r\n\u00a0\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = BEQ) (PROGRAM = \/u01\/11.2.0\/grid\/bin\/oracle) (ARGV0 = oracle+ASM1) (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))') (ENVS = 'ORACLE_HOME=\/u01\/11.2.0\/grid,ORACLE_SID=+ASM1')) (CONNECT_DATA = (SERVICE_NAME = +ASM) (INSTANCE_NAME = +ASM1)))\r\nOK (60 msec)<\/pre>\n
17. The “enable_goldengate_replication” parameter in the database must be set to TRUE as shown below. Otherwise, the following error will be received (SOURCE1).<\/p>\n
[root@primary1 ~]# su - oracle\r\n[oracle@primary1 ~]$ sqlplus \/ as sysdba\r\n\u00a0\r\nSQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 16 11:08:14 2016\r\n\u00a0\r\nCopyright (c) 1982, 2013, Oracle.\u00a0 All rights reserved.\r\n\u00a0\r\n\u00a0\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\n\u00a0\r\nSQL> show parameter goldengate\r\n\u00a0\r\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\r\n------------------------------------ ----------- ------------------------------\r\nenable_goldengate_replication\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 boolean\u00a0\u00a0\u00a0\u00a0 FALSE\r\n\u00a0\r\n\u00a0\r\nSQL> alter system set enable_goldengate_replication=TRUE sid='*' scope=both;\r\n\u00a0\r\nSystem altered.<\/pre>\n
Error:<\/p>\n
2016-03-16 11:06:29\u00a0 ERROR\u00a0\u00a0 OGG-02091\u00a0 Operation not supported because enable_goldengate_replication is not set \r\nto true.<\/pre>\n
18. The value of the “enable_goldengate_replication” parameter must also be set to TRUE on the Target side. Otherwise, when REPLICAT is started, it will receive an error as above (TARGET1).<\/p>\n
[root@standby1 ~]# su - oracle\r\n[oracle@standby1 ~]$ sqlplus \/ as sysdba\r\n\u00a0\r\nSQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 16 15:58:06 2016\r\n\u00a0\r\nCopyright (c) 1982, 2013, Oracle.\u00a0 All rights reserved.\r\n\u00a0\r\n\u00a0\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\n\u00a0\r\nSQL> show parameter goldengate\r\n\u00a0\r\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\r\n------------------------------------ ----------- ------------------------------\r\nenable_goldengate_replication\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 boolean\u00a0\u00a0\u00a0\u00a0 FALSE\r\n\u00a0\r\nSQL> alter system set enable_goldengate_replication=TRUE sid='*' scope=both;\r\n\u00a0\r\nSystem altered.\r\n\u00a0\r\nSQL> show parameter goldengate\r\n\u00a0\r\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE\r\n------------------------------------ ----------- ------------------------------\r\nenable_goldengate_replication\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 boolean\u00a0\u00a0\u00a0\u00a0 TRUE<\/pre>\n
19. We create a GLOBAL parameter file in the target database with the following operations. We specify the checkpoint table in this parameter file for later use (TARGET1).<\/p>\n
[oracle@standby1 ~]$ cd \/dbpmp\/goldengate_target\/\r\n\r\n[oracle@standby1 goldengate_target]$ vi GLOBALS\r\n\u00a0\r\nCheckpointTable gguser.GGS_CHECKPOINT\r\n~\r\n~<\/pre>\n
\"\"<\/p>\n
20. On the source side, we perform the TRANDATA operation as follows (SOURCE1).<\/p>\n
[oracle@primary1 ~]$ cd $OGG_HOME\r\n[oracle@primary1 goldengate_source]$ .\/ggsci\r\n\u00a0\r\nOracle GoldenGate Command Interpreter for Oracle\r\nVersion 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO\r\nLinux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38\r\nOperating system character set identified as UTF-8.\r\n\u00a0\r\nCopyright (C) 1995, 2015, Oracle and\/or its affiliates. All rights reserved.\r\n\u00a0\r\n\u00a0\r\n\u00a0\r\nGGSCI (primary1.hhuyanlab.local) 1> info all\r\n\u00a0\r\nProgram\u00a0\u00a0\u00a0\u00a0 Status\u00a0\u00a0\u00a0\u00a0\u00a0 Group\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Lag at Chkpt\u00a0 Time Since Chkpt\r\n\u00a0\r\nMANAGER\u00a0\u00a0\u00a0\u00a0 RUNNING\r\n\u00a0\r\nGGSCI (primary1.hhuyanlab.local) 3> dblogin userid gguser@primary, password Passw0rd4\r\nSuccessfully logged into database.\r\n\u00a0\r\nGGSCI (primary1.hhuyanlab.local as gguser@primary2) 4> add trandata SCOTT.BONUS\r\n\u00a0\r\n2016-03-16 10:36:23\u00a0 WARNING OGG-06439\u00a0 No unique key is defined for table BONUS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.\r\n\u00a0\r\nLogging of supplemental redo data enabled for table SCOTT.BONUS.\r\nTRANDATA for scheduling columns has been added on table 'SCOTT.BONUS'.\r\nTRANDATA for instantiation CSN has been added on table 'SCOTT.BONUS'.\r\n\u00a0\r\n\u00a0\r\nGGSCI (primary1.hhuyanlab.local as gguser@primary2) 5> add trandata SCOTT.*\r\n\u00a0\r\n2016-03-16 10:37:05\u00a0 WARNING OGG-06439\u00a0 No unique key is defined for table BONUS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.\r\n\u00a0\r\nLogging of supplemental redo log data is already enabled for table SCOTT.BONUS.\r\n\u00a0\r\nTRANDATA for instantiation CSN has been added on table 'SCOTT.BONUS'.\r\nLogging of supplemental redo data enabled for table SCOTT.DEPT.\r\nTRANDATA for scheduling columns has been added on table 'SCOTT.DEPT'.\r\nTRANDATA for instantiation CSN has been added on table 'SCOTT.DEPT'.\r\nLogging of supplemental redo data enabled for table SCOTT.EMP.\r\nTRANDATA for scheduling columns has been added on table 'SCOTT.EMP'.\r\nTRANDATA for instantiation CSN has been added on table 'SCOTT.EMP'.\r\n2016-03-16 10:37:06\u00a0 WARNING OGG-06439\u00a0 No unique key is defined for table SALGRADE. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.\r\n\u00a0\r\nLogging of supplemental redo data enabled for table SCOTT.SALGRADE.\r\nTRANDATA for scheduling columns has been added on table 'SCOTT.SALGRADE'.\r\nTRANDATA for instantiation CSN has been added on table 'SCOTT.SALGRADE'.<\/pre>\n
21. We check the tables added to the TRANDATA transaction (SOURCE1).<\/p>\n
GGSCI (primary1.hhuyanlab.local as gguser@primary2) 6> info trandata SCOTT.*\r\n\u00a0\r\nLogging of supplemental redo log data is enabled for table SCOTT.BONUS.\r\nColumns supplementally logged for table SCOTT.BONUS: COMM, ENAME, JOB, SAL.\r\nPrepared CSN for table SCOTT.BONUS: 2242785\r\n\u00a0\r\nLogging of supplemental redo log data is enabled for table SCOTT.DEPT.\r\nColumns supplementally logged for table SCOTT.DEPT: DEPTNO.\r\nPrepared CSN for table SCOTT.DEPT: 2242830\r\n\u00a0\r\nLogging of supplemental redo log data is enabled for table SCOTT.EMP.\r\nColumns supplementally logged for table SCOTT.EMP: EMPNO.\r\nPrepared CSN for table SCOTT.EMP: 2242874\r\n\u00a0\r\nLogging of supplemental redo log data is enabled for table SCOTT.SALGRADE.\r\nColumns supplementally logged for table SCOTT.SALGRADE: GRADE, HISAL, LOSAL.\r\nPrepared CSN for table SCOTT.SALGRADE: 2242911<\/pre>\n
22. We added the SCOTT schema that we will replicate above with the TRANDATA Option. Now we create an EXTRACT for this schema (SOURCE1).<\/p>\n
GGSCI (primary1.hhuyanlab.local as gguser@primary2) 7> edit params ESCOTT\r\n\u00a0\r\nExtract ESCOTT\r\nUSERID gguser, PASSWORD Passw0rd4\r\n--TRANLOGOPTIONS DBLOGREADER\r\nTRANLOGOPTIONS ASMUSER SYS@ASM, ASMPASSWORD Passw0rd4\r\nExtTrail .\/dirdat\/ew\r\nTable SCOTT.*;\r\n\u00a0\r\n\u00a0\r\nGGSCI (primary1.hhuyanlab.local as gguser@primary2) 8> add extract ESCOTT, tranlog, threads 2, begin now\r\nEXTRACT added.\r\n\u00a0\r\n\u00a0\r\nGGSCI (primary1.hhuyanlab.local as gguser@primary2) 9> add exttrail .\/dirdat\/ew, extract ESCOTT\r\nEXTTRAIL added.<\/pre>\n
23. The EXTRACT that performs the PUMP operation is created (SOURCE1).<\/p>\n
GGSCI (primary1.hhuyanlab.local as gguser@primary2) 11> edit params psource\r\nExtract psource\r\nRmtHost 172.20.42.25, MgrPort 7810\u00a0 (172.20.42.25 -> Target IP,\u00a0 7810 -> Target MGR Port)\r\nRmtTrail .\/dirdat\/pe\r\nPassthru\r\nTable SCOTT.*;\r\n~\r\n\u00a0\r\nGGSCI (primary1.hhuyanlab.local as gguser@primary2) 12> add extract psource, ExtTrailSource .\/dirdat\/ew\r\nEXTRACT added.\r\n\u00a0\r\n\u00a0\r\nGGSCI (primary1.hhuyanlab.local as gguser@primary2) 13> add RmtTrail .\/dirdat\/pe, extract psource\r\nRMTTRAIL added.\r\n\u00a0\r\n\u00a0\r\nGGSCI (primary1.hhuyanlab.local as gguser@primary2) 14> info all\r\n\u00a0\r\nProgram\u00a0\u00a0\u00a0\u00a0 Status\u00a0\u00a0\u00a0\u00a0\u00a0 Group\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Lag at Chkpt\u00a0 Time Since Chkpt\r\n\u00a0\r\nMANAGER\u00a0\u00a0\u00a0\u00a0 RUNNING\r\nEXTRACT\u00a0\u00a0\u00a0\u00a0 STOPPED\u00a0\u00a0\u00a0\u00a0 ESCOTT\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00\u00a0\u00a0\u00a0\u00a0\u00a0 00:11:24\r\nEXTRACT\u00a0\u00a0\u00a0\u00a0 STOPPED\u00a0\u00a0\u00a0\u00a0 PSOURCE\u00a0\u00a0\u00a0\u00a0 00:00:00\u00a0\u00a0\u00a0\u00a0\u00a0 00:01:07<\/pre>\n
24. Now we can start our EXTRACT Processes (SOURCE1).<\/p>\n
GGSCI (primary1.hhuyanlab.local as gguser@primary2) 17> start escott\r\n\u00a0\r\nSending START request to MANAGER ...\r\nEXTRACT ESCOTT starting\r\n\u00a0\r\nGGSCI (primary1.hhuyanlab.local as gguser@primary2) 22> start psource\r\n\u00a0\r\nSending START request to MANAGER ...\r\nEXTRACT PSOURCE starting\r\n\u00a0\r\nGGSCI (primary1.hhuyanlab.local as gguser@primary2) 29> info all\r\n\u00a0\r\nProgram\u00a0\u00a0\u00a0\u00a0 Status\u00a0\u00a0\u00a0\u00a0\u00a0 Group\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Lag at Chkpt\u00a0 Time Since Chkpt\r\n\u00a0\r\nMANAGER\u00a0\u00a0\u00a0\u00a0 RUNNING\r\nEXTRACT\u00a0\u00a0\u00a0\u00a0 RUNNING\u00a0\u00a0\u00a0\u00a0 ESCOTT\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:04\r\nEXTRACT\u00a0\u00a0\u00a0\u00a0 RUNNING\u00a0\u00a0\u00a0\u00a0 PSOURCE\u00a0\u00a0\u00a0\u00a0 00:00:00\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:07\r\n\u00a0\r\n\u00a0\r\nGGSCI (primary1.hhuyanlab.local as gguser@primary2) 30> view report escott\r\n\u00a0\r\n\u00a0\r\n***********************************************************************\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Oracle GoldenGate Capture for Oracle\r\n\u00a0\u00a0\u00a0 Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO\r\n\u00a0\u00a0 Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 01:10:08\r\n\u00a0\r\nCopyright (C) 1995, 2015, Oracle and\/or its affiliates. All rights reserved.\r\n\u00a0\r\n\u00a0\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Starting at 2016-03-16 14:55:15\r\n***********************************************************************\r\n\u00a0\r\nOperating System Version:\r\nLinux\r\nVersion #1 SMP Wed Nov 28 21:22:00 EST 2012, Release 2.6.18-348.el5\r\nNode: primary1.hhuyanlab.local\r\nMachine: x86_64\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 soft limit\u00a0\u00a0 hard limit\r\nAddress Space Size\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\nHeap Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\nFile Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\nCPU Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\n\u00a0\r\nProcess id: 31057\r\n\u00a0\r\nDescription:\r\n\u00a0\r\n***********************************************************************\r\n**\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Running with the following parameters\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 **\r\n***********************************************************************\r\n\u00a0\r\n2016-03-16 14:55:15\u00a0 INFO\u00a0\u00a0\u00a0 OGG-03059\u00a0 Operating system character set identified as UTF-8.\r\n\u00a0\r\n2016-03-16 14:55:15\u00a0 INFO\u00a0\u00a0\u00a0 OGG-02695\u00a0 ANSI SQL parameter syntax is used for parameter parsing.\r\nExtract ESCOTT\r\nUSERID gguser, PASSWORD ***\r\n\u00a0\r\n2016-03-16 14:55:17\u00a0 INFO\u00a0\u00a0\u00a0 OGG-03522\u00a0 Setting session time zone to source database time zone 'GMT'.\r\nTRANLOGOPTIONS ASMUSER SYS@ASM, ASMPASSWORD ***\r\nExtTrail .\/dirdat\/ew\r\nTable SCOTT.*;\r\n\u00a0\r\n2016-03-16 14:55:17\u00a0 INFO\u00a0\u00a0\u00a0 OGG-01635\u00a0 BOUNDED RECOVERY: reset to initial or altered checkpoint.\r\n\u00a0\r\n2016-03-16 14:55:17\u00a0 INFO\u00a0\u00a0\u00a0 OGG-01815\u00a0 Virtual Memory Facilities for: BR\r\n\u00a0\u00a0\u00a0anon alloc: mmap(MAP_ANON)\u00a0 anon free: munmap\r\n\u00a0\u00a0\u00a0 file alloc: mmap(MAP_SHARED)\u00a0 file free: munmap\r\n\u00a0\u00a0\u00a0 target directories:\r\n\u00a0\u00a0\u00a0 \/dbpmp\/goldengate_source\/BR\/ESCOTT.\r\n\u00a0\r\nBounded Recovery Parameter:\r\nBRINTERVAL = 4HOURS\r\nBRDIR\u00a0\u00a0\u00a0\u00a0\u00a0 = \/dbpmp\/goldengate_source\r\n\u00a0\r\n2016-03-16 14:55:17\u00a0 INFO\u00a0\u00a0\u00a0 OGG-01851\u00a0 filecaching started: thread ID: 46986504534336.\r\n\u00a0\r\n2016-03-16 14:55:17\u00a0 INFO\u00a0\u00a0\u00a0 OGG-01815\u00a0 Virtual Memory Facilities for: COM\r\n\u00a0\u00a0\u00a0 anon alloc: mmap(MAP_ANON)\u00a0 anon free: munmap\r\n\u00a0\u00a0\u00a0 file alloc: mmap(MAP_SHARED)\u00a0 file free: munmap\r\n\u00a0\u00a0\u00a0 target directories:\r\n\u00a0\u00a0\u00a0 \/dbpmp\/goldengate_source\/dirtmp.\r\n\u00a0\r\nCACHEMGR virtual memory values (may have been adjusted)\r\nCACHEPAGEOUTSIZE (default):\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8M\r\nPROCESS VM AVAIL FROM OS (min):\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 128G\r\nCACHESIZEMAX (strict force to disk): \u00a0\u00a0\u00a0\u00a096G\r\n\u00a0\r\nDatabase Version:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nPL\/SQL Release 11.2.0.4.0 - Production\r\nCORE\u00a0\u00a0\u00a0 11.2.0.4.0\u00a0\u00a0\u00a0\u00a0\u00a0 Production\r\nTNS for Linux: Version 11.2.0.4.0 - Production\r\nNLSRTL Version 11.2.0.4.0 - Production\r\n\u00a0\r\nDatabase Language and Character Set:\r\nNLS_LANGUAGE\u00a0\u00a0\u00a0\u00a0 = \"AMERICAN\"\r\nNLS_TERRITORY\u00a0\u00a0\u00a0 = \"AMERICA\"\r\nNLS_CHARACTERSET = \"AL32UTF8\"\r\n\u00a0\r\nMaximum supported ASM read buffer size is 28 KB\r\n\u00a0\r\nMaximum supported ASM read buffer size is 28 KB\r\n\u00a0\r\n2016-03-16 14:55:19\u00a0 INFO\u00a0\u00a0\u00a0 OGG-02089\u00a0 Source redo compatibility version is: 11.2.0.4.0.\r\n\u00a0\r\n2016-03-16 14:55:19\u00a0 INFO\u00a0\u00a0\u00a0 OGG-00546\u00a0 Default thread stack size: 10485760.\r\n\u00a0\r\n2016-03-16 14:55:19\u00a0 INFO\u00a0\u00a0\u00a0 OGG-01515\u00a0 Positioning to begin time Mar 16, 2016 2:54:10 PM.\r\n\u00a0\r\n2016-03-16 14:55:20\u00a0 INFO\u00a0\u00a0\u00a0 OGG-01516\u00a0 Positioned to (Thread 1) Sequence 29, RBA 1175552, SCN 0.0 (0), Mar 16, 2016 2:54:10 PM.\r\n\u00a0\r\n2016-03-16 14:55:20\u00a0 INFO\u00a0\u00a0\u00a0 OGG-01515\u00a0 Positioning to begin time Mar 16, 2016 2:54:10 PM.\r\n\u00a0\r\n2016-03-16 14:55:22\u00a0 INFO \u00a0\u00a0\u00a0OGG-01516\u00a0 Positioned to (Thread 2) Sequence 16, RBA 31788032, SCN 0.0 (0), Mar 16, 2016 2:54:10 PM.\r\n\u00a0\r\n2016-03-16 14:55:22\u00a0 INFO\u00a0\u00a0\u00a0 OGG-01517\u00a0 Position of first record processed for Thread 2, Sequence 16, RBA 31788048, SCN 0.2324041 (2324041), Mar 16, 2016 2:54:11 PM.\r\n\u00a0\r\n2016-03-16 14:55:22\u00a0 INFO\u00a0\u00a0\u00a0 OGG-01517\u00a0 Position of first record processed for Thread 1, Sequence 29, RBA 1175568, SCN 0.2324039 (2324039), Mar 16, 2016 2:54:10 PM.\r\n\u00a0\r\n2016-03-16 14:55:22\u00a0 INFO\u00a0\u00a0\u00a0 OGG-01052\u00a0 No recovery is required for target file .\/dirdat\/ew000000000, at RBA 0 (file not opened).\r\n\u00a0\r\n2016-03-16 14:55:22\u00a0 INFO\u00a0\u00a0\u00a0 OGG-01478\u00a0 Output file .\/dirdat\/ew is using format RELEASE 12.2.\r\n\u00a0\r\n***********************************************************************\r\n**\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Run Time Messages\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 **\r\n***********************************************************************<\/pre>\n
25. Using the GLOBAL parameter file we created earlier, the CHECKPOINT table can be created in the Target database as follows (TARGET1).<\/p>\n
[root@standby1 ~]# su - goldengate\r\n[goldengate@standby1 ~]$ \/dbpmp\/goldengate_target\/ggsci\r\n\u00a0\r\nOracle GoldenGate Command Interpreter for Oracle\r\nVersion 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO\r\nLinux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38\r\nOperating system character set identified as UTF-8.\r\n\u00a0\r\nCopyright (C) 1995, 2015, Oracle and\/or its affiliates. All rights reserved.\r\n\u00a0\r\n\u00a0\r\n\u00a0\r\nGGSCI (standby1.hhuyanlab.local) 1> info all\r\n\u00a0\r\nProgram\u00a0\u00a0\u00a0\u00a0 Status\u00a0\u00a0\u00a0\u00a0\u00a0 Group\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Lag at Chkpt\u00a0 Time Since Chkpt\r\n\u00a0\r\nMANAGER\u00a0\u00a0\u00a0\u00a0 RUNNING\r\n\u00a0\r\nGGSCI (standby1.hhuyanlab.local) 3> dblogin userid gguser@standby, password Passw0rd4\r\nSuccessfully logged into database.\r\n\u00a0\r\nGGSCI (standby1.hhuyanlab.local as gguser@standby2) 4> Add CheckpointTable\r\n\u00a0\r\nNo checkpoint table specified. Using GLOBALS specification (gguser.GGS_CHECKPOINT)...\r\n\u00a0\r\nSuccessfully created checkpoint table gguser.GGS_CHECKPOINT.\r\n\u00a0\r\nGGSCI (standby1.hhuyanlab.local as gguser@standby2) 5> info CheckpointTable\r\n\u00a0\r\nNo checkpoint table specified. Using GLOBALS specification (gguser.GGS_CHECKPOINT)...\r\n\u00a0\r\nCheckpoint table gguser.GGS_CHECKPOINT created 2016-03-16 15:24:28.\r\n\u00a0\r\nGGSCI (standby1.hhuyanlab.local as gguser@standby2) 7> list tables gguser.gg*\r\nGGUSER.GGS_CHECKPOINT\r\nGGUSER.GGS_CHECKPOINT_LOX\r\n\u00a0\r\nFound 2 tables matching list criteria.<\/pre>\n
26. The REPLICAT that will replicate the tables of the SCOTT schema is created as follows (TARGET1).<\/p>\n
GGSCI (standby1.hhuyanlab.local as gguser@standby2) 8> edit params RSCOTT\r\n\u00a0\r\nReplicat RSCOTT\r\nUSERID gguser, PASSWORD Passw0rd4\r\nAssumeTargetDefs\r\nDiscardFile .\/dirrpt\/rscott.dsc, Purge\r\n--HandleCollisions\r\n--End Runtime\r\nMAP SCOTT.DEPT, TARGET SCOTT.DEPT;\r\nMAP SCOTT.EMP, TARGET SCOTT.EMP;\r\nMAP SCOTT.SALGRADE, TARGET SCOTT.SALGRADE;\r\nMAP SCOTT.BONUS, TARGET SCOTT.BONUS;\r\n~\r\n~\r\n\u00a0\r\nGGSCI (standby1.hhuyanlab.local as gguser@standby2) 10> add replicat RSCOTT, ExtTrail .\/dirdat\/pe\r\nREPLICAT added.<\/pre>\n
27. The tables to be replicated must be created on the Target side in advance, for this the INITIAL LOAD process will be performed.<\/p>\n
The process steps are as follows.<\/p>\n
a. The export of the schema is taken according to the SCN number (SOURCE1).<\/p>\n
[root@primary1 ~]# su - oracle\r\n[oracle@primary1 ~]$ sqlplus \/ as sysdba\r\n\u00a0\r\nSQL> select to_char(current_scn) from v$database;\r\n\u00a0\r\nTO_CHAR(CURRENT_SCN)\r\n----------------------------------------\r\n2341046\r\n\u00a0\r\n\u00a0\r\n[oracle@primary1 ~]$ expdp \"'\/ as sysdba'\" directory=ggexp schemas=SCOTT dumpfile=scott.dmp logfile=scott.log flashback_scn=2341046 EXCLUDE=TRIGGER,GRANTS,POLICY,RLS_POLICY,REF_CONSTRAINT,SYNONYM,JOB,SEQUENCE,CONSTRAINT\r\n\u00a0\r\nExport: Release 11.2.0.4.0 - Production on Wed Mar 16 16:05:48 2016\r\n\u00a0\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.\u00a0 All rights reserved.\r\n\u00a0\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\nFLASHBACK automatically enabled to preserve database integrity.\r\nStarting \"SYS\".\"SYS_EXPORT_SCHEMA_01\":\u00a0 \"\/******** AS SYSDBA\" directory=ggexp schemas=SCOTT dumpfile=scott.dmp logfile=scott.log flashback_scn=2341046 EXCLUDE=TRIGGER,GRANTS,POLICY,RLS_POLICY,REF_CONSTRAINT,SYNONYM,JOB,SEQUENCE,CONSTRAINT\r\nEstimate in progress using BLOCKS method...\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\r\nTotal estimation using BLOCKS method: 192 KB\r\nProcessing object type SCHEMA_EXPORT\/USER\r\nProcessing object type SCHEMA_EXPORT\/SYSTEM_GRANT\r\nProcessing object type SCHEMA_EXPORT\/ROLE_GRANT\r\nProcessing object type SCHEMA_EXPORT\/DEFAULT_ROLE\r\nProcessing object type SCHEMA_EXPORT\/PRE_SCHEMA\/PROCACT_SCHEMA\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/PROCACT_INSTANCE\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/INDEX\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS\r\n. . exported \"SCOTT\".\"DEPT\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.929 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 rows\r\n. . exported \"SCOTT\".\"EMP\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8.562 KB\u00a0\u00a0\u00a0\u00a0\u00a0 14 rows\r\n. . exported \"SCOTT\".\"SALGRADE\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.859 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 rows\r\n. . exported \"SCOTT\".\"BONUS\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 rows\r\nMaster table \"SYS\".\"SYS_EXPORT_SCHEMA_01\" successfully loaded\/unloaded\r\n******************************************************************************\r\nDump file set for SYS.SYS_EXPORT_SCHEMA_01 is:\r\n\u00a0 \/dbpmp\/scott.dmp\r\nJob \"SYS\".\"SYS_EXPORT_SCHEMA_01\" successfully completed at Wed Mar 16 16:06:35 2016 elapsed 0 00:00:39<\/pre>\n
b. The received export target is imported into the database (TARGET1).<\/p>\n
[oracle@standby1 ~]$ impdp \"'\/ as sysdba'\" directory=ggexp dumpfile=scott.dmp\r\n\u00a0\r\nImport: Release 11.2.0.4.0 - Production on Wed Mar 16 16:37:21 2016\r\n\u00a0\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.\u00a0 All rights reserved.\r\n\u00a0\r\nConnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\nMaster table \"SYS\".\"SYS_IMPORT_FULL_01\" successfully loaded\/unloaded\r\nStarting \"SYS\".\"SYS_IMPORT_FULL_01\":\u00a0 \"\/******** AS SYSDBA\" directory=ggexp dumpfile=scott.dmp\r\nProcessing object type SCHEMA_EXPORT\/USER\r\nORA-31684: Object type USER:\"SCOTT\" already exists\r\nProcessing object type SCHEMA_EXPORT\/SYSTEM_GRANT\r\nProcessing object type SCHEMA_EXPORT\/ROLE_GRANT\r\nProcessing object type SCHEMA_EXPORT\/DEFAULT_ROLE\r\nProcessing object type SCHEMA_EXPORT\/PRE_SCHEMA\/PROCACT_SCHEMA\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/PROCACT_INSTANCE\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA\r\n. . imported \"SCOTT\".\"DEPT\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.929 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 rows\r\n. . imported \"SCOTT\".\"EMP\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8.562 KB\u00a0\u00a0\u00a0\u00a0\u00a0 14 rows\r\n. . imported \"SCOTT\".\"SALGRADE\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.859 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 rows\r\n. . imported \"SCOTT\".\"BONUS\"\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 rows\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/INDEX\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\r\nProcessing object type SCHEMA_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS\r\nJob \"SYS\".\"SYS_IMPORT_FULL_01\" completed with 1 error(s) at Wed Mar 16 16:38:45 2016 elapsed 0 00:01:01<\/pre>\n
c. RELICAT export is started from the received SCN number (TARGET1).<\/p>\n
GGSCI (standby1.hhuyanlab.local as gguser@standby2) 22> start replicat RSCOTT, aftercsn 2341046\r\n\u00a0\r\nSending START request to MANAGER ...\r\nREPLICAT RSCOTT starting<\/pre>\n
e. The status of REPLICAT is checked (TARGET1).<\/p>\n
GGSCI (standby1.hhuyanlab.local as gguser@standby2) 23> info all\r\n\u00a0\r\nProgram\u00a0\u00a0\u00a0\u00a0 Status\u00a0\u00a0\u00a0\u00a0\u00a0 Group\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0Lag at Chkpt\u00a0 Time Since Chkpt\r\n\u00a0\r\nMANAGER\u00a0\u00a0\u00a0\u00a0 RUNNING\r\nREPLICAT\u00a0\u00a0\u00a0 STARTING\u00a0\u00a0\u00a0 RSCOTT\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00\u00a0\u00a0\u00a0\u00a0\u00a0 00:48:12\r\n\u00a0\r\n\u00a0\r\nGGSCI (standby1.hhuyanlab.local as gguser@standby2) 36> info RSCOTT\r\n\u00a0\r\nREPLICAT\u00a0\u00a0 RSCOTT\u00a0\u00a0\u00a0 Last Started 2016-03-16 16:42\u00a0\u00a0 Status RUNNING\r\nCheckpoint Lag\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 (updated 00:00:03 ago)\r\nProcess ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 27380\r\nLog Read Checkpoint\u00a0 File .\/dirdat\/pe000000000\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 First Record\u00a0 RBA 0\r\n\u00a0\r\n\u00a0\r\nGGSCI (standby1.hhuyanlab.local as gguser@standby2) 37> info all\r\n\u00a0\r\nProgram\u00a0\u00a0\u00a0\u00a0 Status\u00a0\u00a0\u00a0\u00a0\u00a0 Group\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Lag at Chkpt\u00a0 Time Since Chkpt\r\n\u00a0\r\nMANAGER\u00a0\u00a0\u00a0\u00a0 RUNNING\r\nREPLICAT\u00a0\u00a0\u00a0 RUNNING\u00a0\u00a0\u00a0\u00a0 RSCOTT\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:07\r\n\u00a0\r\n\u00a0\r\n\u00a0\r\nGGSCI (standby1.hhuyanlab.local as gguser@standby2) 40> view report RSCOTT\r\n\u00a0\r\n\u00a0\r\n***********************************************************************\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Oracle GoldenGate Delivery for Oracle\r\n\u00a0\u00a0\u00a0 Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO\r\n\u00a0\u00a0 Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 01:27:04\r\n\u00a0\r\nCopyright (C) 1995, 2015, Oracle and\/or its affiliates. All rights reserved.\r\n\u00a0\r\n\u00a0\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Starting at 2016-03-16 16:42:13\r\n***********************************************************************\r\n\u00a0\r\nOperating System Version:\r\nLinux\r\nVersion #1 SMP Wed Nov 28 21:22:00 EST 2012, Release 2.6.18-348.el5\r\nNode: standby1.hhuyanlab.local\r\nMachine: x86_64\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 soft limit\u00a0\u00a0 hard limit\r\nAddress Space Size\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\nHeap Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\nFile Size\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0:\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\nCPU Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 :\u00a0\u00a0\u00a0 unlimited\u00a0\u00a0\u00a0 unlimited\r\n\u00a0\r\nProcess id: 27380\r\n\u00a0\r\nDescription:\r\n\u00a0\r\n2016-03-16 16:42:14\u00a0 WARNING OGG-02904\u00a0 Replication of PARTIAL XML containing NCHAR\/NVARCHAR\/NCLOB data may cause divergence.\r\n\u00a0\r\n***********************************************************************\r\n**\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Running with the following parameters\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 **\r\n***********************************************************************\r\n\u00a0\r\n2016-03-16 16:42:14\u00a0 INFO\u00a0\u00a0\u00a0 OGG-03059\u00a0 Operating system character set identified as US-ASCII.\r\n\u00a0\r\n2016-03-16 16:42:14\u00a0 INFO\u00a0\u00a0\u00a0 OGG-02695\u00a0 ANSI SQL parameter syntax is used for parameter parsing.\r\nReplicat RSCOTT\r\nUSERID gguser, PASSWORD ***\r\nAssumeTargetDefs\r\nDiscardFile .\/dirrpt\/rscott.dsc, Purge\r\nMAP SCOTT.DEPT, TARGET SCOTT.DEPT;\r\nMAP SCOTT.EMP, TARGET SCOTT.EMP;\r\nMAP SCOTT.SALGRADE, TARGET SCOTT.SALGRADE;\r\nMAP SCOTT.BONUS, TARGET SCOTT.BONUS;\r\n\u00a0\r\n2016-03-16 16:42:31\u00a0 INFO\u00a0\u00a0\u00a0 OGG-06451\u00a0 Triggers will be suppressed by default.\r\n\u00a0\r\n2016-03-16 16:42:31\u00a0 INFO\u00a0\u00a0\u00a0 OGG-01815\u00a0 Virtual Memory Facilities for: COM\r\n\u00a0\u00a0\u00a0 anon alloc: mmap(MAP_ANON)\u00a0 anon free: munmap\r\n\u00a0\u00a0\u00a0 file alloc: mmap(MAP_SHARED)\u00a0 file free: munmap\r\n\u00a0\u00a0\u00a0 target directories:\r\n\u00a0\u00a0\u00a0 \/dbpmp\/goldengate_target\/dirtmp.\r\n\u00a0\r\nCACHEMGR virtual memory values (may have been adjusted)\r\nCACHEPAGEOUTSIZE (default):\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4M\r\nPROCESS VM AVAIL FROM OS (min):\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4G\r\nCACHESIZEMAX (strict force to disk):\u00a0\u00a0 3.41G\r\n\u00a0\r\nDatabase Version:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nPL\/SQL Release 11.2.0.4.0 - Production\r\nCORE\u00a0\u00a0\u00a0 11.2.0.4.0\u00a0\u00a0\u00a0\u00a0\u00a0 Production\r\nTNS for Linux: Version 11.2.0.4.0 - Production\r\nNLSRTL Version 11.2.0.4.0 - Production\r\n\u00a0\r\nDatabase Language and Character Set:\r\nNLS_LANGUAGE\u00a0\u00a0\u00a0\u00a0 = \"AMERICAN\"\r\nNLS_TERRITORY\u00a0\u00a0\u00a0 = \"AMERICA\"\r\nNLS_CHARACTERSET = \"AL32UTF8\"\r\n\u00a0\r\n***********************************************************************\r\n**\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Run Time Messages\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 **\r\n***********************************************************************\r\n\u00a0\r\n\u00a0\r\n2016-03-16 16:42:34\u00a0 INFO\u00a0\u00a0\u00a0 OGG-02243\u00a0 Opened trail file .\/dirdat\/pe000000000 at 2016-03-16 16:42:34.800300.<\/pre>\n
28. Finally, let’s check whether the data has been transferred to the other party.<\/p>\n
a. First, data is added to the replicated table on the Source side (SOURCE1).<\/p>\n
[root@primary1 ~]# su - oracle\r\n[oracle@primary1 ~]$ sqlplus \/ as sysdba\r\n\u00a0\r\nSQL> select * from SCOTT.DEPT;\r\n\u00a0\r\n\u00a0\u00a0\u00a0 DEPTNO DNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LOC\r\n---------- -------------- -------------\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10 ACCOUNTING\u00a0\u00a0\u00a0\u00a0 NEW YORK\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 20 RESEARCH\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DALLAS\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 30 SALES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CHICAGO\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 40 OPERATIONS\u00a0\u00a0\u00a0\u00a0 BOSTON\r\n\u00a0\r\n4 rows selected.\r\n\u00a0\r\n\u00a0\r\nSQL> insert into SCOTT.DEPT values (50,'SS','ISTANBUL');\r\n\u00a0\r\n1 row created.\r\n\u00a0\r\nSQL> insert into SCOTT.DEPT values (60,'XX','ISTANBUL');\r\n\u00a0\r\n1 row created.\r\n\u00a0\r\nSQL> commit;\r\n\u00a0\r\nCommit complete.<\/pre>\n
b. RBA values \u200b\u200bcan be recorded before and after the INSERT operation for control purposes (TARGET1).<\/p>\n
GGSCI (standby1.hhuyanlab.local as gguser@standby2) 39> info RSCOTT\r\n\u00a0\r\nREPLICAT\u00a0\u00a0 RSCOTT\u00a0\u00a0\u00a0 Last Started 2016-03-16 16:42\u00a0\u00a0 Status RUNNING\r\nCheckpoint Lag\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 (updated 00:00:05 ago)\r\nProcess ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 27380\r\nLog Read Checkpoint\u00a0 File .\/dirdat\/pe000000000\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 First Record\u00a0 RBA 0\r\n\u00a0\r\n\u00a0\r\n\u00a0\r\nGGSCI (standby1.hhuyanlab.local as gguser@standby2) 43> info RSCOTT\r\n\u00a0\r\nREPLICAT\u00a0 \u00a0RSCOTT\u00a0\u00a0\u00a0 Last Started 2016-03-16 16:42\u00a0\u00a0 Status RUNNING\r\nCheckpoint Lag\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 (updated 00:00:19 ago)\r\nProcess ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 27380\r\nLog Read Checkpoint\u00a0 File .\/dirdat\/pe000000000\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 First Record\u00a0 RBA 1955<\/pre>\n
c. The table is checked on the target side.<\/p>\n
[root@standby1 ~]# su - oracle\r\n[oracle@standby1 ~]$ sqlplus \/ as sysdba\r\n\u00a0\r\nSQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 16 16:50:54 2016\r\n\u00a0\r\nCopyright (c) 1982, 2013, Oracle.\u00a0 All rights reserved.\r\n\u00a0\r\n\u00a0\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\r\nData Mining and Real Application Testing options\r\n\u00a0\r\nSQL> select * from SCOTT.DEPT;\r\n\u00a0\r\n\u00a0\u00a0\u00a0 DEPTNO DNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LOC\r\n---------- -------------- -------------\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10 ACCOUNTING\u00a0\u00a0\u00a0\u00a0 NEW YORK\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 20 RESEARCH\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DALLAS\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 30 SALES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CHICAGO\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 40 OPERATIONS\u00a0\u00a0\u00a0\u00a0 BOSTON\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50 SS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ISTANBUL\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 60 XX\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ISTANBUL\r\n\u00a0\r\n6 rows selected.<\/pre>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will be talking about how to install Oracle GoldenGate 12.2.0.0.0. Before starting the GoldenGate installation, GRID, RDBMS and Database are installed on both SOURCE and TARGET servers. In addition, there are Schemas, Tables and data in them on the SOURCE database. After this, the steps for the GOLDENGATE installation are as …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":57033,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-57020","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"\nInstall Oracle GoldenGate 12.2.0.0.0 - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will be talking about how to install Oracle GoldenGate 12.2.0.0.0.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install Oracle GoldenGate 12.2.0.0.0 - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will be talking about how to install Oracle GoldenGate 12.2.0.0.0.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-05T22:30:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/11\/Ekran-goruntusu-2024-11-06-012304.png\" \/>\n\t<meta property=\"og:image:width\" content=\"724\" \/>\n\t<meta property=\"og:image:height\" content=\"332\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Install Oracle GoldenGate 12.2.0.0.0\",\"datePublished\":\"2024-11-05T22:30:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/\"},\"wordCount\":752,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/11\/Ekran-goruntusu-2024-11-06-012304.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/\",\"name\":\"Install Oracle GoldenGate 12.2.0.0.0 - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/11\/Ekran-goruntusu-2024-11-06-012304.png\",\"datePublished\":\"2024-11-05T22:30:06+00:00\",\"description\":\"In today's article, we will be talking about how to install Oracle GoldenGate 12.2.0.0.0.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/11\/Ekran-goruntusu-2024-11-06-012304.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/11\/Ekran-goruntusu-2024-11-06-012304.png\",\"width\":724,\"height\":332},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Install Oracle GoldenGate 12.2.0.0.0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Install Oracle GoldenGate 12.2.0.0.0 - Database Tutorials","description":"In today's article, we will be talking about how to install Oracle GoldenGate 12.2.0.0.0.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/","og_locale":"en_US","og_type":"article","og_title":"Install Oracle GoldenGate 12.2.0.0.0 - Database Tutorials","og_description":"In today's article, we will be talking about how to install Oracle GoldenGate 12.2.0.0.0.","og_url":"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/","og_site_name":"Database Tutorials","article_published_time":"2024-11-05T22:30:06+00:00","og_image":[{"width":724,"height":332,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/11\/Ekran-goruntusu-2024-11-06-012304.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Install Oracle GoldenGate 12.2.0.0.0","datePublished":"2024-11-05T22:30:06+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/"},"wordCount":752,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/11\/Ekran-goruntusu-2024-11-06-012304.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/","url":"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/","name":"Install Oracle GoldenGate 12.2.0.0.0 - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/11\/Ekran-goruntusu-2024-11-06-012304.png","datePublished":"2024-11-05T22:30:06+00:00","description":"In today's article, we will be talking about how to install Oracle GoldenGate 12.2.0.0.0.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/11\/Ekran-goruntusu-2024-11-06-012304.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/11\/Ekran-goruntusu-2024-11-06-012304.png","width":724,"height":332},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2024\/11\/05\/install-oracle-goldengate-12-2-0-0-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Install Oracle GoldenGate 12.2.0.0.0"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/57020","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=57020"}],"version-history":[{"count":2,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/57020\/revisions"}],"predecessor-version":[{"id":57034,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/57020\/revisions\/57034"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/57033"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=57020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=57020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=57020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}