eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

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

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

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


历史上的今天...
    >> 2019-12-03文章:
    >> 2010-12-03文章:
    >> 2008-12-03文章:
    >> 2005-12-03文章:
           2005年的第一场雪

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

5 Comments

before installation, pls DO use cluvfy to check it.

这不是RAC系统。

呵呵 检查了一下BUG Number:6413391 是10.2的 幸亏我是9i,我的AIX 5.3上没有打ML06 应该没有问题吧

没问题,这是一个比较恐怖的Bug。

to flybuffer

小心由于aio造成crash


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com