Finding Oracle Applications Component Versions

There are various components in Oracle Applications setup. Below commands can be used to find the exact version of the components:

FIND APPS VERSION (11i/R12)

Connect to database as user apps

APPS@dba > select release_name from apps.fnd_product_groups;
 
RELEASE_NAME
------------------------
12.1.3

WEB SERVER/APACHE OR APPLICATION SERVER IN APPS 11i/R12

$ $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version
 
Server version: Oracle-Application-Server-10g/10.1.3.5.0 Oracle-HTTP-Server
Server built: Jul 21 2009 11:12:22

FORMS VERSION

$ frmcmp_batch | grep Version | grep Forms
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)

For 11i, you have to use below command:

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

REPORT VERSION

$ $ORACLE_HOME/bin/rwrun | grep Release
Report Builder: Release 10.1.2.3.0 - Production on Sat Apr 19 02:15:53 2014

ORACLE JINITIATOR VERSION

$ grep jinit_ver_comma $CONTEXT_FILE
<jinit_ver_comma oa_var="s_jinit_ver_comma">1.6.0_07</jinit_ver_comma>

FILE VERSION ON FILE SYSTEM

adident Header <file_name>
or

strings -a <file_name | grep -i '$Header'
Here adident is AD Utility (Oracle Apps) and strings is Unix utility.
For example, if you want to find the version of plx file POXPOEPO.plx (under $AU_TOP/resources)

$ adident Header POXPOEPO.plx
POXPOEPO.plx:
$Header POXPOEPO.pld 120.43.12010000.33 2012/07/13 08:52:17 jictang ship $

OR

$ strings POXPOEPO.plx | grep -i '$Header' 

$Header: POXPOEPO.pld 120.43.12010000.33 2012/07/13 08:52:17 jictang ship $

DATABASE VERSION

APPS@dba > select * from v$version;
 
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

UNIX OPERATING SYSTEM VERSION

Solaris -> cat /etc/release

Red Hat Linux -> cat /etc/redhat-release

$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.8 (Tikanga)

THE BELOW SCRIPT can also be used to collect Apache, Jserv, Forms, Jinitiator and Perl version in E-Business suite R12 for Unix Generic, Linux, HP-UX,IBM AIX, Sun solaris operating systems

Before running the script ensure that you have sourced the environment

---------------------------------------- Cut here -------------------------------------------------------------
 
#
 
(
echo "Script Started "
date
## The script shows output on screen and creates file named hostname_date.txt file in current ## directory
## Collect the Apache version
echo "*****Apache Version*****"
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v
echo " "
## Collect perl version
echo "*****perl version******"
$IAS_ORACLE_HOME/perl/bin/perl -v|grep built
echo " "
## Collect Java version
echo "******Java Version******"
sh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print $2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;"
echo " "
## Collect client JRE version
echo "*****Client JRE version*****"
cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35
echo " "
## Collect Forms version
echo "*****Forms Version*****"
$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
echo " "
## Collect PL/SQL Version
echo "*****PL/SQL Version****"
$ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version
echo " "
## Collect Forms communication mode
echo "****Forms Communication Mode****"
cat $FORMS_WEB_CONFIG_FILE|grep serverURL=
echo "If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet"
echo " "
echo "Script Completed Successfully and it has generated the file zz`hostname`_`date +%m%d%y.%H%M`.txt file in current directory"
echo "Script completed "
date
) 2>&1 | tee zz`hostname`_`date +%m%d%y.%H%M`.txt
###
### END OF SCRIPT
###
 
---------------------------------------- Cut here -------------------------------------------------------------

Save above script as shell (.sh) script and execute. It will provide output as shown below.

$ sh scr.sh
 
Script Started
Sat Apr 19 02:42:05 CDT 2014
*****Apache Version*****
Server version: Oracle-Application-Server-10g/10.1.3.5.0 Oracle-HTTP-Server
Server built: Jul 21 2009 11:12:22
 
*****perl version******
This is perl, v5.8.3 built for i686-linux-thread-multi
 
******Java Version******
java version "1.6.0_10"
Java(TM) SE Runtime Environment (build 1.6.0_10-b33)
Java HotSpot(TM) Server VM (build 11.0-b15, mixed mode)
 
*****Client JRE version*****
sun_plugin_version=1.6.0_07
 
*****Forms Version*****
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)
 
*****PL/SQL Version****
PL/SQL Version 10.1.0.5.0 (Production)
 
****Forms Communication Mode****
serverURL=/forms/lservlet
If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet
 
Script Completed Successfully and it has generated the file zzdclnderp10_041914.0242.txt file in current directory
Script completed

Author
Recent Posts

Brijesh Gogia

I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).

Finding Oracle Applications Component Versions

Related posts:

One Comment