今天遇到一个AIX系统BUG,Oracle数据库无法启动,甚至无法Nomount,实例在Nomount之后马上Crash。 报告的错误是PMON无法启动。 告警日志信息摘录:
PMON started with pid=2,OS id=295272 Sun Dec 2 21:33:20 2007 Errors in file /oracle/admin/oinst/bdump/oinst_pmon_295272.trc: ORA-07445: exception encountered: core dump [] [] [] [] [] [] PSP0 started with pid=3,OS id=336364 MMAN started with pid=4,OS id=385228 DBW0 started with pid=5,OS id=389154 DBW1 started with pid=6,OS id=360558 DBW2 started with pid=7,OS id=340122 DBW3 started with pid=8,OS id=274592 LGWR started with pid=9,OS id=172072 CKPT started with pid=10,OS id=151578 SMON started with pid=11,OS id=369006 RECO started with pid=12,OS id=315902 CJQ0 started with pid=13,OS id=463090 MMON started with pid=14,OS id=299320 MMNL started with pid=15,OS id=278948 Sun Dec 2 21:33:23 2007 PSP0: terminating instance due to error 472 Instance terminated by PSP0,pid = 336364
最后确定疑似Oracle的一个Bug,BUG Number:6413391 对于这个BUG,Oracle建议的修正是Apply ML06 to AIX 5.3
而客户的系统目前看来ML06的安装是不完全的:
instfix -i|grep ML All filesets for 5.3.0.0_AIX_ML were found. All filesets for 5300-01_AIX_ML were found. All filesets for 5300-02_AIX_ML were found. All filesets for 5300-03_AIX_ML were found. All filesets for 5300-04_AIX_ML were found. All filesets for 5300-05_AIX_ML were found. Not all filesets for 5300-06_AIX_ML were found.
不完全的补丁安装是危险的,在进行系统升级时一定要慎重,最好将系统运行在经过验证的稳定的系统版本上,升级过快可能会带来更多的不稳定因素。
(编辑:青岛站长网)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|