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

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

文章题目：ora-600[kcblasm_1]bug处理（二）
文章分享：http://pwwzsj.com/article/jcgjic.html

平武建站

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

其他资讯