Wednesday, September 12, 2018

Oracle EBS R12 Component Versions

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


SQL> select release_name from apps.fnd_product_groups;
RELEASE_NAME
12.2.5



SQL> SELECT * FROM V$VERSION;
BANNER  CON_ID
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production         0
PL/SQL Release 12.1.0.2.0 - Production         0
CORE    12.1.0.2.0      Production         0
TNS for Linux: Version 12.1.0.2.0 - Production         0
NLSRTL Version 12.1.0.2.0 - Production         0



UNIX OPERATING SYSTEM VERSION
Solaris -> cat /etc/release
Red Hat Linux -> cat /etc/redhat-release
Oracle Linux -> cat /etc/oracle-release

Oracle Linux Server release 7.2


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


Apache version
#$IAS_ORACLE_HOME/ohs/bin/httpd -v


FORMS VERSION
#frmcmp_batch | grep Version | grep Forms
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)


REPORT VERSION
#$ORACLE_HOME/bin/rwrun | grep Release
Report Builder: Release 10.1.2.3.0 - Production on Tue Sep 11 11:02:13 2018


FILE VERSION ON FILE SYSTEM
#adident Header <file_name>
#strings -a select * from v$version;


PERL VERSION
$IAS_ORACLE_HOME/perl/bin/perl -v | grep built
This is perl, v5.10.0 built for x86_64-linux-thread-multi


JAVA VERSION
#sh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print$2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;"
#java -version

java version "1.7.0_85"
Java(TM) SE Runtime Environment (build 1.7.0_85-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.85-b06, mixed mode)



CLIENT JRE VERSION
#cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35
sun_plugin_version=1.6.0_27


FORMS VERSION
#$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)


PL/SQL VERSION
#$ORACLE_HOME/bin/frmcmp_batch | grep PL/SQL|grep Version
PL/SQL Version 10.1.0.5.0 (Production)


FORMS COMMUNICATION MODE (If the serverURL parameter has no value then Forms is implemented in socket mode else servlet mode)
#cat $FORMS_WEB_CONFIG_FILE|grep serverURL=
serverURL=/forms/lservlet


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

WebLogic Server 10.3.6.0  Tue Nov 15 08:52:36 PST 2011 1441050
Use 'weblogic.version -verbose' to get subsystem information
Use 'weblogic.utils.Versions' to get version information for all modules



#more $EBS_DOMAIN_HOME/servers/AdminServer/logs/AdminServer.log | grep 10.3.6
WebLogic Server 10.3.6.0.160719 PSU Patch for BUG23094342 MON MAY 23 12:34:42 IST 2016
WebLogic Server 10.3.6.0  Tue Nov 15 08:52:36 PST 2011 1441050 >
WebLogic Server 10.3.6.0.160719 PSU Patch for BUG23094342 MON MAY 23 12:34:42 IST 2016
WebLogic Server 10.3.6.0  Tue Nov 15 08:52:36 PST 2011 1441050  Copyright (c) 1995, 2011, Oracle and/or its affiliates. All rights reserved.



For any queries you can email me on samiappsdba@gmail.com