Golden Gate obey not returning.
Hello,
I am attempting to use golden gate to go from single instance 10.2.0.4 on sparc to exadata 11.2.0.3 on linux server.
When I run the obey command on the source side in golden gate, it seems to process ok, then just hangs and never returns. There is no error produced, it just sits there staring at me, mocking me! Since this is on the 10.2.0.4 side, I will provide that information first.
I believe I have installed all the gg software correctly for each server, if anyone has seen this before or if there is a bug I am unaware of, please let me know. Here is the pertinent information.
*10G Server Information:*
dssna040-(/opt/vgi/oracle/GoldenGate)->uname -a
SunOS dssna040 5.10 Generic_147440-21 sun4u sparc SUNW,Sun-Fire
*10G GoldenGate installed software:*
dssna040-(/opt/vgi/oracle/GoldenGate)->ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Solaris, sparc, 64bit (optimized), Oracle 10g on Apr 24 2012 09:06:57
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
MGR.PRM
port 2499
--LAGREPORTMINUTES 5
--LAGINFOMINUTES 0
--LAGCRITICALSECONDS 30
PURGEOLDEXTRACTS ./dirdat/e*, USECHECKPOINTS, MINKEEPFILES 5, FREQUENCYMINUTES 60
--PURGEOLDEXTRACTS ./dirdat/t*, USECHECKPOINTS, MINKEEPFILES 5, FREQUENCYMINUTES 60
--PURGEOLDEXTRACTS ./dirdat/s*, usecheckpoints, minkeepdays 1, maxkeepdays 1
--Forces manager to restart extract, pump and replicat if they shut down
AUTORESTART ER *, RETRIES 12, WAITMINUTES 5, RESETMINUTES 60
SOURCE SIDE OBEY FILE
DBLOGIN USERID ggadmin, PASSWORD password
ADD TRANDATA stgadm.*
ADD TRANDATA dshadm.*
ADD EXTRACT e1, TRANLOG, THREADS 1, BEGIN now
ADD EXTTRAIL ./dirdat/e1, EXTRACT e1, MEGABYTES 500
ADD EXTRACT p1, EXTTRAILSOURCE ./dirdat/e1
ADD RMTTRAIL ./dirdat/t1, EXTRACT p1, MEGABYTES 500
EXTRACT FILE
extract e1
TRANLOGOPTIONS ASMUSER sys@dssna040_asm, ASMPASSWORD password, ASMBUFSIZE 28672
SETENV (ORACLE_HOME = "/opt/vgi/oracle/10.2.0.4.0/db")
USERID ggadmin@dshtst00, PASSWORD password
CACHEDIRECTORY /opt/vgi/oracle/migration_dxv1-cluster/dshtst00
EXTTRAIL ./dirdat/e1
DISCARDFILE ./dirrpt/e1.rpt, append
WILDCARDRESOLVE dynamic
table stgadm.*;
table dshadm.*;
PUMP FILE
EXTRACT p1
--RMTHOST cssna009.vanguard.com, MGRPORT 5111
RMTHOST dxv1db01.vanguard.com, MGRPORT 2499
DISCARDFILE ./dirrpt/p1.rpt, append
RMTTRAIL ./dirdat/t1
PASSTHRU
--EOFDELAYCSECS 10
--GETTRUNCATES
--REPORTCOUNT EVERY 5 minutes, rate
table stgadm.*;
table dshtst.*;