How to FIND Oracle EBS R12 Component Versions
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 |