linux系统报错01031,OGG-01031错误处理一例

最新推荐文章于 2024-06-11 12:42:58 发布

Nature自然科研

最新推荐文章于 2024-06-11 12:42:58 发布

阅读量685

点赞数

文章标签： linux系统报错01031

这篇博客讲述了在Linux系统中遇到Oracle GoldenGate的OGG-01031错误，通过分析日志发现是由于目标库的Trail文件被服务器进程锁定导致的问题。排查过程包括检查源库和目标库的配置、进程状态以及Trail文件的使用情况。最终，通过杀死占用文件的进程解决了问题，使得GoldenGate进程恢复正常。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

刚刚观察测试库gg运行状况发现，pump进程异常abend，err log报错日志如下：

2012-05-24 10:45:54 ERROR OGG-01031 Oracle GoldenGate Capture for Oracle, dpump.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. (Reply received is Unable to open file "/home/oracle/ggs/dirdat/k1005466" (error 11, Resource temporarily unavailable)).

2012-05-24 10:45:54 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, dpump.prm: PROCESS ABENDING.

该错误官方说明如下：

OGG-01031: 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 {0})

Cause: Extract was not able to send data to the target.

Action: Examine the network for an outage between the source and target system.

Make certain that MGRPORT in RMTHOST matches the one in the parameter file

of the remote Manager. Check for errors on the target system that indicate the

Manager or Collector process is not running, or that Collector does not have

privileges to write to the remote trail. Check for encryption errors if the ENCRYPT

option is specified with the RMTHOST or RMTHOSTOPTIONS parameter: This

might indicate that the encryption key that was sent from the source does not

match the one in the ENCKEYS file on the target, or that the key or ENCKEYS file

on the target is missing.

貌似是网络原因造成的，排查源库和目标库的相关参数发现，都是一致的，也没什么问题，再到目标库查看相关进程都是running状态，但是出现了一个比较明显的告警信息，如下：

2012-05-24 10:57:50 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Unable to lock file "/home/oracle/ggs/dirdat/k1005466" (error 11, Resource temporarily unavailable). Lock currently held by process id (PID) 1731.2012-05-24 10:57:50 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: Unable to open file "/home/oracle/ggs/dirdat/k1005466" (error 11, Resource temporarily unavailable).