--- Sjoerd Hooft's InFormation Technology ---

User Tools

Site Tools



Would you like to sponsor this site?
Or buy me a beer?:

Recently Changed Pages:

View All Pages
View All Q Pages

View All Tags

Sign up for Q to post comments.

WIKI Disclaimer: As with most other things on the Internet, the content on this wiki is not supported. It was contributed by me and is published “as is”. It has worked for me, and might work for you.
Also note that any view or statement expressed anywhere on this site are strictly mine and not the opinions or views of my employer.

Terms And Conditions for Q users

Pages with comments

2019/06/22 10:36 1 Comment
2019/03/15 16:02 1 Comment
2019/03/15 16:02 1 Comment
2019/03/15 16:02 3 Comments
2017/04/20 15:28 1 Comment
2017/04/20 15:23 1 Comment
2017/04/19 14:44 1 Comment
2017/04/17 20:10 1 Comment
2017/04/17 20:07 1 Comment
2017/04/17 19:58 1 Comment
2017/04/17 19:52 1 Comment

View All Comments


How to Determine the Installed Oracle Version Including Patches on AIX

On AIX, login as the oracle user and change directory to the ORACLE_HOME/OPatch (Note: OP are in capital) directory:


Then issue the opatch lsinventory command. I use these options:

  • all (will check all oracle installations in ORACLE_HOME)
  • invPtrLoc (provides the file location of oraInst.loc, which will provide the oracle inventory location)
bash-3.00$ opatch lsinventory -all -invPtrLoc ../oraInst.loc
Invoking OPatch

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

Oracle Home       : /opt/oracle/product/10.2
Central Inventory : /opt/oracle/oraInventory
   from           : ../oraInst.loc
OPatch version    :
OUI version       :
OUI location      : /opt/oracle/product/10.2/oui
Log file location : /opt/oracle/product/10.2/cfgtoollogs/opatch/opatch2010-09-16_11-41-52AM.log

Lsinventory Output file location : /opt/oracle/product/10.2/cfgtoollogs/opatch/lsinv/lsinventory2010-09-16_11-41-52AM.txt

List of Oracle Homes:
  Name          Location
   OUIHome1         /opt/oracle/product/10.2

Installed Top-level Products (2):

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

There are no Interim patches installed in this Oracle Home.


OPatch succeeded.
You could leave a comment if you were logged in.
oracleversion.txt · Last modified: 2013/02/25 21:11 by sjoerd