Oracle GoldenGate Capture for Oracle, load1.prm: TCP/IP error 111 (Connect
446118Mar 25 2011 — edited Mar 30 2011Hello 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).