Month: October 2022

October 11, 2022 How to FIND Oracle EBS R12 Component Versions

APPS DBA

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