SHIFT

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

User Tools

Site Tools


Sidebar

Recently Changed Pages:

View All Pages


View All Tags


LinkedIn




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.


Pages with comments

View All Comments

oracleversion

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:

cd $ORACLE_HOME/OPatch

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 10.2.0.4.3

Oracle Interim Patch Installer version 10.2.0.4.3
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    : 10.2.0.4.3
OUI version       : 10.2.0.4.0
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                                                  10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3                            10.2.0.4.0
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: 2021/09/24 00:25 (external edit)