Oracle GoldenGate

Environment

Source end

System HPUNIX 11.31

Cluster architecture HP high availability cluster

Database Oracle 10.2.0.3

Target end

System RHEL 5.8x64

Cluster architecture ORACLE RAC

Database 11.2.0.1.0

Description

The HP cluster switches automatically when an exception occurs, resulting in an exception in the GG process.

Source side error report

2014-07-14 16:38:52 ERROR OGG01031 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. (Reply received is Unable to open file "/ u01/ogg/dirdat/rt001995" (error 11, Resource temporarily unavailable).

The destination side reported an error.

2014-07-14 16:32:57 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Unable to lock file "/ u01/ogg/dirdat/rt001995" (error 11, Resource temporarily unavailable). Lock currently held by process id (PID) 21438.

2014-07-14 16:32:57 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Unable to open file "/ u01/ogg/dirdat/rt001995" (error 11, Resource temporarily unavailable).

Solve

The target side of kill locks the system process of Wen Jin.

Source side of processing process

Start the gg process, and the delivery process ends abnormally

View the delivery process log view report delivery process

2014-07-14 16:38:52 ERROR OGG01031 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. (Reply received is Unable to open file "/ u01/ogg/dirdat/rt001995" (error 11, Resource temporarily unavailable).

View ggserr.log

Target end

View ggserr.log

2014-07-14 16:32:57 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Unable to lock file "/ u01/ogg/dirdat/rt001995" (error 11, Resource temporarily unavailable). Lock currently held by process id (PID) 21438.

2014-07-14 16:32:57 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Unable to open file "/ u01/ogg/dirdat/rt001995" (error 11, Resource temporarily unavailable).

Ps-ef | grep 21438

Kill-9 21438

Problem solved.