ora-600 [kcblasm_1]bug處理（二）

6、編譯數據庫。

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> STARTUP

SQL> @catbundle.sql psu apply

此過程日志過多，不再次顯示。

SQL> @utlrp.sql

此過程日志過多，不再次顯示。

SQL> QUIT

7、查看補丁是否安裝到ORACLE_HOME及DB中。

[oracle@server ~]$ cd /home/oracle/orahome/OPatch

[oracle@server OPatch]$ ./opatch lsinventory

Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1

Copyright (c) 2010, Oracle Corporation.  All rights reserved.

Oracle Home       : /home/oracle/orahome

Central Inventory : /home/oracle/orabase/oraInventory

   from           : /etc/oraInst.loc

OPatch version    : 10.2.0.5.1

OUI version       : 10.2.0.5.0

OUI location      : /home/oracle/orahome/oui

Log file location : /home/oracle/orahome/cfgtoollogs/opatch/opatch3014-08-04_14-46-06PM.log

Patch history file: /home/oracle/orahome/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /home/oracle/orahome/cfgtoollogs/opatch/lsinv/lsinventory2014-08-04_14-46-06PM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (3): 

Oracle Database 10g                                                  10.2.0.1.0

Oracle Database 10g Release 2 Patch Set 3                            10.2.0.4.0

Oracle Database 10g Release 2 Patch Set 4                            10.2.0.5.0

There are 3 products installed in this Oracle Home.

Interim patches (1) :

Patch  12419392     : applied on Mon Aug 04 14:25:33 CST 2014

Unique Patch ID:  13794201

   Created on 29 May 2011, 22:29:59 hrs PST8PDT

   Bugs fixed:

     6402302, 10269717, 10327190, 8865718, 10017048, 9024850, 8394351, 8546356

     9360157, 9770451, 9020537, 9772888, 8664189, 10091698, 12551710, 7519406

     10132870, 8771916, 9109487, 10173237, 10068982, 8350262, 11792865

     11724962, 11725006, 9184754, 8544696, 9320130, 7026523, 8277300, 9726739

     8412426, 12419392, 6651220, 9150282, 9659614, 9949948, 10327179, 8882576

     7612454, 9711859, 9714832, 10248542, 9952230, 9469117, 9952270, 8660422

     10324526, 12419258, 9713537, 10010310, 9390484, 9963497, 12551700

     12551701, 10249537, 12551702, 12551703, 8211733, 12551704, 9548269

     12551705, 12551706, 9337325, 12551707, 7602341, 12551708, 9308296

     10157402, 11737047

OPatch succeeded.

[oracle@server OPatch]$ 

SQL> select * from dba_registry_history;

ACTION_TIME                    ACTION          NAMESPACE  VERSION      ID BUNDLE_SERIES   COMMENTS

------------------------------ --------------- ---------- -------------------- ---------- --------------

14-JUN-11 12.31.31.749220 PM   VIEW RECOMPILE                          8289601            view recompila

                                                                                          tion

14-JUN-11 12.31.31.816662 PM   UPGRADE         SERVER     10.2.0.5.0                      Upgraded from

                                                                                          10.2.0.4.0

04-AUG-14 02.38.05.811707 PM   APPLY           SERVER     10.2.0.5           4 PSU        PSU 10.2.0.5.4

SQL> 

備注：

    1、該patch升級步驟可查看p12419392_10205_Linux-x86-64.zip包中的readme.html。同時升級時必須關閉數據庫，本例為單實例數據庫演示。

    2、查看PSU是否更新成功，根據http://dreamsanqin.blog.51cto.com/845412/1535784方法完成。