Saturday, June 29, 2013

Oracle Golden Gate

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


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;

1 comment:

  1. 2016.09.28 14:20:45 [ oracle@czesany-wiatrem1:/oracle/product/12.2.0.1/gghome_1 ]
    $ 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 ]
    $

    ReplyDelete