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

6、编译数据库。

创新互联是专业的颍上网站建设公司，颍上接单;提供成都网站设计、成都做网站,网页设计,网站设计,建网站,PHP网站建设等专业做网站服务;采用PHP框架,可快速的进行颍上网站开发网页制作和功能扩展;专业做搜索引擎喜爱的网站,专业的做网站团队,希望更多企业前来合作!

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