【翻译自mos文章】使用dbua升级到70%左右时,os hang
来源于:Database Upgrade Crashes Server at around 70 Percent (文档 ID 551886.1)
适用于:
Oracle Server - Enterprise Edition - Version: 10.2.0.2
Linux x86
症状:
-- Problem Statement:
1. Oracle 10.2. is installed on Red Hat Enterprise Linux
2. The Database Upgrade Assistant (DBUA) is used to upgrade a 10.1 database to 10.2.
3. The upgrade progresses to ~70% then the server hangs, requiring power-cycle to reboot.
4. The hang occurs in initimnc.sql ...
....
REM create reset procedure
create or replace procedure java_reset(value IN NUMBER)
2 as LANGUAGE JAVA
3 name 'java.lang.System.exit(int)';
4 /
...
原因:
Kernel version < 2.6.9-55.0.2.EL
This can be caused by a Red Hat kernel bug that appears to have been corrected in:
kernel-2.6.9-55.0.2.EL
Reference:
http://rhn.redhat.com/errata/RHSA-2006-0132.html
Bugzilla 173981 - kernel bug at mm/prio_tree.c
解决方案:
-- To implement the solution, please execute the following steps:
1. Obtain and install the RPM for kernel-2.6.9-55.0.2.EL (or newer). ---额外注意:kernel-2.6.9-55.0.2.EL是rhe4.5,也就是说小于4.5会有此bug
2. Re-attempt the failed upgrade process by using the DBUA or manual (CATUPGRD.SQL).