Dear GG experts,
I am completely green with Golden Gate, so I would like some help on why my REPLICAT process abends right after I commit rows from my source database object. I am following the writeup from Gavin Soorma -
http://gavinsoorma.com/2011/08/goldengate-replication-with-source-and-target-on-the-same-physical-host/
I am trying implement CDC on the same physical server. I have an 11g source database that is using ASM and my target is 10g database which is using traditional filesystem management. I am simply trying to map one object, ggs_owner.myobjects which I have created in both databases. Both EXTRACT and REPLICAT startup fine, but as soon as I perform an insert in the 11g database and commit the rows, my REPLICAT process abends.
Version information:
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x86, 32bit (optimized), Oracle 11g on Apr 23 2012 08:09:25
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (localhost.localdomain) 3> DBLOGIN userid ggs_owner@ora11g, password ggs_owner
Successfully logged into database.
GGSCI (localhost.localdomain) 4> VERSIONS
Operating System:
Linux
Version #1 SMP Tue Jan 4 15:24:05 EST 2011, Release 2.6.18-238.el5
Node: localhost.localdomain
Machine: i686
Database:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
GGSCI (localhost.localdomain) 7> DBLOGIN userid ggs_owner@ora10g, password ggs_owner
Successfully logged into database.
GGSCI (localhost.localdomain) 8> VERSIONS
Operating System:
Linux
Version #1 SMP Tue Jan 4 15:24:05 EST 2011, Release 2.6.18-238.el5
Node: localhost.localdomain
Machine: i686
Database:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
PRM file contents
EXTRACT Param file contents
extract extlocal
setenv (ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1")
setenv (ORACLE_SID="ora11g")
userid ggs_owner, password ggs_owner
rmthost localhost.localdomain , mgrport 7809
rmttrail ./dirdat/aa
TRANLOGOPTIONS ASMUSER sys@+ASM, ASMPASSWORD oracle
table ggs_owner.myobjects;
REPLICAT param file contents
REPLICAT replocal
SETENV (ORACLE_HOME="/opt/oracle/product/10.2.0.1")
SETENV (ORACLE_SID="ora10g")
ASSUMETARGETDEFS
USERID ggs_owner, PASSWORD ggs_owner
DISCARDFILE ./dirrpt/discard.txt, APPEND, MEGABYTES 20
MAP ggs_owner.myobjects, TARGET ggs_owner.myobjects, KEYCOLS(object_id);
Performed the following steps in GGSCI:
GGSCI (localhost.localdomain) 103> add extract extlocal tranlog begin now
EXTRACT added.
GGSCI (localhost.localdomain) 104> add rmttrail ./dirdat/aa extract extlocal
RMTTRAIL added.
GGSCI (localhost.localdomain) 105> dblogin userid ggs_owner@ora10g, password ggs_owner
Successfully logged into database.
GGSCI (localhost.localdomain) 106> add replicat replocal exttrail ./dirdat/aa
ERROR: No checkpoint table specified for ADD REPLICAT.
GGSCI (localhost.localdomain) 107> add replicat replocal exttrail ./dirdat/aa NODBCHECKPOINT
REPLICAT added.
GGSCI (localhost.localdomain) 108> dblogin userid ggs_owner@ora11g, password ggs_owner
Successfully logged into database.
GGSCI (localhost.localdomain) 109> start extract extlocal
Sending START request to MANAGER ...
EXTRACT EXTLOCAL starting
GGSCI (localhost.localdomain) 110> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTLOCAL 00:00:00 00:00:02
REPLICAT STOPPED REPLOCAL 00:00:00 00:01:27
GGSCI (localhost.localdomain) 111> start replicat replocal
Sending START request to MANAGER ...
REPLICAT REPLOCAL starting
GGSCI (localhost.localdomain) 112> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTLOCAL 00:00:00 00:00:09
REPLICAT RUNNING REPLOCAL 00:00:00 00:00:04
In another window, I perform the following:
SQL> connect ggs_owner@ora11g
Enter password:
Connected.
SQL> select count(*) from myobjects;
COUNT(*)
----------
71932
SQL> truncate table myobjects;
Table truncated.
SQL> insert into MYOBJECTS select * from DBA_OBJECTS;
71932 rows created.
SQL> commit;
Commit complete.
When I go back to GGSCI, I can see that the process has abended:
GGSCI (localhost.localdomain) 132> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTLOCAL 00:00:00 00:00:07
REPLICAT ABENDED REPLOCAL 00:00:00 00:00:02
When can I look, or what can I add to the REPLICAT param file that would help me identify the root cause.
Any help would be much appreciated.
Thanks,
Bal