Identify patches installed [message #223564] |
Fri, 09 March 2007 09:52 |
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 |
|
Mahesh Rajendran
Messages: 10708 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 |
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 #223587 is a reply to message #223585] |
Fri, 09 March 2007 12:59 |
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
|
|
|
|