OGG soruce端异常宕机恢复后,无法启动ogg的pump进程。
@SOURCE
GGSCI (c1db0106) 1> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING E_FN 00:00:01 00:00:00
EXTRACT ABENDED P_FN 00:00:02 01:53:03
启动P_FN
start P_FN
tail -f ggserr.log
2014-04-01 10:54:15 GGS INFO Z0-05M Oracle GoldenGate Capture for Oracle, P_FN.prm: Output file ./dirdat/w3 is using format RELEASE 10.4.
2014-04-01 10:54:15 GGS ERROR 112 Oracle GoldenGate Capture for Oracle, P_FN.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 ./dirdat/w3002228, reply received is Unable to lock file "./dirdat/w3002228" (error 13, Permission denied). Lock currently held by process id (PID) 4124).
2014-04-01 10:54:15 GGS ERROR 190 Oracle GoldenGate Capture for Oracle, P_FN.prm: PROCESS ABENDING.
@TARGET
显示/dirdat/w3002228文件正在被4124进程锁定。
$ ll ./dirdat/w3002228
-rw-rw-rw- 1 oracle oinstall 1275374 Apr 1 09:11 ./dirdat/w3002228
$ ps -ef|grep 4124
oracle 4124 12874 0 Jan05 ? 00:09:51 ./server -p 7876 -k -l /app/oracle/ggs/ggserr.log
oracle 23023 22834 0 10:57 pts/2 00:00:00 grep 4124
tail -f ggserr.log
Unable to lock file "./dirdat/w3002228" (error 13, Permission denied). Lock currently held by process id (PID) 4124.
解决办法:
方法1:杀掉相关锁进程,然后重启进程
@target
kill -9 4124
然后重启R_HFWEB3
stop R_FN
start R_FN
@source
start P_FN
其他方法
方法2、不需理会,大概2小时后会自动释放该锁进程。
方法3、goldengate 10.4.0.76 会解决锁问题。
阅读(6226) | 评论(0) | 转发(0) |