Release/Version Number for Oracle EBS Components and Linux OS

Database Version

Connect sqlplus as apps user and run below query

 SQL>select banner from v$version;

Application Release

Connect sqlplus as apps user and run below quer

 SQL>select release_name from apps.fnd_product_groups;

Start CD Version

 cd startCD/Disk1/rapidwiz
 ./RapidWizVersion.sh

Report Builder

Log in as Application user, set environment variable and run below command

$ORACLE_HOME/bin/rwrun | grep Release

Forms Compiler

Log in as Application user, set environment variable and run below command

$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version

Java

Log in as Application user, set environment variable and run below command

$ORACLE_HOME/jdk/bin/java -fullversion

Application Server or Webserver/Apache

Log in as Application user, set environment variable and run below command

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd –version

JRE

Log in as Application user, set environment variable and run below command

cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version

Oracle Jinitiator

Log in as Application user, set environment variable and run below command

$grep jinit_ver_comma $CONTEXT_FILE

File Version of File System

$strings -a <file_name> | grep '$Header'

OR

$cat <file_name> | grep Header

Workflow Version

Connect sqlplus as apps user and run below quer

 SQL>select text ,name from wf_resources where name like '%WF_VERSION%';

PL/SQL Version

Log in as Application user, set environment variable and run below command

$ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version

FMW Webtier

Log in as Application user, set environment variable and run below command

$export ORACLE_HOME=$IAS_ORACLE_HOME
$ $ORACLE_HOME/OPatch/opatch lsinventory |grep WebTier

FMW Oracle Common

Log in as Application user, set environment variable and run below command

$export ORACLE_HOME=$FMW_HOME/oracle_common
$ $ORACLE_HOME/OPatch/opatch lsinventory |grep Oracle |grep Common

Weblogic Server

Log in as Application user, set environment variable and run below command

$ cd $FMW_HOME/wlserver_10.3/server/lib
$ java -cp weblogic.jar weblogic.version

Linux

$ lsb_release -a 

OR

$ cat /etc/redhat-release