Ora-600 [kcblasm_1] bug handling (2)

6. Compile the database.

CD $ ORACLE_HOME/rdbms/admin

Sqlplus/nolog

SQL> connect/As sysdba

SQL> startup

SQL> @ catbundle. SQL PSU apply

This process contains too many logs and is not displayed again.

SQL> @ utlrp. SQL

This process contains too many logs and is not displayed again.

SQL> quit

7. Check whether the patch is installed in ORACLE_HOME and DB.

[[Email protected] ~] $ CD/home/Oracle/orahome/opatch

[[Email protected] 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/export toollogs/opatch/opatch2014-08-04_14-46-06PM.log

Patch history file:/home/Oracle/orahome/export toollogs/opatch/opatch_history.txt

Lsinventory output file location:/home/Oracle/orahome/export toollogs/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,102 69717, 10327190,886 5718, 10017048,902 4850, 8394351,854 6356

9360157,977 0451, 9020537,977 2888, 8664189,100 91698, 12551710,751 9406

10132870,877 1916, 9109487,101 73237, 10068982,835 0262, 11792865

11724962,117 25006, 9184754,854 4696, 9320130,702 6523, 8277300,972 6739

8412426,124 19392, 6651220,915 0282, 9659614,994 9948, 10327179,888 2576

7612454,971 1859, 9714832,102 48542, 9952230,946 9117, 9952270,866 0422

10324526,124 19258, 9713537,100 10310, 9390484,996 3497, 12551700

12551701,102 49537, 12551702,125 51703, 8211733,125 51704, 9548269

12551705,125 51706, 9337325,125 51707, 7602341,125 51708, 9308296

10157402,117 37047

Opatch succeeded.

[[Email protected] opatch] $

SQL> select * From dba_registry_history;

Action_time action namespace version ID bundle_series comments

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

14-jun-11 12.31.31.7000020 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.3820.5.811707 PM apply server 10.2.0.5 4 PSU 10.2.0.5.4

SQL>

Note:

1、this patchupgrade step can be performed in the readme.html package of p12419392_10205_linux-x86-64.zip. At the same time, you must disable the database during the upgrade. This example shows a single instance database.

2. Check whether the PSU update is successful. The update is completed at http://dreamsanqin.blog.51cto.com/84#/1535784.

This article is from "Technical Achievement dream !" Blog, please be sure to keep this source http://dreamsanqin.blog.51cto.com/845412/1535810