Commands to see APPS, DB, Form and Workflow Versions

Commands to see APPS, DB, Form and Workflow Versions

--Query to fetch Apps Version (11i/R12/12i)select release_name from apps.fnd_product_groups;

--Query to fetch Oracle Database versionselect * from v$version;

--to see whether RAC is implemented on DB show parameter cluster_database

--Workflow version with APPSselect TEXT "Version" from  WF_RESOURCES
where name='WF_VERSION'
and language='US';

#Web Server/Apache or Application Server in Apps 11i/R12#LOG into unix box using telnet/putty
#STEPS:
#1.Log in as Application user, set environment variable and run below query
#check if IAS_ORACLE_HOME env variable is set?
echo $IAS_ORACLE_HOME
#if exists set env variable as
set IAS_ORACLE_HOME
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version

Output for 11i instance looks like

Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built:   Jun 21 2012 23:59:43 (iAS 1.0.2.2.2 rollup 5)

#to get Oracle forms versionset ORACLE_HOME
$ORACLE_HOME/bin/f60run | grep Version | grep Forms

Output looks like

Forms 6.0 (Forms Runtime) Version 6.0.8.28.0 (Production)

#File Version on file systemadident Header <filename>
orstrings <file_name> | grep Header

Here adident is AD Utility (Oracle Apps) and strings is Unix utility