Tuesday, February 26, 2008

Example: Using OPatch to patch on RAC

$ unzip p6602742_10203_Linux-x86-64.zip
$ cd 6602742
[6602742]$ ssh-agent $SHELL
[6602742]$ ssh-add
...
[6602742]$ opatch apply
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 : /oracle/...
Central Inventory : /oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /oracle/.../oui
Log file location : /oracle/.../cfgtoollogs/opatch/opatch2008-02-26_11-20-30AM.log

ApplySession applying interim patch '6602742' to OH '/oracle/...'

Subset patches: 6602742
.
.
.
---------------------------------------


when Patch completed. You can check Inventory


[$ 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 : /oracle/...
Central Inventory : /oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /oracle/.../oui
Log file location : /oracle/.../cfgtoollogs/opatch/opatch2008-02-26_11-40-28AM.log

Lsinventory Output file location : /oracle/.../cfgtoollogs/opatch/lsinv/lsinventory2008-02-26_11-40-28AM.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 (4) :

Patch 6602742 : applied on Tue Feb 26 11:30:28 ICT 2008
Created on 7 Jan 2008, 05:38:40 hrs US/Pacific Bugs fixed: 6602742, 5863277, 6334554, 4367986, 5177766, 5254759, 5955454, 6085625 6039513, 5648872, 6417744, 6452485


Rac system comprising of multiple nodes
Local node = db01
Remote node = db02

--------------------------------------------------------------------------------


OPatch succeeded.

2 comments:

Unknown said...

what are the steps required to perform on each node befor you apply the patch?

Surachart Opun said...

If you have 2 nodes on RAC...

and You need to patch on database PATH.

- Check ... patch.. that you can patch online...
patch's inventory file and look for set to TRUE.

Step:

You have to stop instance on node I, and then patch... start instance on node I...

If no problem... You can stop instance on node II ....and then Patch ... and start instance node II.