How to patch Oracle
I. current environment
Platform
Version
Pattern
Linux 32bit
Oracle 10.2.0.3
Single instance
2. Objective to repair CPU bug
Namely Patch 7369190:
Download the patch and log on to metalink website
Find the corresponding patch
Install the patch and upload the downloaded patch p7369190_10203_LINUX.zip to the database server
Follow the instructions included in the patch to upgrade
4.1 check patch oracle@linux-o154:~ > / opt/oracle/product/10.2.0/db_1/OPatch/opatch lsinventory
Invoking OPatch 10.2.0.3.0
Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..
Oracle Home: / opt/oracle/product/10.2.0/db_1
Central Inventory: / opt/oracle/oraInventory
From: / etc/oraInst.loc
OPatch version: 10.2.0.3.0
OUI version: 10.2.0.3.0
OUI location: / opt/oracle/product/10.2.0/db_1/oui
Log file location: / opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch3011-04-20 21-21-24PM.log
Lsinventory Output file location: / opt/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2011-04-20 21-21-24PM.txt
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0
There are 2 products installed in this Oracle Home.
Interim patches (2):
Patch 5556081: applied on Sat Oct 30 10:48:31 EDT 2010
Created on 9 Nov 2006, 22:20:50 hrs PST8PDT
Bugs fixed:
5556081
Patch 5557962: applied on Sat Oct 30 10:48:22 EDT 2010
Created on 9 Nov 2006, 23:23:06 hrs PST8PDT
Bugs fixed:
4269423, 5557962, 5528974
4.2 install patches? Extract the patch
$unzip p7369190_10203_LINUX.zip
? Close the database instance
SQL > shutdown immediate
? Install the patch
Follow the patch's own instructions.
$cd 7369190
$opatch napply-skip_subset-skip_duplicate
Note: Oracle 10.2.0.3 opath does not have the napply parameter. You need to download the p6741493_10203_GENERIC.zip patch, decompress the p6741493 patch, use the p6741493 patch to decompress the opatch command of the path, and execute the following command to install patch 7369190:
Oracle@linux-o154:~/7369190/7369190 > / opt/oracle/OPatch/opatch napply-skip_subset-skip_duplicate
? Execute sql
Execute sql as described in the documentation
Sqlplus / nolog
SQL > CONNECT / AS SYSDBA
SQL > STARTUP
SQL > @ / opt/oracle/7369190/7369190/files/cpu/CPUOct2008/catcpu.sql
If catcpu.sql reports any Invalid Objects, run the following commands:
SQL > @ $ORACLE_HOME/rdbms/admin/utlrp.sql
SQL > SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS= 'INVALID'
No rows selected
