Syed Saad Ali

Oracle ACE Associate

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Associate

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog Post

How to FIND Oracle EBS R12 Component Versions

October 11, 2022 APPS DBA
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

 

 

Tags:
Related Posts
Write a comment