Using OPatch to query inventory

servername:TOY10G > opatch lsinventory -all
Invoking OPatch 10.2.0.3.0

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


Oracle Home : /oracle/product/10.2.0/db_1
Central Inventory : /oracle/product/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /oracle/product/10.2.0/db_1/oui
Log file location :
/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2007-04-07_08-55-45
AM.log

Lsinventory Output file location :
/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2007-04-
07_08-55-45AM.txt

---------------------------------------------------------------------
List of Oracle Homes:
Name Location
ORACLE_HOME1 /oracle/product/8.1.7.4
ORACLE_HOME2 /oracle/product/9.2.0
ORACLE_HOME9206 /oracle/product/9.2.0.6
ORACLE_HOME3 /oracle/product/10.2.0/db_1
ORACLE_HOME9208 /oracle/product/9.2.0.8
agent10g /oracle/product/10.2.0/OEM/agent10g

Installed Top-level Products (2):

Oracle Database 10g
10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 2
10.2.0.3.0
There are 2 products installed in this Oracle Home.


Interim patches (3) :

Patch 5752399 : applied on Tue Jan 30 14:16:07 CST 2007
Created on 12 Jan 2007, 20:07:35 hrs US/Pacific
Bugs fixed:
5752399

Patch 5556081 : applied on Tue Jan 30 14:14:16 CST 2007
Created on 9 Nov 2006, 22:20:50 hrs PST8PDT
Bugs fixed:
5556081

Patch 5557962 : applied on Tue Jan 30 14:14:04 CST 2007
Created on 9 Nov 2006, 23:23:06 hrs PST8PDT
Bugs fixed:
4269423, 5557962, 5528974


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

OPatch succeeded.