« RAC + ASM单节点添加表空间的BUG | Blog首页 | Oracle还是IBM的中文推广力度大? »

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

今天遇到一个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.

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

-The End-

By eygle on 2007-12-03 17:11 | Comments (5) | Case | 1693 |

IBMUnix