数据库

位置:IT落伍者 >> 数据库 >> 浏览文章

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


发布日期:2020年06月02日
 
AIX不完整的补丁安装以及Oracle的Bug

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

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

               

上一篇:把Oracle表中的数据导出成Txt格式

下一篇:用DataDude进行数据比较的方法