000028861 - How to determine the Oracle database version in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Apr 28, 2020
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000028861
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: All
 
IssueThis RSA Knowledge Base Article provides several methods for determining the Oracle database version being used for the RSA Identity Governance & Lifecycle application.
 
ResolutionThere 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

  

Attachments

    Outcomes