Home » RDBMS Server » Server Administration » Identify patches installed
Identify patches installed [message #223564] Fri, 09 March 2007 09:52 Go to next message
sjchanda
Messages: 7
Registered: January 2006
Junior Member
Hi

Can anyone tell me where to look for patches that are installed in the oracle software. I am using Oracle 9.2.0.7

Thanks
sjc
Re: Identify patches installed [message #223568 is a reply to message #223564] Fri, 09 March 2007 10:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use OPatch.
if it not available in your local ORACLE_HOME install it from metalink.
set your PATH correctly. I use several versisons of OPatch, so keep them seperate.
oracle@mutation#export PATH=$PATH:$ORACLE_HOME/OPatch/OPatch
oracle@mutation#./opatch lsinventory

Oracle Interim Patch Installer version 1.0.0.0.56
Copyright (c) 2006 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com

Oracle Home           : /u01/app/oracle/product/9.2.0
Oracle Home Inventory : /u01/app/oracle/product/9.2.0/inventory
Central Inventory     : /u01/app/oracle/oraInventory
   from               : /var/opt/oracle/oraInst.loc
OUI location          : /u01/app/oracle/product/9.2.0/oui
OUI shared library    : /u01/app/oracle/product/9.2.0/oui/lib/solaris/liboraInstaller.so
Java location         : /u01/app/oracle/product/9.2.0/jre/1.3.1/bin/java
Log file location     : /u01/app/oracle/product/9.2.0/.patch_storage/<patch ID>/*.log

Creating log file "/u01/app/oracle/product/9.2.0/.patch_storage/LsInventory__03-09-2007_11-08-28.log"

Result: 


  Installed Patch List:
  =====================
  1) Patch 5865568 applied on Wed Mar 07 16:23:51 EST 2007
      [ Base Bug(s): 5865568  ]
  2) Patch 5632264 applied on Wed Mar 07 14:57:45 EST 2007
      [ Base Bug(s): 5632264  ]

[Updated on: Fri, 09 March 2007 10:08]

Report message to a moderator

Re: Identify patches installed [message #223583 is a reply to message #223568] Fri, 09 March 2007 12:43 Go to previous messageGo to next message
sjchanda
Messages: 7
Registered: January 2006
Junior Member
Thanks Mahesh,

I tried opatch but it threw the following exception.
Result:

LsInventory: OPatch Exception while accessing O2O


OPATCH_JAVA_ERROR : An exception of type "OPatchException" has occurred:
OPatch Exception:
OUI found no such ORACLE_HOME set in the environment
Can not get details for given Oracle Home
An exception occurs
null


There is no Interim Patch



Can not get a list of inventory on this home.

ERROR: OPatch failed because of Inventory problem.

The Oracle home is set. I am looking thru the script to see if this is standard message that there is no patch or is it an error. Could you tell me if I need to fix anything else.

Thanks
sjc
Re: Identify patches installed [message #223585 is a reply to message #223583] Fri, 09 March 2007 12:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
The most common reason for this is the ORACLE_HOME defined in environment is different from what you are using. May be your ORACLE_HOME entry is wrong/with typos.
May be there are multiple ORACLE_HOMEs installed.
Crosscheck your ORACLE_HOME value and actual oracle_home you are using.

Re: Identify patches installed [message #223587 is a reply to message #223585] Fri, 09 March 2007 12:59 Go to previous messageGo to next message
sjchanda
Messages: 7
Registered: January 2006
Junior Member
I have around 8 databases installed on that server with different ORACLE_HOME but I am setting it to a particular one using .oraenv but when I run OPatch I believe it is getting reset to some other home. I am trying to look through the perl script to find out the problem. Is there anything specific I need to do for multiple oracle homes ?

SJC
Re: Identify patches installed [message #223588 is a reply to message #223587] Fri, 09 March 2007 13:01 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Nothing.
Just set the right ORACLE_HOME.
You no need to manipulate any perl script. It works if you set the invironment correct.
Previous Topic: Day Light Saving
Next Topic: Top 5 Wait Events
Goto Forum:
  


Current Time: Fri Sep 20 01:42:23 CDT 2024