rdbms patch

Check which rdbms patches are applied in uor database -

/usr/bin/perl $ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc

$ORACLE_HOME/oraInst.loc
$ /home/orart02

$ opatch versionInvoking OPatch 10.2.0.3.0
OPatch Version: 10.2.0.3.0
OPatch succeeded.

$ /home/orart02

$ which opatch

/apps/rt02/oracle/product/10201/OPatch/opatch

$ which perl

/usr/bin/perl

$ /home/orart02 $ /usr/bin/perl /apps/rt02/oracle/product/10201/OPatch/opatch lsinventory -invPtrLoc

$ORACLE_HOME/oraInst.loc

RDBMS Patch Lab -

Oracle RDBMS patching is one of the DBAs regular tasks. Here I would like to discuss very broadly how we do the rdbms patching. The database and the listener must be down while applying the patch.

We apply the rdbms patches by using Opatch utility. Please ceck the correct version of your optach which you will be using to apply a particular rdbms patch.

Here are the steps -

connect as oracle user.

set environment of the instance

1) Download the patch from oracle suuport to $ORACLE_HOME/patch
unzip the patch.
During uzipping please note down the directory it is creating.
cd to that directory. copy the directory path.
Example : 3852108

2)
export PATH=/$ORACLE_HOME/OPatch:$PATH
export PATH=/opt/perl/bin:$PATH

3)
cd /$ORACLE_HOME/OPatch
4)Apply the patch by this command
opatch apply -invPtrLoc $ORACLE_HOME/oraInventory/oraInst.loc /3852108

opatch apply -no_inventory /3852108
optach lsinventory -invPtrLoc $ORACLE_HOME/oraInventory/oraInst.loc