This discussion is archived
1 2 Previous Next 17 Replies Latest reply: May 3, 2012 9:54 PM by 931360 RSS

EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking

931360 Newbie
Currently Being Moderated
i already set the golden gate and its work normally no error for several days..
but suddenly pump abended n there is an error :

EROR OGG-01224 TCP/IP error 101 (network is unreachable)
2012-04-18 10:14:08 EROR OGG-01668 SRCPUMP.PRM : PROCESS ABENDING

i have already set autorestart at parameter MGR
so after srcpump abended, for 3 minutes the srcpump restarted automatically

but there is another error:
10:17:08 ERROR OGG-01033 Oracle GoldenGate Capture for Oracle, srcpump.prm:
There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error.
(Remote file used is /oracle/product/test/dirdat/bb000118, reply received is Unable to lock file "/oracle/product/test/dirdat/bb000118" (error 13, Permission denied).
Lock currently held by process id (PID) 2980).

and then srcpump restarted automatically
and Lock again

and its looping again and again
after i wait for about 2 hours then suddenly

INFO OGG-01057 Oracle GoldenGate Capture for Oracle, srcpump.prm: Recovery completed for all targets.

But sometimes when looping eror like that, suddenly appear error Network is Unreachable again so its like the looping will repeated again from the beginning.
Because of that i definitely don't know when the pump will running normally again..

i really don't undestand why happend like this.. Please help me..

