000028861 - KB-1076 - How to determine Oracle Version on Aveksa system

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000028861
Applies ToAffected Versions: All Versions

There are a couple of ways to determine the version of Oracle.


1) Run the following command, logged in as the oracle user, on the ACM appliance:


opatch lsinventory (note that that is a lowercase 'L' in lsinventory)

This returns the following information:


Invoking OPatch

Oracle interim Patch Installer version

Copyright (c) 2005, Oracle Corporation. All rights reserved..

Oracle Home : /u01/app/oracle/product/10.2.0/db_1

Central Inventory : /home/oracle/oraInventory

from : /u01/app/oracle/product/10.2.0/db_1/oraInst.loc

OPatch version :

OUI version :

OUI location : /u01/app/oracle/product/10.2.0/db_1/oui

Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch-2008_Aug_25_18-50-09-EDT_Mon.log

Lsinventory Output file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory-2008_Aug_25_18-50-09-EDT_Mon.txt


Installed Top-level Products (2):

Oracle Database 10g

Oracle Database 10g Release 2 Patch Set 1

There are 2 products installed in this Oracle Home.

Interim patches (1) :

Patch 4689959 : applied on Mon Jun 02 14:18:43 EDT 2008

Created on 17 Oct 2006, 03:22:48 hrs US/Pacific

Bugs fixed:



OPatch succeeded.





2) Another 'quick' way to determine the Oracle version is to run sqlplus, and note the version #

$ sqlplus

SQL*Plus: Release - Production on Thu Sep 24 22:42:39 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.



3) Another 'quick' way is to look for the word Version in the Oracle Instance Alert log file:

$ grep Version /u01/app/oracle/product/admin/AVDB/bdump/alert_AVDB.log

Starting up ORACLE RDBMS Version: