How to FIND Oracle EBS R12 Component Versions

 

 1.  How to Find Oracle EBS Application Version Release?

SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
12.2.8

2 : How to Find Oracle Database Version Release?

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

 

3: How to FIND Operating System Version?

 

OPERATING SYSTEM	COMMANDS
SOLARIS	cat /etc/release
RED HAT ENTERPRISE LINUX	cat /etc/redhat-release
ORACLE LINUX	cat /etc/oracle-release

 

4:  How to FIND Apache, Forms, Java, Reports, Perl, and Weblogic Version?

COMPONENTS	COMMANDS
APACHE	$IAS_ORACLE_HOME/ohs/bin/httpd -v $ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
FORMS	frmcmp_batch | grep Version | grep Forms $ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
REPORTS	$ORACLE_HOME/bin/rwrun | grep Release
JAVA	#sh -c “`awk -F= ‘$1 ~ /^JSERVJAVA.*$/ {print$2}’ $ADMIN_SCRIPTS_HOME/java.sh` -version;” #java -version cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35
PERL	$IAS_ORACLE_HOME/perl/bin/perl -v | grep built
WEBLOGIC	cd $FMW_HOME/wlserver_10.3/server/lib #java -cp weblogic.jar weblogic.version