OGG-00953 WARNING OGG-00959 mgr 进程自动crash

环境：

Oracle 9.2.0.8 on windows 64bit
Oracle goldengate 11.1.1.0.1

 

简单错误描述：
2012-10-21 07:58:15 WARNING OGG-00959 Oracle GoldenGate Manager for Oracle, MGR.prm: PURGEOLDEXTRACTS
/dirdat/*,usecheckpoints, minkeepdays 7 (MINKEEPFILES option not used.)

 

简单分析及处理

对目标端ogg 重新初始化后，目标端mgr 进程会异常中断。复制进程正常且手动重启，可以正常启动
最终咨询原厂工程时候，发现这是一个在windows才会发生的bug，bug 号：13786241 （再次感谢oralce 刘相兵）
MOS提供的具体bug信息，是否解决需继续观察（目前截止发帖前没有再次出现）

https://cn.forums.oracle.com/forums/thread.jspa?threadID=2454696&tstart=0
 最终在mgr 进程参数中加入  nousethreads ，来尝试绕过该bug；

(想来在windows 上oracle将这个purge purgemarkhistory的任务交给了不大靠谱的windows 线程来解决，
因为thread 没有process这么耗资源，偏偏这线程不争气，最终无法完成purge，还导致mgr 进程 crash，
所以 disable usethread后，oracle会去找一个相对安全但比较傻的进程做这个事情

                                                                                                                                                        -----以上结论纯属个人瞎想)
 
 
oracle bug 具体解释及解决方法如下：
 
RELEASE NOTES:
This is a manager bug that causes the manager to crash when the manager is running in threaded mode. 
The manager is running in threaded mode bydefaulto Windows.  On other platforms,
the manager is in threaded modeifUSETHREADS is specified in the manager parameter. 
In addition to being in threaded mod the  manager has to have purge operations turned on such as purgemarkerhis
(i.e. userid scott@inst1).  The symptom of the bug is that after a few of purging of history (you can tell from the mgr report file),
the manager will crash unexpectedly

REDISCOVERY INFORMATION:
On Windows platform, or on other platforms and run manager with USETHREADS para a system name, i.e. scott@inst1. 
In addition, the manager needs to specify purging operations turned on such as purgemarkerhistory and pugeddlhistory. 
Oncethe manager is up and running, after a few rounds of purging, the manager willcrash

WORKAROUND:
Add'NOUSETHREADS'in mgr parameter file to disable threading in mgr.