thank's
  • 1. Re: EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking
    931360 Newbie
    Currently Being Moderated
    anyone can help me...??
    i try to ask at Golden Gate Forum but nobody answer my question??

    i am a newbie , really confused n need some advices from an experience who use the golden gate..
    thank's

    The eror is :

    2012-04-19 09:09:19 EROR OGG-01224 TCP/IP error 101 (network is unreachable)
    2012-04-19 09:09:19 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, srcpump.prm: PROCESS ABENDING.

    2012-04-19 09:12:10 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT SRCPUMP starting.
    2012-04-19 09:12:10 INFO OGG-00965 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT SRCPUMP restarted automatically.
    2012-04-19 09:12:10 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, srcpump.prm: EXTRACT SRCPUMP starting.
    2012-04-19 09:12:10 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, srcpump.prm: EXTRACT SRCPUMP started.
    2012-04-19 09:12:16 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, srcpump.prm: Socket buffer size set to 200000000 (flush size 200000000).
    2012-04-19 09:12:17 INFO OGG-01055 Oracle GoldenGate Capture for Oracle, srcpump.prm: Recovery initialization completed for target file /oracle/product/test/dirdat/bb000129, at RBA 982889.
    2012-04-19 09:12:17 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, srcpump.prm: Output file /oracle/product/test/dirdat/bb is using format RELEASE 10.4/11.1.
    2012-04-19 09:12:17 ERROR OGG-01033 Oracle GoldenGate Capture for Oracle, srcpump.prm: There is a problem in network communication, a remote file problem,encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Remote file used is /oracle/product/test/dirdat/bb000129, reply received is Unable to lock file "/oracle/product/test/dirdat/bb000129" (error 13, Permission denied). Lock currently held by process id (PID) 9000).
    2012-04-19 09:12:17 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, srcpump.prm: PROCESS ABENDING.
  • 2. Re: EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking
    SaidK Explorer
    Currently Being Moderated
    There are several reasons for this problem.
    Check for firewalls; check if Collector has permission to write remote trail file.

    And could you send SRCPUMP.PRM parameters or at least RMTHOST parameter settings? You may have problems with RMTHOST parameter settings.
    Socket buffer size is set to maximum (200000000) . (If you are using earlier versions) Earlier versions of Collector doesn't support large packets.
  • 3. Re: EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking
    931360 Newbie
    Currently Being Moderated
    The firewalls has been stopped and the permission of target has already set.

    and the RMTHOST parameter at SRCPUMP.PRM like this :
    rmthost .... , mgrport 7809, COMPRESS, COMPRESSTHRESHOLD 2800, TCPBUFSIZE 200000000, TCPFLUSHBYTES 200000000

    u said: (If you are using earlier versions) Earlier versions of Collector doesn't support large packets.
    How i know about earlier versions?and if its support or not?

    thx
  • 4. Re: EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking
    SaidK Explorer
    Currently Being Moderated
    Is the problem still existing?

    Add into rmthost parameters NOSTREAMING. Recommended to use nostreaming if network problem exists. This will avoid the processes to abend, but latency will increase.
    Or remove TCP settings (set to default) to see if problem exits or not.
  • 5. Re: EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking
    931360 Newbie
    Currently Being Moderated
    Yes the problem still appear usually after found (network is unreachable) and the extract restarted automatically.

    How to use NOSTREAMING for RMTHOST?
    i try to use like this:
    rmthost .... , mgrport 7809, COMPRESS, COMPRESSTHRESHOLD 2800, TCPBUFSIZE 200000000, TCPFLUSHBYTES 200000000, NOSTREAMING

    but Invalid option for RMTHOST.
    Can u give me an example?
  • 6. Re: EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking
    SaidK Explorer
    Currently Being Moderated
    Hmm. Probably, you're using earlier version of GoldenGate. NOSTREAMING is supported in 11g.
  • 7. Re: EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking
    931360 Newbie
    Currently Being Moderated
    anyone know about UNLOCKEDTRAILFILES ?
    i read from http://docs.oracle.com/cd/E18101_01/doc.1111/e17791.pdf on page 382

    UNLOCKEDTRAILFILES:
    Valid for GLOBALS
    Use the UNLOCKEDTRAILFILES parameter as a workaround for problems with trail files that
    remain locked by Collector if there is a network outage that affects the target system. As
    of Oracle GoldenGate version 10.4, Collector locks a trail file when writing data to it, to
    prevent corruption from other processes that may attempt to write to the same trail.
    UNLOCKEDTRAILFILES prevents Collector from locking the trail files.

    i have already try to add parameter at global :
    edit params ./globals
    UNLOCKEDTRAILFILES

    but the error still same..
    maybe the sintaks that i add to the parameter global is wrong? anyone can help?

    thx..
  • 8. Re: EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking
    931360 Newbie
    Currently Being Moderated
    Mr SaidK,
    i search in google UNLOCKEDTRAILFILES also supported in 11g too.

    my golden gate is :
    Oracle GoldenGate Command Interpreter for Oracle
    Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
    Linux, x64, 64bit (optimized), Oracle 10g on Oct 4 2011 23:50:20

    do you know how to upgrade my golden gate become 11g?
    i really need try to use UNLOCKEDTRAILFILES or NOSTREAMING for the lock
    bcause it's too long to mirror the database if the lock move at least up to 2 hours.
    thx..
  • 9. Re: EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking
    amardeep.sidhu Pro
    Currently Being Moderated
    NOSTREAMING is supported in 11.2 (The latest version)
  • 10. Re: EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking
    SaidK Explorer
    Currently Being Moderated
    To upgrade GoldenGate you can follow the instructions on:
    http://docs.oracle.com/cd/E18101_01/doc.1111/e18173.pdf

    But be careful. This is quite serious job.
  • 11. Re: EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking
    931360 Newbie
    Currently Being Moderated
    what if i drop all the golden gate which has been used and change into Golden gate version 11.2 ?

    do you know the link for download source Golden Gate version 11.2 ?

    maybe its more safe than i upgrade..
  • 12. Re: EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking
    amardeep.sidhu Pro
    Currently Being Moderated
    What about the old trail files ? If you dont want to retain them and want to re-configure everything, then ok.

    Check on edelivery.oracle.com whether it is available for your platform or not.
  • 13. Re: EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking
    931360 Newbie
    Currently Being Moderated
    i am not sure
    but maybe i want to try to reconfigure everything if there is no other way.

    Golden Gate version 11.2 support for oracle 10g?

    i search in download oracle golden gate but only
    DownloadOracle GoldenGate V11.2.1.0.0 for Oracle 11g on Linux x86-64 (83 MB).

    and i have read and check the link that mr. saidk said
    http://docs.oracle.com/cd/E18101_01/doc.1111/e18173.pdf

    But the upgrade just for Golden Gate (11.1.1) from v10.4x
    is there same if i want to upgrade for 11.2 ?

    Edited by: 928357 on May 2, 2012 12:55 AM
  • 14. Re: EROR OGG-01224 TCP/IP error 101 (network is unreachable) and Locking
    amardeep.sidhu Pro
    Currently Being Moderated
    i search in download oracle golden gate but only
    DownloadOracle GoldenGate V11.2.1.0.0 for Oracle 11g on Linux x86-64 (83 MB).
    That probably means it is not yet available for the other platforms.

    and i have read and check the link that mr. saidk said
    http://docs.oracle.com/cd/E18101_01/doc.1111/e18173.pdf

    But the upgrade just for Golden Gate (11.1.1) from v10.4x
    is there same if i want to upgrade for 11.2 ?
    Not sure if I am getting you here. What version are you using currently ? You may want to upgrade to the latest version available (may be not 11.2).
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points