GoldenGate

All,

I am trying replicate data between two oracle databases using golden gate.

I am trying this scenario in a single machine(two databases and golden gate are on same windows machine)

1. I have two databases PROD, UAT both are running on 11.2 oracle home.
2. Created the ggate user both the databases, and enabled supplemental logging.
3. Ran the following scripts in both databases.
SQL> @marker_setup.sql
SQL> @ddl_setup.sql
SQL> @role_setup.sql
SQL> grant GGS_GGSUSER_ROLE to ggate;
SQL> @ddl_enable.sql

4. Connected the source database (PROD) in ggsci prompt

GGSCI (home-c07402bbc5) 79> add extract ext1, tranlog, begin now
add exttrail C:\app\Bhanu\Goldengate\lt, extract ext1

edit params ext1

EXTRACT ext1
USERID ggate@PROD, PASSWORD 123456
RMTHOST home-c07402bbc5, MGRPORT 7840
rmttrail C:\app\Bhanu\Goldengate\lt
ddl include mapped objname bhanu.* // bhanu is a schema in PROD database.
TABLE bhanu.*;

5. Connected the target database(UAT) in ggsci prompt

add checkpointtable ggate.checkpoint
edit params ./GLOBALS

GGSCHEMA ggate
CHECKPOINTTABLE ggate.checkpoint

add replicat rep1, exttrail C:\app\Bhanu\Goldengate\Mt,checkpointtable ggate.checkpoint

edit params rep1

replicat rep1
ASSUMETARGETDEFS
userid ggate@UAT, password 123456
discardfile C:\app\Bhanu\Goldengate\rep1_discard.txt, append, megabytes 10
map bhanu.*, target kiran.*;

After that started the extract, replicat using

start extract ext1, start replicate rep1

Now the status.

GGSCI (home-c07402bbc5) 103> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING
EXTRACT STOPPED EXT1 00:00:00 00:11:43
REPLICAT STOPPED REP1 00:00:00 00:21:16

Can you please help me what is wrong in my setup and why extract and replicate process are not running.

Edited by: user12178861 on Nov 19, 2011 11:22 AM