Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Golden Gate Pump abended with TCP/IP error 104 (Connection reset by peer)

JitenderKAug 2 2016 — edited Aug 3 2016

Hi,

I am observing  TCP/Ip error in pump process and getting abended intermittently.

Source Side(London Time)

2016-08-02 01:08:16  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, lpg2.prm:  TCP/IP error 104 (Connection reset by peer), endpoint: {target ip removed by me} :7810.

2016-08-02 01:08:37  INFO    OGG-01230  Oracle GoldenGate Capture for Oracle, lpg2.prm:  Recovered from TCP error, host {target ip removed by me}, port 7811.

2016-08-02 01:08:37  ERROR   OGG-01033  Oracle GoldenGate Capture for Oracle, lpg2.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

Tatget Side(New York Time)

2016-08-01 20:08:37  WARNING OGG-01223  Oracle GoldenGate Collector for Oracle:  Unable to lock file "/u01/app/oracle/product/ggate/dirdat/g2000000000" (error 11, Resource temporarily unavailable).  Lock currently held by process id (PID) 20290.

We have enable retry option but not helping. Even tried NOSTREAMING option but didnt work.

We also observe retries is failing as at Target side collector process are still running and trail file was locked,

Checked with Network team they dont see any error or blips.

Here are MGR parameter at Source

PORT 7809

DYNAMICPORTLIST 7809-7815

AUTORESTART EXTRACT *, RETRIES 3, WAITMINUTES 5, RESETMINUTES 60

ACCESSRULE, PROG SERVER, ALLOW

MGR Param at Target

PORT 7809

DYNAMICPORTLIST 7810-7815

PurgeOldExtracts ./dirdat/*, UseCheckpoints, MinKeepDays 2

Pump param at source

EXTRACT LPG2

USERID gg12_owner, PASSWORD ****

SETENV (NLS_LANG="AMERICAN_AMERICA.UTF8")

RMTHOST 1****  MGRPORT 7809 TIMEOUT 1800,NOSTREAMING

RMTTRAIL /u01/app/oracle/product/ggate/dirdat/g2

GETTRUNCATES

TABLE ***

Any suggestion to fix it.

This post has been answered by K.Gan on Aug 2 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2016
Added on Aug 2 2016
9 comments
9,137 views