注意:Oracle10g Bug 4612267 更新檔聽說是隻給特殊使用者提供的O(∩_∩)O哈哈~
是以還是建議更新到10.2.0.4
Oracle10g Bug 4612267 更新檔安裝備忘錄
2009-01-13 14:04
一、bug症狀和描述 症狀: 當主機運作時間達198天或248天,cpu占用率就突然達到100%。此時作業系統指令可以執行,但Oracle的指令象lsnrctl、sqlplus、dbca等都會被hang住,不能執行。 Oracle官方對該bug的描述: #------------------------------------------------------------------------- # Interim Patch for Base Bugs: 4612267 #------------------------------------------------------------------------- # # DATE: Wed Oct 5 10:17:13 2005 # ------------------------------- # Platform Patch for : Linux x86 # Product Version # : 10.2.0.1 # Product Patched : ORACORE # # Bugs Fixed by this patch: # ------------------------- # 4612267:OCI CLIENT IS IN AN INFINITE LOOP WHEN MACHINE UPTIME HITS 248 DAYS #------------------------------------------------------------------------- 備注: 事實上隻要Linux x86主機運作天數是是24.8的倍數都有可能引發該bug,因為time()函數值為null,造成無限死循環,進而耗盡cpu。 解決辦法三種: 1) 重新開機主機; 2) 打patch set,如更新到10.2.0.4; 3) 對該bug單獨打臨時patch 4612267。 第一種方法沒有徹底解決問題,以後照舊;第二種方法,更新時間長,且要求停庫很久,目前生産環境暫不适合;本文采用第三種方法。 參考文檔: Doc ID: 338461.1 SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time Doc ID: 4612267.8 Bug 4612267 - OCI client spins when machine uptime >= 249 days 二、先停監聽、dbconsole和資料庫 先複制$ORACLE_BASE/oraInventory/oraInst.loc到$ORACLE_HOME目錄下 $ lsnrctl stop $ emctl stop dbconsole $ sqlplus / as sysdba SQL> shutdown immediate 注意:dbconsole是在已經裝了Oracle EM的情況下要停止,如果未安裝則無需幹涉。 三、安裝patch $ mkdir $ORACLE_BASE/patches $ cd $ORACLE_BASE/patches $ rz (SecureCRT裡上傳 p4612267_10201_LINUX.zip 檔案, 其它上傳方式也可以) $ unzip p4612267_10201_LINUX.zip $ cd 4612267/ $ $ORACLE_HOME/OPatch/opatch apply Invoking OPatch 10.2.0.1.0 ... Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/10.2.0/db_1') Is the local system ready for patching? Do you want to proceed? [y|n] y (此處輸入y) User Responded with: Y ... ApplySession adding interim patch '4612267' to inventory The local system has been patched and can be restarted. OPatch succeeded. 四、驗證patch $ $ORACLE_HOME/OPatch/opatch lsinventory Invoking OPatch 10.2.0.1.0 Oracle interim Patch Installer version 10.2.0.1.0 Copyright (c) 2005, Oracle Corporation. All rights reserved.. Oracle Home : /u01/app/oracle/product/10.2.0/db_1 Central Inventory : /u01/app/oracle/oraInventory from : /u01/app/oracle/product/10.2.0/db_1/oraInst.loc OPatch version : 10.2.0.1.0 OUI version : 10.2.0.1.0 OUI location : /u01/app/oracle/product/10.2.0/db_1/oui Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch-2009_Jan_13_11-06-27-HKT_Tue.log Lsinventory Output file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory-2009_Jan_13_11-06-27-HKT_Tue.txt -------------------------------------------------------------------------------- Installed Top-level Products (2): Oracle Database 10g 10.2.0.1.0 Oracle Database 10g Products 10.2.0.1.0 There are 2 products installed in this Oracle Home. Interim patches (1) : Patch 4612267 : applied on Tue Jan 13 11:05:10 HKT 2009 Created on 5 Oct 2005, 13:48:00 hrs US/Pacific Bugs fixed: 4612267 -------------------------------------------------------------------------------- OPatch succeeded. 五、啟動資料庫、監聽和dbconsole $ sqlplus / as sysdba SQL> startup $ lsnrctl start $ emctl start dbconsole 六、如果有需要,還可以删除patch,删除前先停庫 $ cd $ORACLE_BASE/patches/4612267 $ $ORACLE_HOME/OPatch/opatch rollback -id 4612267 Invoking OPatch 10.2.0.1.0 ... Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/10.2.0/db_1') Is the local system ready for patching? Do you want to proceed? [y|n] y (此處輸入y) User Responded with: Y ... RollbackSession removing interim patch '4612267' from inventory The local system has been patched and can be restarted. OPatch succeeded. 此時再執行上面的驗證patch指令就會發現該patch已經删除了。 --End-- |