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方法完成。
