国内最全IT社区平台 联系我们 | 收藏本站
华晨云阿里云优惠2
您当前位置:首页 > 数据库 > Oracle > AIX不完整的补丁安装以及Oracle的Bug

AIX不完整的补丁安装以及Oracle的Bug

来源:程序员人生   发布时间:2013-12-20 04:41:27 阅读次数:3038次
今天遇到一个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.

不完全的补丁安装是危险的,在进行系统升级时一定要慎重,最好将系统运行在经过验证的稳定的系统版本上,升级过快可能会带来更多的不稳定因素。

生活不易,码农辛苦
如果您觉得本网站对您的学习有所帮助,可以手机扫描二维码进行捐赠
程序员人生
------分隔线----------------------------
分享到:
------分隔线----------------------------
关闭
程序员人生