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
=====================
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
Post a Comment