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 |
ERROR
In Oacore_server.log file:
Exception Details.
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.NoClassDefFoundError, msg=Could not initialize class oracle.apps.fnd.functionSecurity.User;
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
Oacore_Server Output File Error like:
Exception in static block of jtf.cache.CacheManager. Stack trace is: oracle.apps.jtf.base.resources.FrameworkException: IAS Cache initialization failed. The Distributed Caching System failed to initialize on port: 12346. The list of hosts in the distributed caching system is: 16.80.90.80 16.80.90.81. The port 12346 should be free on each host running the JVMs.
SOLUTION
1) Shut down the Application Services or OA_CORE Server Services and check if any Java Cache port number process is accessed by the Operating System.
#netstat -ntpl |grep 12346
(Run this By Root User)
find the process for this port number and kill the process.
2) Find the Process for this Port number with the above command and kill the process.
3) Start the Application or OACORE services.
ERROR
adpreclone.pl Fails on Applications Tier With Error Message “Edit session is enabled in domain
ERROR while running perl /u01/EBS_FS_12.2.7/fs2/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/EBS_FS_12.2.7/fs2/EBSapps/comn/util/jdk64 mode=stage stage=/u01/EBS_FS_12.2.7/fs2/EBSapps/comn/clone component=appsTier method= appctx=/u01/EBS_FS_12.2.7/fs2/inst/apps/PHASE1_acetest/appl/admin/PHASE1_acetest.xml showProgress …
START: Creating FMW archive.
Running /u01/EBS_FS_12.2.7/fs2/FMW_Home/oracle_common/bin/copyBinary.sh -javaHome /u01/EBS_FS_12.2.7/fs2/EBSapps/comn/clone/FMW/t2pjdk -al /u01/EBS_FS_12.2.7/fs2/EBSapps/comn/clone/FMW/FMW_Home.jar -smw /u01/EBS_FS_12.2.7/fs2/FMW_Home -ldl /u01/EBS_FS_12.2.7/fs2/inst/apps/PHASE1_acetest/admin/log/clone/fmwT2PStage -invPtrLoc /etc/oraInst.loc -silent true -debug true
Script Executed in 25233 milliseconds, returning status 255
ERROR: Script failed, exit code 255
SOLUTION
In the Weblogic Console, the Edit session is enabled in the domain. Hence, adpreclone.pl is unable to complete successfully.
Execute the following steps to fix the issue:
1) Login to the WLS Console
2) Review the “Change Center” and click the “Release Configuration”
3) You should see the domain in “Lock & Edit” mode.
4) Re-run adpreclone on the Applications Tier.
ERROR
JSP Error:
Request URI:/OA_HTML/RF.jsp
Exception:
java.lang.NoClassDefFoundError
JSP Error:
Request URI:/OA_HTML/AppsLocalLogin.jsp
Exception:
java.lang.NoClassDefFoundError