I am relatively new to Oracle GoldenGate, having recently joined a support team.
Part of our support scenario is that we have our source system in one city and our target system in another.
On rare occasions, we encounter a network connectivity issue between the two cities and the issue may persist for several hours.
When this happened last month, our pump process on the source system abended and we had to manually restart it once the network issue was resolved. Here are the relevant log entries:
2016-11-04 12:06:32 ERROR OGG-01232 Oracle GoldenGate Capture for Oracle, XXXXXX.prm: Receive TCP params error: TCP/IP error 104 (Connection reset by peer), endpoint: xxxxxxx
2016-11-04 12:06:32 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, XXXXXX.prm: PROCESS ABENDING.
I have been asked to investigate the AUTORESTART parameter option for the MGR process to see if it would help this type of scenario.
As I looked into this, I found that a former support person had made some changes several months ago to the TCPERRS file in order to increase the retry timeout and number of retries for connection reset events, as shown below:
sh vi tcperrs
#Increased the retry timeout and number of retries
# csecs is 1/100th of sec, 360000 is 1 hr
#ECONNRESET RETRY 500 10
ECONNRESET RETRY 360000 10
I cannot find much information on how the TCPERRS file and the AUTORESTRART option complement each other.
Are both of these strategies needed or is one better than the other?
Based on what was observed recently, I am thinking that the TCPERRS changes do not prevent the process from abending and what is really needed is the use of the AUTORESTART option in the MGR process.
I would be interested hearing other opinions on this.
BTW, we are using GoldenGate version 12, Oracle version 11g and Linux version 2.6.32-431.5.1.el6.x86_64.
Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.1.10 21604177 OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150902.1337_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Sep 2 2015 20:46:03
Operating system character set identified as UTF-8.
Thanks.