Oracle Database CPU Patching Very quick steps.
Note: for detailed steps please read Patch readme file, few patch require database to be started in upgrade mode.
1. Backup Oracle Home -
cd
$ORACLE_HOME
tar -cvf
/u03/PATCH/HOMEBKP/DB_102050_HOME_bkp.tar .
2. Check Patch Readme file to know current version of OPatch
matching requirement.
Check
opatch version :
which
opatch -> ensure it shows the opatch
file from right Oracle Home
opatch
-version -> will show opatch version.
To upgrade,
move
current opatch directory to new name
cd
$ORACLE_HOME
mv OPatch
Opatch.bak
Download
and unzip opatch latest version from download.oracle.com and unzip the folder
in Oracle Home.
3. Set Environment Variables.
export
ORACLE_HOME=/u01/app/oracle/product/10.2.0.5
export
PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$PATH
export
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib
export
LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib
4. Shutdown all the instances and listener running from this
Oracle Home.
5. Download patch and unzip the patch file in desired
location.
cd
/u03/PATCH/
unzip
p14727319_10205_Linux-x86-64.zip
6. Prerequisites Check - running below command
$ opatch
prereq CheckConflictAgainstOHWithDetail -phBaseDir 14727319
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.
PREREQ
session
Oracle
Home :
/u01/app/oracle/product/10.2.0.5
Central
Inventory : /u01/app/oracle/product/10.2.0.5
from : /etc/oraInst.loc
OPatch
version : 10.2.0.5.1
OUI
version : 10.2.0.5.0
OUI
location :
/u01/app/oracle/product/10.2.0.5/oui
Log file
location :
/u01/app/oracle/product/10.2.0.5/cfgtoollogs/opatch/opatch2013-06-13_02-30-20AM.log
Patch
history file:
/u01/app/oracle/product/10.2.0.5/cfgtoollogs/opatch/opatch_history.txt
Invoking
prereq "checkconflictagainstohwithdetail"
Prereq
"checkConflictAgainstOHWithDetail" passed.
OPatch
succeeded.
7. Apply the patch.
->
Before applying it is always better to check which opatch is being used run “which
opatch “command to know.
$ echo
$ORACLE_HOME
/u01/app/oracle/product/10.2.0.5
$ which
opatch
~/product/10.2.0.5/OPatch/opatch
-> cd to
Patch locatio and run opatch apply ( It will ask for few interactive questions answer them)
$ cd
14727319
$ opatch
apply
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 :
/u01/app/oracle/product/10.2.0.5
Central
Inventory : /u01/app/oracle/product/10.2.0.5
from : /etc/oraInst.loc
OPatch
version : 10.2.0.5.1
OUI
version : 10.2.0.5.0
OUI
location :
/u01/app/oracle/product/10.2.0.5/oui
Log file
location :
/u01/app/oracle/product/10.2.0.5/cfgtoollogs/opatch/opatch2013-06-13_02-33-03AM.log
Patch
history file:
/u01/app/oracle/product/10.2.0.5/cfgtoollogs/opatch/opatch_history.txt
ApplySession
applying interim patch '14727319' to OH '/u01/app/oracle/product/10.2.0.5'
Running
prerequisite checks...
Patch
14727319: Optional component(s) missing : [ oracle.rdbms.dv, 10.2.0.5.0 ] , [
oracle.rdbms.dv.oc4j, 10.2.0.5.0 ] , [ oracle.network.cman, 10.2.0.5.0 ]
Provide
your email address to be informed of security issues, install and
initiate
Oracle Configuration Manager. Easier for you if you use your My
Oracle
Support Email address/User Name.
Visit
http://www.oracle.com/support/policies.html for details.
Email
address/User Name:
You have
not provided an email address for notification of security issues.
Do you wish
to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
OPatch
detected non-cluster Oracle Home from the inventory and will patch the local
system only.
Please shutdown
Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle
Home = '/u01/app/oracle/product/10.2.0.5')
Is the
local system ready for patching? [y|n]
.
.
.
.
.
.
.
.
##########. Last few lines of Patch log...##############
Patching
component oracle.xdk.rsf, 10.2.0.5.0...
Updating
archive file "/u01/app/oracle/product/10.2.0.5/lib/libxml10.a" with "lib/libxml10.a/lpxpar.o"
Updating
archive file "/u01/app/oracle/product/10.2.0.5/lib32/libxml10.a" with "lib32/libxml10.a/lpxpar.o"
Patching
component oracle.precomp.common, 10.2.0.5.0...
Patching
component oracle.rdbms.rman, 10.2.0.5.0...
Copying
file to "/u01/app/oracle/product/10.2.0.5/rdbms/admin/recover.bsq"
Patching
component oracle.sdo.locator, 10.2.0.5.0...
Updating
archive file
"/u01/app/oracle/product/10.2.0.5/lib/libordsdo10.a" with "lib/libordsdo10.a/mdidx.o"
Updating
archive file
"/u01/app/oracle/product/10.2.0.5/lib/libordsdo10.a" with "lib/libordsdo10.a/mdrcr.o"
Updating
archive file "/u01/app/oracle/product/10.2.0.5/lib/libordsdo10.a" with "lib/libordsdo10.a/mdrt.o"
Updating
archive file
"/u01/app/oracle/product/10.2.0.5/lib/libordsdo10.a" with "lib/libordsdo10.a/mdopp.o"
Updating
archive file
"/u01/app/oracle/product/10.2.0.5/lib/libordsdo10.a" with "lib/libordsdo10.a/mdgr.o"
Patching
component oracle.network.listener, 10.2.0.5.0...
Patching
component oracle.network.client, 10.2.0.5.0...
Copying
file to "/u01/app/oracle/product/10.2.0.5/bin/adapters"
Running
make for target client_sharedlib
Running
make for target ioracle
Running
make for target iwrap
Running
make for target client_sharedlib
Running
make for target proc
Running
make for target irman
Running
make for target itnslsnr
ApplySession
adding interim patch '14727319' to inventory
Verifying
the update...
Inventory
check OK: Patch ID 14727319 is registered in Oracle Home inventory with proper
meta-data.
Files check
OK: Files from Patch ID 14727319 are present in Oracle Home.
The local
system has been patched and can be restarted.
OPatch
succeeded.
8. On each database on oracle home startup the database and
run below listed scripts.
For each
database instance running on the Oracle home being patched, connect to the
database using SQL*Plus. Connect as SYSDBA and run the catbundle.sql script as
follows:
cd
$ORACLE_HOME/rdbms/admin
sqlplus
/nolog
SQL>
CONNECT / AS SYSDBA
SQL>
STARTUP
SQL>
@catbundle.sql psu apply
SQL> --
Execute the next statement only if this is the first PSU applied for 10.2.0.5
or this is the first PSU applied since 10.2.0.5.3.
SQL>
@utlrp.sql
SQL>
QUIT
Check the
following log files in $ORACLE_HOME/cfgtoollogs/catbundle or $ORACLE_BASE/cfgtoollogs/catbundle
for any errors:
catbundle_PSU__APPLY_.log
catbundle_PSU__GENERATE_.log
9. Check the Opatch latest patch version " opatch
lsinventory"
$ 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 :
/u01/app/oracle/product/10.2.0.5
Central
Inventory : /u01/app/oracle/product/10.2.0.5
from : /etc/oraInst.loc
OPatch
version : 10.2.0.5.1
OUI
version : 10.2.0.5.0
OUI
location :
/u01/app/oracle/product/10.2.0.5/oui
Log file
location :
/u01/app/oracle/product/10.2.0.5/cfgtoollogs/opatch/opatch2013-06-13_02-35-14AM.log
Patch
history file:
/u01/app/oracle/product/10.2.0.5/cfgtoollogs/opatch/opatch_history.txt
Lsinventory
Output file location :
/u01/app/oracle/product/10.2.0.5/cfgtoollogs/opatch/lsinv/lsinventory2013-06-13_02-35-14AM.txt
--------------------------------------------------------------------------------
Installed
Top-level Products (3):
Oracle
Database 10g
10.2.0.1.0
Oracle
Database 10g Products
10.2.0.1.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 14727319
: applied on Thu Jun 13 02:34:39 PDT 2013
Unique
Patch ID: 15760144
Created on 13 Dec 2012, 08:27:13 hrs PST8PDT
Bugs fixed:
8865718, 11790175, 13489660, 9020537,
9772888, 8650138, 8664189, 10091698
14275629, 14469008, 10092858, 12551710,
7519406, 13349665, 8771916
7509714, 8822531, 10139235, 10159846,
13257247, 8350262, 11792865
7119382, 13632738, 11724962, 8966823,
9320130, 13775862, 11674645
15877957, 7026523, 15877958, 15877959,
9399589, 14841459, 9672816
13503598, 9499302, 9150282, 9448311,
9659614, 13632743, 9949948, 8882576
10327179, 7612454, 7111619, 9711859,
9714832, 9735237, 9952230, 15877960
12780098, 15877961, 15877962, 14665116,
15877963, 8660422, 11066597
14546673, 14105702, 9713537, 14105703,
14105704, 13483152, 13737773
13737775, 14269955, 12925532, 12748240,
9694101, 14390396, 12862186
12862187, 10249537, 14727319, 9586877,
8211733, 6694396, 9548269, 7115910
7710224, 9337325, 8354642, 7602341,
14076510, 11856395, 10157402, 12565867
6402302, 10327190, 10269717, 14023636,
11693109, 10017048, 8546356
8394351, 9024850, 8224558, 9770451,
9360157, 8488233, 9109487, 10132870
9171933, 10173237, 9532911, 10068982,
10306945, 7361418, 11725006
8666117, 6157713, 9184754, 10214450,
14205448, 8544696, 9767674, 9323583
8277300, 9726739, 13343467, 8412426,
10326338, 10165083, 12419392
6651220, 10208905, 9145204, 13554409,
11076894, 7450366, 11893577
8970313, 14492313, 6011045, 14492314,
10162036, 11814891, 14492315
10248542, 14492316, 9469117, 13359623,
9952270, 9842573, 13343471
10324526, 14546638, 12419258, 9322219,
8636407, 10010310, 12828105
9689310, 9390484, 13736501, 13736502,
9824435, 13736503, 13736504
13736505, 13736506, 9963497, 9032322,
13736507, 12551700, 12551701
12551702, 14035825, 11858315, 12551703,
12551704, 12551705, 10076669
12551706, 14040433, 12551707, 6076890,
12551708, 14258925, 9308296
13916709, 12827745, 12880299, 14038805,
13923855, 9072105, 8528171, 11737047
--------------------------------------------------------------------------------
OPatch
succeeded.
10. Check all databases and listener are started properly.
Send our an email to users for check
