Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Golden Gate: Failed to open target trail file

johnb-OracleOct 20 2010 — edited Oct 21 2010
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2010
Added on Oct 20 2010
3 comments
5,742 views