Tuesday, July 23, 2013

Install Goldengate on Oracle 12c Exercise

Though still Oracle Golden Gate for 12c version of database hasn't been released, nonetheless I tried playing with it and surprisingly went quite far, though at the end it failed with some OCI errors and after a while the status of extract process became abended.

The interesting thing is that if you create soft link of 12c file libnnz12.so to be used as libnnz11.so with 11g compatible Goldengate software it works without any complain.

Also the Managers at both source and destinations kept running and so is REPLICAT process.

In this exercise, I used OEL 6.4 64-bit with Oracle database 12c R1, and was done on two VM of Virtualbox.



It was purely for an attempt at hack and shouldn't be in any case tried for the production.

Source:
oracle@sourcetest goldengate]$ unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

[oracle@sourcetest goldengate]$  ls
fbo_ggs_Linux_x64_ora11g_64bit.tar
ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip
OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf
Oracle GoldenGate 11.2.1.0.1 README.doc
Oracle GoldenGate 11.2.1.0.1 README.txt

[oracle@sourcetest goldengate]$ tar -xf fbo_ggs_Linux_x64_ora11g_64bit.tar

[oracle@sourcetest lib]$ ln -s /u01/app/oracle/product/12.1.0/db_1/lib/libnnz12.so /u01/app/oracle/product/12.1.0/db_1/lib/libnnz11.so


[oracle@sourcetest lib]$ cd /u01/software/goldengate/

[oracle@sourcetest goldengate]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

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



GGSCI (sourcetest.world.com) 1>


GGSCI (sourcetest.world.com) 1> create subdirs

Creating subdirectories under current directory /u01/software/goldengate

Parameter files                /u01/software/goldengate/dirprm: already exists
Report files                   /u01/software/goldengate/dirrpt: created
Checkpoint files               /u01/software/goldengate/dirchk: created
Process status files           /u01/software/goldengate/dirpcs: created
SQL script files               /u01/software/goldengate/dirsql: created
Database definitions files     /u01/software/goldengate/dirdef: created
Extract data files             /u01/software/goldengate/dirdat: created
Temporary files                /u01/software/goldengate/dirtmp: created
Stdout files                   /u01/software/goldengate/dirout: created


GGSCI (sourcetest.world.com) 2> exit
[oracle@sourcetest goldengate]$ mkdir discard

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL> alter database add supplemental log data;

Database altered.


SQL> alter system set recyclebin=off scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  793350144 bytes
Fixed Size            2293392 bytes
Variable Size          574620016 bytes
Database Buffers      213909504 bytes
Redo Buffers            2527232 bytes
Database mounted.
Database opened.

SQL> create user ggate identified by gg default tablespace users temporary tablespace temp;

User created.

SQL> grant connect,resource,unlimited tablespace to ggate;

Grant succeeded.

SQL> grant execute on utl_file to ggate;

Grant succeeded.


[oracle@sourcetest goldengate]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

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



GGSCI (sourcetest.world.com) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED                                         


GGSCI (sourcetest.world.com) 3> edit params ./GLOBALS

GGSCHEMA ggate

GGSCI (sourcetest.world.com) 4> edit param mgr

port 7809

GGSCI (sourcetest.world.com) 5> start Manager

Manager started.


GGSCI (sourcetest.world.com) 6> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                         


GGSCI (sourcetest.world.com) 7>


GGSCI (sourcetest.world.com) 7> ADD EXTRACT ext1, TRANLOG, BEGIN NOW
EXTRACT added.

GGSCI (sourcetest.world.com) 9> ADD EXTTRAIL /u01/software/goldengate/dirdat/ss, EXTRACT EXT1
EXTTRAIL added.


GGSCI (sourcetest.world.com) 11> edit param EXT1


 extract EXT1
userid ggate, password gg
exttrail /u01/software/goldengate/dirdat/ss
discardfile /u01/software/goldengate/dirrpt/ext1.dsc, append
ddl include mapped
TABLE TEST.*;

GGSCI (sourcetest.world.com) 12> ADD EXTRACT EPUMP, EXTTRAILSOURCE /u01/software/goldengate/dirdat/ss, begin now
EXTRACT added.


GGSCI (sourcetest.world.com) 13> ADD RMTTRAIL /u01/software/goldengate/dirdat/ss, EXTRACT EPUMP
RMTTRAIL added.


edit param EPUMP

 EXTRACT EPUMP
