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

[Post Views: 2333]

Read Offline: PDF Download

Brijesh Gogia

I’m an experienced Oracle Applications DBA with more than a decade of full-time DBA experience. I have gained a wide knowledge of the Oracle software stack and have worked on several big projects for multi-national companies. I enjoy working with the leading-edge technology and have passion for database performance and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
  
You can connect with me on LinkedIn.

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

Required fields are marked *