Golden Gate: Failed to open target trail file
All,
I am following a very simple Golden Gate Tuturial.
I have two DB servers, srv1, srv2 each with an 11gR2 DB running.
I simply want to set up one-way schema replication, plus DDL between the scott schema.
srv1 is the source
srv2 is the destination
Everytime I start the extract job, it runs briefly then abends. Here is the error in the ggserr.log file:
cat ggserr.log
-------------------
2010-10-20 15:26:36 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start extract ext1.
2010-10-20 15:26:36 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2010-10-20 15:26:37 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioning to Sequence 590, RBA 42366480.
2010-10-20 15:26:37 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioned to Sequence 590, RBA 42366480, Oct 20, 2010 11:50:13 AM.
2010-10-20 15:26:37 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 started.
2010-10-20 15:26:42 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, ext1.prm: Socket buffer size set to 27985 (flush size 27985).
2010-10-20 15:26:42 ERROR OGG-01496 Oracle GoldenGate Capture for Oracle, ext1.prm: Failed to open target trail file /u01/app/oracle/product/ggs/dirdat/lt000000, at RBA 983.
2010-10-20 15:26:42 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.
2010-10-20 15:48:32 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): send replicat.
This is the version of Golden Gate I am using:
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.0.0 Build 078
Here is the parameter file for the extract (on srv1):
extract ext1
userid ggate, password ggate
rmthost srv2, mgrport 7809
rmttrail /u01/app/oracle/product/ggs/dirdat/lt
ddl include mapped objname scott.*;
table scott.* ;
Here is the parameter file for replicat (on srv2):
replicat rep1
ASSUMETARGETDEFS
userid ggate, password ggate
discardfile /u01/app/oracle/product/ggs/discard/rep1_discard.txt, append, megabytes 10
DDL
map scott.*, target scott.*;
Seems simple enough, but I cannot get this to run. Any suggestions?
Thanks,
John