PASSTHRU
RMTHOST 10.0.0.9, MGRPORT 7809
RMTTRAIL /u01/software/goldengate/dirdat/tt
TABLE TEST.TEST;

GGSCI (sourcetest.world.com) 2> start EXT1

Sending START request to MANAGER ...
EXTRACT EXT1 starting


GGSCI (sourcetest.world.com) 3> start EPUMP

Sending START request to MANAGER ...
EXTRACT EPUMP starting


GGSCI (sourcetest.world.com) 4> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                         
EXTRACT     ABENDED     EPUMP       00:00:00      00:04:26  
EXTRACT     STOPPED     EXT1        00:00:00      00:11:28  




Target:

[oracle@targettest goldengate]$ unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

[oracle@targettest goldengate]$  ls
fbo_ggs_Linux_x64_ora11g_64bit.tar
ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip
OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf
Oracle GoldenGate 11.2.1.0.1 README.doc
Oracle GoldenGate 11.2.1.0.1 README.txt

[oracle@targettest goldengate]$ tar -xf fbo_ggs_Linux_x64_ora11g_64bit.tar

[oracle@targettest lib]$ ln -s /u01/app/oracle/product/12.1.0/db_1/lib/libnnz12.so /u01/app/oracle/product/12.1.0/db_1/lib/libnnz11.so


[oracle@targettest lib]$ cd /u01/software/goldengate/

[oracle@targettest goldengate]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

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



GGSCI (targettest.world.com) 1>


GGSCI (targettest.world.com) 1> create subdirs

Creating subdirectories under current directory /u01/software/goldengate

Parameter files                /u01/software/goldengate/dirprm: already exists
Report files                   /u01/software/goldengate/dirrpt: created
Checkpoint files               /u01/software/goldengate/dirchk: created
Process status files           /u01/software/goldengate/dirpcs: created
SQL script files               /u01/software/goldengate/dirsql: created
Database definitions files     /u01/software/goldengate/dirdef: created
Extract data files             /u01/software/goldengate/dirdat: created
Temporary files                /u01/software/goldengate/dirtmp: created
Stdout files                   /u01/software/goldengate/dirout: created


GGSCI (targettest.world.com) 2> exit
[oracle@targettest goldengate]$ mkdir discard

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL> alter database add supplemental log data;

Database altered.


SQL> alter system set recyclebin=off scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  793350144 bytes
Fixed Size            2293392 bytes
Variable Size          574620016 bytes
Database Buffers      213909504 bytes
Redo Buffers            2527232 bytes
Database mounted.
Database opened.

SQL> create user ggate identified by gg default tablespace users temporary tablespace temp;

User created.

SQL> grant connect,resource,unlimited tablespace to ggate;

Grant succeeded.

SQL> grant execute on utl_file to ggate;

Grant succeeded.

edit params ./GLOBALS

 GGSCHEMA ggate
CHECKPOINTTABLE ggate.ctable

edit params mgr

port 7809


GGSCI (targettest.world.com) 1> dblogin USERID ggate password gg
Successfully logged into database.

GGSCI (targettest.world.com) 2> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING      



GGSCI (targettest.world.com) 3> add checkpointtable ctable

Successfully created checkpoint table ctable.

GGSCI (targettest.world.com) 4> ADD REPLICAT REP1, EXTTRAIL /u01/software/goldengate/dirdat/tt, CHECKPOINTTABLE ggate.ctable
REPLICAT added.


GGSCI (targettest.world.com) 5> alter REPLICAT REP1, begin now
REPLICAT altered.


GGSCI (targettest.world.com) 6> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          
REPLICAT    STOPPED     REP1        00:00:00      00:00:02   


GGSCI (targettest.world.com) 7> edit param REP1

 REPLICAT REP1
USERID ggate, PASSWORD gg
ASSUMETARGETDEFS
DISCARDFILE /u01/software/goldengate/dirrpt/REP1.dsc, APPEND
DDLOPTIONS REPORT
HANDLECOLLISIONS
APPLYNOOPUPDATES
DDL
MAP TEST.*, TARGET TEST.*;





GGSCI (targettest.world.com) 8> start REP1

Sending START request to MANAGER ...
REPLICAT REP1 starting


GGSCI (targettest.world.com) 9> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          
REPLICAT    RUNNING     REP1        00:00:00      00:00:01   


GGSCI (targettest.world.com) 10> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          
REPLICAT    RUNNING     REP1        00:00:00      00:00:05   



No comments: