Shulou(Shulou.com)06/01 Report--

6. Compile the database.

Cd $ORACLE_HOME/rdbms/admin

Sqlplus / nolog

SQL > CONNECT / AS SYSDBA

SQL > STARTUP

SQL > @ catbundle.sql psu apply

There are too many logs for this process to display again.

SQL > @ utlrp.sql

There are too many logs for this process to display again.

SQL > QUIT

7. Check whether the patch is installed in ORACLE_HOME and 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 >

Note:

1. The patch upgrade step can be used to view the readme.html in the p12419392_10205_Linux-x86-64.zip package. At the same time, the database must be closed when upgrading. This example is a demonstration of a single instance database.

2. Check whether the PSU is updated successfully, and complete it according to the http://dreamsanqin.blog.51cto.com/845412/1535784 method.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.