http://www.oraclegis.com
http://ggsig.blogspot.in/2012/12/golden-gate-replication-oracle-db.html --> Steps to configure Replication between Oracle->Oracle
http://oraclespot.wordpress.com/2011/06/15/oracle_goldengate/
Cannot load ICU resource bundle 'ggMessage', error code 2 - No such file or directory
http://ggsig.blogspot.in/2012/12/golden-gate-replication-oracle-db.html --> Steps to configure Replication between Oracle->Oracle
http://oraclespot.wordpress.com/2011/06/15/oracle_goldengate/
Cannot load ICU resource bundle 'ggMessage', error code 2 - No such file or directory
Move to the GG install directory and invoke ggsci..
ggsci> dblogin userid <>,password <>
-------------------------------------------------------------------------------------------------------
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=ggdb1
export GG_HOME=/u01/app/oracle/ggs/11.2.0
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$GG_HOME:$LD_LIBRARY_PATH
export PATH=GG_HOME:$ORACLE_HOME/bin:$PATH
--------------------------------------------------------------------------------
Before configuring Golden Gate at DB level:
1). Put database in archivelog mode --> Requires bounce till 11gR2, but not from 12c(Need to check).
2). Enable Supplemental Logging
SELECT SUPPLEMENTAL_DATA_LOG_MIN FROM V$DATABASE;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
2016.09.28 14:20:45 [ oracle@czesany-wiatrem1:/oracle/product/12.2.0.1/gghome_1 ]
ReplyDelete$ echo $GG_HOME
/oracle/product/12.2.0.1/gghome_1/
2016.09.28 14:20:48 [ oracle@czesany-wiatrem1:/oracle/product/12.2.0.1/gghome_1 ]
$ echo $ORACLE_HOME
/oracle/product/12.2.0.1/dbhome_1/
2016.09.28 14:20:54 [ oracle@czesany-wiatrem1:/oracle/product/12.2.0.1/gghome_1 ]
$ echo $LD_LIBRARY_PATH
/oracle/product/12.2.0.1/dbhome_1//lib:/oracle/product/12.2.0.1/gghome_1:/lib:/usr/lib
2016.09.28 14:21:00 [ oracle@czesany-wiatrem1:/oracle/product/12.2.0.1/gghome_1 ]
$ echo $PATH
/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:/oracle/product/12.2.0.1/gghome_1
2016.09.28 14:21:13 [ oracle@czesany-wiatrem1:/oracle/product/12.2.0.1/gghome_1 ]
$ export PATH=$PATH:$ORACLE_HOME/bin
2016.09.28 14:21:33 [ oracle@czesany-wiatrem1:/oracle/product/12.2.0.1/gghome_1 ]
$ echo $PATH
/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:/oracle/product/12.2.0.1/gghome_1:/oracle/product/12.2.0.1/dbhome_1//bin
2016.09.28 14:21:35 [ oracle@czesany-wiatrem1:/oracle/product/12.2.0.1/gghome_1 ]
$ cd ..
2016.09.28 14:21:38 [ oracle@czesany-wiatrem1:/oracle/product/12.2.0.1 ]
$ ggsci
Cannot load ICU resource bundle 'ggMessage', error code 2 - No such file or directory
Aborted (core dumped)
2016.09.28 14:21:40 [ oracle@czesany-wiatrem1:/oracle/product/12.2.0.1 ]
$