今天遇到一个AIX系统BUGOracle数据库无法启动甚至无法Nomount实例在Nomount之后马上Crash
报告的错误是PMON无法启动
告警日志信息摘录
PMON started with pid= OS id=Sun Dec ::
Errors in file /oracle/admin/oinst/bdump/oinst_pmon_trc:
ORA: exception encountered: core dump [] [] [] [] [] []
PSP started with pid= OS id=
MMAN started with pid= OS id=
DBW started with pid= OS id=
DBW started with pid= OS id=
DBW started with pid= OS id=
DBW started with pid= OS id=
LGWR started with pid= OS id=
CKPT started with pid= OS id=
SMON started with pid= OS id=
RECO started with pid= OS id=
CJQ started with pid= OS id=
MMON started with pid= OS id=
MMNL started with pid= OS id=
Sun Dec ::
PSP: terminating instance due to error
Instance terminated by PSP pid =
最后确定疑似Oracle的一个BugBUG Number
对于这个BUGOracle建议的修正是Apply ML to AIX
而客户的系统目前看来ML的安装是不完全的
instfix i|grep ML
All filesets for _AIX_ML were found
All filesets for _AIX_ML were found
All filesets for _AIX_ML were found
All filesets for _AIX_ML were found
All filesets for _AIX_ML were found
All filesets for _AIX_ML were found
Not all filesets for _AIX_ML were found
不完全的补丁安装是危险的在进行系统升级时一定要慎重最好将系统运行在经过验证的稳定的系统版本上升级过快可能会带来更多的不稳定因素