How to determine the Oracle database version in RSA Identity Governance & Lifecycle
3 years ago
Originally Published: 2014-10-22
Article Number
000066249
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: All
 
Issue
This RSA Knowledge Base Article provides several methods for determining the Oracle database version being used for the RSA Identity Governance & Lifecycle application.
 
Resolution
There are several ways to determine the Oracle database version being used for the RSA Identity Governance & Lifecycle application. Here are some of the most popular:
 

aveksaServerInfo.log

The aveksaServerInfo.log keeps current and historical information on application and database version.

Login to the application server as the oracle user and execute the following:

$ cat $AVEKSA_HOME/wildfly/standalone/log/aveksaServer.log | grep 'Oracle version:'
Oracle version:    12.1.0.2
If there is more than one item in the list, the last item in the list is the current version.
 

SQL*PLUS

When logging into SQL*Plus, the welcome banner displays the database version.

Login to the application server as the oracle user and execute the following:

$ sqlplus

SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 24 16:08:53 2020

Copyright (c) 1982, 2014, Oracle.  All rights reserved.
 

SQL Developer (or similar tool)

Login to a tool such as SQL Developer as either avuser or SYS and execute the following:

select * from product_component_version;
User-added image

Oracle Alert Log

The Oracle Alert Log contains Oracle database release information.

Login to the application server as the oracle user and execute the following:

$ cat /u01/app/oracle/diag/rdbms/avdb/AVDB/trace/alert_AVDB.log | grep Release
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Release:        4.12.14-94.41-default