-
Oracle Golden Gate
Hi Friends ,
it is long time since i have accessed dbasupport forum again .
i strongly believe i will get some solution in here , as usual .
i am installing and configuring goldengate for proof of concept .
using following example
http://setijoagus.wordpress.com/2010...ce-database-3/
but for some reason extract process does not start
could suggest any solution ?
only difference is i am using 10g database on solaris
GGSCI (orcl10) 6> add exttrail /u01/app/oracle/product/gg/dirdat/lt, extract ext1
EXTTRAIL added.
GGSCI (orcl10) 7> edit params ext1
–extract group–
EXTRACT ext1
–connection to database–
USERID ggate, PASSWORD 123456
–hostname and port for trail–
RMTHOST orcl10, MGRPORT 7809
–path and name for trail–
rmttrail /u01/app/oracle/product/gg/dirdat/lt
–DDL support
ddl include mapped objname sumber.*
–DML
TABLE sumber.*;
GGSCI (orcl10) 6> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:02:48
GGSCI (orcl10) 7> start EXTRACT EXT1
GGSCI (orcl10) 8> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:03:03
siva prakash
DBA
-
-
i followed exact steps in above weblink too .
but extract process wouldn't start .
i was wondering if we are missing anything very basic step.
siva prakash
DBA
-
add exttrail /u01/app/oracle/product/gg/dirdat/lt, extract ext1
please type rt in place /dirdat/lt
Kailash Thakur
-
sure will try and let you know , i thought it is just a directory or file
should not be affected by name .
anyway will let you know .
siva prakash
DBA
-
prakashs43, can you issue the following command in GGSCI and post the result :
Code:
GGSCI> info extract ext1 detail
You can also check the report file, whose the path will be given by the above command (it is usually stored in the dirrpt subdirectory in the GoldenGate directory).
If nothing relevant shows up, take a look at the ggserr.log and the sqlnet.log.
Please keep us posted
mimidatabase
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|