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
Resolution

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 10.2.0.2.0



Oracle interim Patch Installer version 10.2.0.2.0

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 : 10.2.0.2.0

OUI version : 10.2.0.2.0

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 10.2.0.1.0

Oracle Database 10g Release 2 Patch Set 1 10.2.0.2.0



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:

4689959

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

OPatch succeeded.


 


 


 


 


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



$ sqlplus


SQL*Plus: Release 10.2.0.2.0 - 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: 10.2.0.2.0.


Attachments

    Outcomes