Oracle Database Discussions

Hi you can use opatch utilit as :

D:\oracle\product\10.2.0\db_1\OPatch>opatch version
Invoking OPatch 10.2.0.1.0

OPatch Version: 10.2.0.1.0

OPatch succeeded.

D:\oracle\product\10.2.0\db_1\OPatch>

For more information you can use opatch query

D:\oracle\product\10.2.0\db_1\OPatch>opatch query
Invoking OPatch 10.2.0.1.0

Oracle interim Patch Installer version 10.2.0.1.0
Copyright (c) 2005, Oracle Corporation.  All rights reserved..


Oracle Home       : D:\oracle\product\10.2.0\db_1
Central Inventory : n/a
   from           : C:\Program Files\Oracle\Inventory
OPatch version    : 10.2.0.1.0
OUI version       : 10.2.0.1.0
OUI location      : D:\oracle\product\10.2.0\db_1\oui
Log file location : D:\oracle\product\10.2.0\db_1\cfgtoollogs\opatch\opatch-2010
_Jun_28_11-16-08-GEST_Mon.log

Failed to load the patch object.  Possible causes are:
  The specified path is not an interim Patch shiphome
  Meta-data files are missing from the patch area
  Patch location = D:\oracle\product\10.2.0\db_1\OPatch
  Details = PatchObject constructor: Input file "D:\oracle\product\10.2.0\db_1\O
Patch\etc\config\actions" or "D:\oracle\product\10.2.0\db_1\OPatch\etc\config\in
ventory" does not exist.

Patch Location "D:\oracle\product\10.2.0\db_1\OPatch" doesn't point to a valid p
atch area.

OPatch failed with error code = 75

D:\oracle\product\10.2.0\db_1\OPatch>

Also read below link
http://download.oracle.com/docs/cd/B19306_01/em.102/b16227/oui8_opatch.htm

Hi,

$ cd ORACLE_HOME/OPatch
$ opatch lsinventory
Invoking OPatch 11.1.0.6.2

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


Oracle Home : /glosoft/oracle/oracle11g/app/oracle/product/11.1.0/db_1
Central Inventory : /glosoft/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.2
OUI version : 11.1.0.7.0
OUI location : /glosoft/oracle/oracle11g/app/oracle/product/11.1.0/db_1/oui
Log file location : /glosoft/oracle/oracle11g/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch2010-06-28_11-50-43AM.log

Lsinventory Output file location : /glosoft/oracle/oracle11g/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2010-06-28_11-50-43AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (2):

Oracle Database 11g 11.1.0.6.0
Oracle Database 11g Patch Set 1 11.1.0.7.0
There are 2 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


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

OPatch succeeded.
$


HTH
KSG

hi


iE:\oracle\testdb\10.2.0\OPatch>opatch version
Invoking OPatch 10.2.0.3.0

OPatch Version: 10.2.0.3.0

OPatch succeeded.

E:\oracle\testdb\10.2.0\OPatch>

Thanks

With Regards
OH

Edited by: user3308982 on Jun 28, 2010 9:38 AM

Your ORACLE_HOME variable is not set.

C:\ set ORACLE_HOME=<your oracle home>

and then include it in the PATH environment variable.

else

go to ORACLE_HOME/bin directory and run the opatch from there.

regards

refer:
How to know whether patches applied to database
http://arjudba.blogspot.com/2010/01/how-to-know-whether-patches-applied-to.html

hope,this helps you.
regards,

You should run "opatch lsinventory" to know all the patches applied to your ORACLE_HOME.

Nicolas.

OPatch will list the OUI inventory for you and will display all interim patches applied as others pointed out. However, you need to use this tool from the database server console. There is also DBA_REGISTRY_HISTORY view where recent patches and patch bundles keep track of themselves, so you might just check this view for patching history (order by ACTION_TIME.)

Hth,
Vladimir M. Zakharychev