Oracle Patches
****Summary of How this page can help you******************

This page contains information about what Oracle Patches are.

To go back to the 50 dba terms for the new dba please click the link.

*********************************************************

Oracle database software like any other software in this world have bugs.
To fix these bugs oracle releases bugfixes called Patches.

Many companies periodically install these patches on their production servers to make sure that the
database is running without any problems. However before installing an oracle patch on a
production server you have to test it on your development and test servers and once the users are
happy that the application functionalities are fine then you can go ahead and install it on the
production server.

The normal rule is - dont install the oracle patches just because oracle is providing them .
                           Install a patch only if you have a certain problem and in oracle metalink website    
                            if this particular patch is recommended for your platform(operating system).

for example if your database version is 10.2.0.4 then you might have plenty of patches usually called
with numbers like 66778895 , 45655786 etc.

Normally what companies do when they have time and when they tested it completely on their test
environments is to go to the next version of the oracle database software.so in our example it could
be
10.2.0.5  which will automatically contain all the above patches or sometimes oracle will tell you that
a particular patch is only applicable from oracle 11g onwards.

I think now you have a basic idea on what oracle patches are.

oracle has a tool called Opatch to install these patches. so you just have to install this opatch tool .
you can download this from oracle metalink if it is already not present in your server. you must also
usually download the patches from the oracle metalink website and you should have an account in
this website.
once you join a company normally they will give you a account or you must usually ask your
colleague who already has a metalink account.

the directory where you can find the OPatch tool on your unix server is
/opt/oracle/product/10.2.0/OPatch

that means normally under your oracle home directory you should be able to find a folder called
OPatch.

below is a example of when i recently applied a patch using OPatch on my solaris server.


-/home/oradb/oraclepatches/8315012 :->/opt/oracle/product/10.2.0/OPatch/opatch apply
Invoking OPatch 10.2.0.4.3

Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation.  All rights reserved.


Oracle Home       : /opt/oracle/product/10.2.0
Central Inventory : /opt/oracle/product/10.2.0/oraInventory
from           : /var/opt/oracle/oraInst.loc
OPatch version    : 10.2.0.4.3
OUI version       : 10.2.0.4.0
OUI location      : /opt/oracle/product/10.2.0/oui
Log file location :
/opt/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2009-10-23_14-43-13PM.log

ApplySession applying interim patch '8315012' to OH '/opt/oracle/product/10.2.0'

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 = '/opt/oracle/product/10.2.0')


Is the local system ready for patching? [y|n]
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 '8315012' for restore. This might take a while...

*****************************************************************
The Oracle Configuration Manager had been installed in the
Oracle Home. Prior to contacting Oracle Support, please
refer to http://www.oracle.com/technology/documentation/ocm.html
for answers to your questions.

Please complete the configuration of the Software by
invoking the command:

/opt/oracle/product/10.2.0/ccr/bin/setupCCR

*****************************************************************
Backing up files affected by the patch '8315012' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/opt/oracle/product/10.2.0/lib/libserver10.a"  with "lib/libserver10.a/ktel.o"
Updating archive file "/opt/oracle/product/10.2.0/lib/libserver10.a"  with "lib/libserver10.a/ktsm.o"
Updating archive file "/opt/oracle/product/10.2.0/lib/libserver10.a"  with "lib/libserver10.a/ktsp.o"
Updating archive file "/opt/oracle/product/10.2.0/lib/libserver10.a"  with "lib/libserver10.a/ktsplb.o"
Updating archive file "/opt/oracle/product/10.2.0/lib/libserver10.a"  with "lib/libserver10.a/ktss.o"
Updating archive file "/opt/oracle/product/10.2.0/lib/libserver10.a"  with "lib/libserver10.a/ktsx.o"
Updating archive file "/opt/oracle/product/10.2.0/lib/libserver10.a"  with "lib/libserver10.a/kdt.o"
Updating archive file "/opt/oracle/product/10.2.0/lib/libserver10.a"  with
"lib/libserver10.a/ktspsrch.o"
Updating archive file "/opt/oracle/product/10.2.0/lib/libserver10.a"  with "lib/libserver10.a/kdd.o"
Updating archive file "/opt/oracle/product/10.2.0/lib/libserver10.a"  with "lib/libserver10.a/kdo.o"
Running make for target ioracle
ApplySession adding interim patch '8315012' to inventory

Verifying the update...
Inventory check OK: Patch ID 8315012 is registered in Oracle Home inventory with proper
meta-data.
Files check OK: Files from Patch ID 8315012 are present in Oracle Home.

The local system has been patched and can be restarted.

--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:
1) OUI-67294:
*****************************************************************
The Oracle Configuration Manager had been installed in the
Oracle Home. Prior to contacting Oracle Support, please
refer to http://www.oracle.com/technology/documentation/ocm.html
for answers to your questions.

Please complete the configuration of the Software by
invoking the command:

/opt/oracle/product/10.2.0/ccr/bin/setupCCR

*****************************************************************
--------------------------------------------------------------------------------
OPatch Session completed with warnings.

OPatch completed with warnings.
-/home/oradb/oraclepatches/8315012 :->





To go back to the
50 dba terms for the new dba please clink the link.