Skip to Main Content

Oracle GoldenGate Capture for Oracle, load1.prm: TCP/IP error 111 (Connect

446118Mar 25 2011 — edited Mar 30 2011
Hello All,

I am new to Golden Gate, I am trying to extract data form a source database to my target but having errors, The parameter files are below

#### Source Database #####

EXTRACT load1
SETENV (ORACLE_SID=prod)
USERID ggs_owner,PASSWORD dejuva
RMTHOST 192.168.1.101,MGRPORT 7809
RMTTASK replicat,GROUP load2
TABLE sh.products;


######## Target Database ###########

REPLICAT load2
SETENV (ORACLE_SID=test)
USERID ggs_owner,PASSWORD dejuva
ASSUMETARGETDEFS
MAP sh.customers,TARGET sh.customers;

When I start extract load1 on target database i get the following error when i view the errors

Oracle GoldenGate Capture for Oracle, load1.prm: EXTRACT LOAD1 started.
2011-03-25 10:51:11 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, load1.prm: TCP/IP error 111 (Connection refused).
2011-03-25 10:51:21 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, load1.prm: TCP/IP error 111 (Connection refused).
2011-03-25 10:51:31 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, load1.prm: TCP/IP error 111 (Connection refused).
Comments
Post Details
Added on Mar 25 2011
8 comments
593 views