Forum Stats

  • 3,875,196 Users
  • 2,266,853 Discussions
  • 7,912,106 Comments

Discussions

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

446118
446118 Member Posts: 403
edited Mar 30, 2011 4:48AM in GoldenGate
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).

Answers

  • stevencallan
    stevencallan Member Posts: 3,459
    From source to target, what does ping show? And the other way?

    Is the Manager running on the target?

    You have, at least, a network communication error between source and target.
  • 805180
    805180 Member Posts: 3
    edited Mar 25, 2011 10:59AM
    I have the same problem under Windows. Could anybody help.
    Communication between client and server works fine.
    Manager is running.

    Edited by: ThomasNDH on 25.03.2011 15:59
  • 446118
    446118 Member Posts: 403
    I was able to resolve the problem.

    I find out the port 7086 was not opened on both servers so it couldnt connects

    So i went to /etc/services and made use of a port that was opened but not in use.

    check if ur port is configured by running command

    netstat -nap |grep port_number

    Let me know if that helps
  • stevencallan
    stevencallan Member Posts: 3,459
    edited Mar 25, 2011 11:10AM
    Pinging is just the first step. Checking for port availability is the next. You can use telnet to check for a port being accessible.

    "To use Oracle GoldenGate, you must configure the Manager process. You must specify
    a TCP/IP port for Manager to use, and you can specify optional parameters that control
    dynamic port assignments, trail file maintenance, and other properties."

    That would imply you need to be to reach/access the ports involved.
  • 749063
    749063 Member Posts: 3
    edited Mar 29, 2011 8:06PM
    jollyx,

    I have setup two linux servers lnx01,lnx02(virtual machine). I have setup the extract,replicat as you mentioned in your post. But, my test.emp from source is not loading the target test.emp table. Its is abending with the following error. I believe it is connection refused error. I have tried using the following command to open a port, but not luck:(can you please shed some showers ?). Can you please explain how to open a port and which port I have to oepn ? please below source and target managers and extract files:


    [[email protected] ~]# iptables -A INPUT -i eth0 -p tcp sport 7840 -m state state ESTABLISHED -j ACCEPT
    [[email protected] ~]# iptables -F

    The ggserr.log out is:
    2011-03-28 17:50:02 GGS INFO 302 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT LOAD1 starting.
    2011-03-28 17:50:12 GGS INFO 414 Oracle GoldenGate Capture for Oracle, load1.prm: Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.
    2011-03-28 17:50:12 GGS INFO 310 Oracle GoldenGate Capture for Oracle, load1.prm: EXTRACT LOAD1 starting.
    2011-03-28 17:50:13 GGS WARNING 109 Oracle GoldenGate Capture for Oracle, load1.prm: No unique key is defined for table EMP. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
    2011-03-28 17:50:13 GGS INFO 310 Oracle GoldenGate Capture for Oracle, load1.prm: EXTRACT LOAD1 started.
    2011-03-28 17:50:18 GGS WARNING 150 Oracle GoldenGate Capture for Oracle, load1.prm: TCP/IP error 111 (Connection refused).

    *******************Source Side********
    [[email protected] dirprm]$ cat mgr.prm
    port 7809
    userid ggs_owner,password ggs_owner
    PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/ex, USECHECKPOINTS
    [[email protected] dirprm]$ cat load1.prm
    EXTRACT load1
    USERID ggs_owner, PASSWORD ggs_owner
    RMTHOST lnx02, MGRPORT 7809
    RMTTASK replicat, GROUP load2
    TABLE TEST.EMP;

    ************Target side*********
    [[email protected] dirprm]# cat mgr.prm
    PORT 7809
    USERID ggs_owner, PASSWORD ggs_owner
    PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/ex, USECHECKPOINTS
    [[email protected] dirprm]# cat load2.prm
    REPLICAT load2
    USERID ggs_owner, PASSWORD ggs_owner
    ASSUMETARGETDEFS
    MAP test.emp, TARGET test.emp;

    Edited by: user4615959 on Mar 28, 2011 4:50 PM

    Edited by: user4615959 on Mar 29, 2011 5:05 PM
  • User152973
    User152973 Member Posts: 148
    Hi,

    You specified same port number 7809 on both source and target and so the error. Try a different port number for target like 7810 and leave the source port as 7809. Hope this works.

    Thanks.
  • 749063
    749063 Member Posts: 3
    Hi,

    I have tried by changing the Target port no: 7810 and source 7809 remains same. Still, the exists. same error. I think using same port may not be the issue.

    Any help please ?

    arza.
  • Hi,

    for sure you can use the same IP port for both source and target manager.
    But this number specifies only the port that manager itself will listen on.
    In addition you need more IP ports, one for each collector process.
    For each remote trail that you want to write to the target the manager on target will start a collector process which listens to the incoming trail data and does the actual writing of the trail file on the target.
    Please see the description of the parameter DYNAMICPORTLIST in the GoldenGate Reference Guide.
    This parameter is used in manager's configuration and determines the list or range of port numbers it shall assign to the collector processes when it starts one.
    These port numbers must be opened in your firewall.
    If you haven't specified DYNAMICPORTLIST then GoldenGate starts by default with port 7840 which is seen in your error message. If 7840 is already used by another process it tries the next one, i.e. 7841, and so on until it finds a free port number.
    So, obviously 7840 is currently blocked by your firewall.

    Regards,
    Karsten
This discussion has been closed.