由于472错误实例异常关闭

客户数据库实例异常关闭,告警日志出现472错误。
错误信息如下:

Fri DEC 9 10:04:45 2011
USER: terminating instance due TO error 472
Instance TERMINATED BY USER, pid = 4993

Oracle对应的ORA-472错误信息为:

ORA-00472: PMON process TERMINATED WITH error 
Cause: The process cleanup process died
Action: Warm START instance

显然导致数据库实例崩溃的原因是PMON进程异常中止。
查询了一下MOS,发现类似的bug描述:Database Fails With Message User Terminating Instance Due To Error 472 [ID 605280.1]。导致这个问题的原因就是PMON或其他后台进程被第三方工具或用户手工kill掉。
询问客户发现,在问题发生之前,客户确实部署了一个第三方工具,看来问题就是这个工具所致。
对于安装产品数据库的服务器,再安装其他软件或工具时,还是应该小心谨慎一点。

This entry was posted in ORACLE and tagged , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *