March 02, 2013

ASM PATCHING


Install Instructions
====================

Download ASM Patch

Check DR sync status

shutdown all Applications related to databases

PROD
====

Blackout all the sevices on database server Node 1 and Node 2 (OEM)

Capture the pre-shutdown status at OS level.
Capture the pre-shutdown status at Database level.

shutdown all the instances on the database server (Node 1)
shutdown ASM instance on server (Node 1)

shutdown all the instances on the database server (Node 2)
shutdown ASM instance on server (Node 2)

Install Patch on Node 1
-----------------------

set environment variables to asm
export ORACLE_HOME=<>
cd <PATCH_NUMBER>
$ORACLE_HOME/Opatch/opatch apply -local

ps -ef|grep asm

. oraenv
+ASM

Install Patch on Node 2
-----------------------

set environment variables to asm
export ORACLE_HOME=<>
cd <PATCH_NUMBER>
$ORACLE_HOME/Opatch/opatch apply -local

ps -ef|grep asm

. oraenv
+ASM

Validate whether the Patches are applied or not
-----------------------------------------------

$ORACLE_HOME/Opatch/opatch lsinventory

start ASM instance on server (Node 1)
start all the instances on the database server (Node 1)

start ASM instance on server (Node 2)
start all the instances on the database server (Node 2)

start the listeners and validate the connections (Node 1)
start the listeners and validate the connections (Node 2)

Database Validation
-------------------

validate all the Database services for all databases (Node 1)
validate all the Database services for all databases (Node 2)

Application Validation
----------------------

Startup the applications and validate and inform Application team
Application team should validate.

DR
==

Same steps as in PROD

Check DR sync status

FALLBACK Plan
=============

set environment variables

Rollback Patches on both Node 1 and Node 2
$ORACLE_HOME/Opatch/opatch -id <PATCH_NO> rollback

Database Validation
-------------------

validate all the Database services for all databases (Node 1)
validate all the Database services for all databases (Node 2)

Application Validation
----------------------

Startup the applications and validate and inform Application team
Application team should validate.

No comments:

Post a Comment