在RAC 12c下GoldenGate故障一则(共享文件系统文件锁)

OS:Oracle Linux 6.6 x64
DB:12.1.2.0
GoldenGate:12.2

GoldenGate目录安装在共享的ACFS上。
在ggserr.log中发现:

点击(此处)折叠或打开

  1. 2016-07-09 18:27:48 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, pmp1.prm: Unable to lock file "/u01/ggs_1/dirchk/PMP1.
  2. cpe" (error 11, Resource temporarily unavailable).
根据MOS ID 1330326.1

按照其执行,发现仍有报错

点击(此处)折叠或打开

  1. 2016-07-09 18:32:30 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, ext1.prm: Unable to lock file "/u01/ggs_1/dirchk/EXT1.cpe" (error 11, Resource temporarily unavailable). Lock currently held by process id (PID) 25960.
不过与之前略有不同,出现了PID 25960的提示。

按该提示查找进程:

点击(此处)折叠或打开

  1. # ps -ef | grep 25960
  2. oracle 25960 9401 0 18:30 ? 00:00:00 /u01/ggs_1/extract PARAMFILE /u01/ggs_1/dirprm/ext1.prm REPORTFILE /u01/ggs_1/dirrpt/EXT1.rpt PROCESSID EXT1 USESUBDIRS
  3. oracle 25966 25960 0 18:30 ? 00:00:00 oracleracdb2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  4. oracle 26024 25960 0 18:31 ? 00:00:00 oracleracdb2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  5. oracle 26025 25960 3 18:31 ? 00:00:03 oracleracdb2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  6. oracle 26173 25960 0 18:31 ? 00:00:00 oracleracdb2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  7. oracle 26218 25960 0 18:31 ? 00:00:00 oracleracdb2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
将进程杀死,重新启动Extract即可。

点击(此处)折叠或打开

  1. # kill -9 25960






请使用浏览器的分享功能分享到微信等