Oracle one-off patch applying procedure on oracle 10g with ASM

Most important steps: 
=====================
Read the README.txt FIRST.
Perform an impact analysis
Notify appropriate personnel
Create Grid control blackout (if grid control is used)

1. List the server where the patch is applied
2. Check whether both Oracle and ASM are available
3. Are Oracle and ASM having different Oracle Homes? If so, need to patch them 
separately

Staging
=======
1. Download the patch from Oracle Support
2. Copy it over to the respective servers
3. Unzip the Patch

Verify if /usr/bin/unzip file exists. 
Then, type 
Unzip 

It creates a folder underneath with the patch files

Go Live
=======
1. Shutdown Oracle Database
2. Shutdown ASM
3. Shutdown listener
4. Make sure crsctl is down by typing "sudo crsctl stop crs"
5. Perform a tar backup of $ORACLE_HOME binaries
more /etc/oratab
tar -cvf oracle_binary_bkup.bak $ORACLE_HOME
gzip oracle_binary_bkup.bak 
6. Apply the Patch
$ cd 1234567
$ ORACLE_HOME/OPatch/opatch apply
ACTUAL SCRIPT EXECUTION 
----------------------- 
$ORACLE_HOME/OPatch/opatch apply Invoking OPatch 10.2.0.4.2
Oracle Interim Patch Installer version 10.2.0.4.2 Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /u01/test01/db_1 
Central Inventory : /u01/test01/oraInventory 
from : /etc/oraInst.loc 
OPatch version : 10.2.0.4.2 
OUI version : 10.2.0.4.0 
OUI location : /u01/test01/product/10.2.0.4/db_1/oui 
Log file location : /u01/test01/product/10.2.0.4/db_1/cfgtoollogs/opatch/opatch2009-08-12_14-54-51PM.log
ApplySession applying interim patch '1234567' to OH '/u01/test01/10.2.0.4/db_1'
Running prerequisite checks...
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/test01/10.2.0.4/db_1')
Is the local system ready for patching? [yn] y User Responded with: Y Backing up 
files and inventory (not for auto-rollback) for the Oracle Home Backing up files 
affected by the patch '1234567' for restore. This might take a while... Backing up 
files affected by the patch '1234567' for rollback. This might take a while...
Patching component oracle.rdbms, 10.2.0.4.0... Updating archive file "/u01/test
01/10.2.0.4/db_1/lib/libserver10.a" with "lib/libserver10.a/kfg.o" Running make 
for target ioracle ApplySession adding interim patch '1234567' to inventory
Verifying the update... Inventory check OK: Patch ID 1234567 is registered in 
Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 
1234567 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
$ $ORACLE_HOME/OPatch/opatch lsinventory Invoking OPatch 10.2.0.4.2
Oracle Interim Patch Installer version 10.2.0.4.2 Copyright (c) 2007, Oracle 
Corporation. All rights reserved.
Oracle Home : /u01/test01/10.2.0.4/db_1 
Central Inventory : /u01/test01/oraInventory 
from : /etc/oraInst.loc 
OPatch version : 10.2.0.4.2 
OUI version : 10.2.0.4.0 
OUI location : /u01/test01/10.2.0.4/db_1/oui 
Log file location : /u01/test01/10.2.0.4/db_1/cfgtoollogs/opatch/opatch2009-08-12_14-56-54PM.log
Lsinventory Output file location : /u01/test01/10.2.0.4/db_1/cfgtoollogs/opatch/lsinv/lsinventory2009-08-12_14-56-54PM.txt
--------------------------------------------------------------------------------

 Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0 
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0 
There are 2 products installed in this Oracle Home.
Interim patches (1) : Patch 1234567 : applied on Wed Aug 12 14:55:46 CDT 
2009 Created on 9 Nov 2008, 20:00:17 hrs PST8PDT Bugs fixed: 1234567
7. Verify the Patch completed successfully
8. Bring up listener
9. Bring up ASM
10. Bring up Database
11. Verify if applications are able to connect

Comments

Popular posts from this blog

Supported oracle database upgrade path

Oracle Linux Server 6.0 readiness for Oracle Binary

11.2.0.1 oracle installation on Oracle Linux 6