Skip to content

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

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

$ $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
Brijesh Gogia

One Comment

  1. Alex Alex

    Hi Expertoracle,

    i would like to know if you have some post regarding applying Jan 2016 Oracle CPU patch for EBS R12.2.3 release

    regards,
    Alex

Leave a Reply