How to activate Periodic Alert Scheduler in Oracle EBS Application Step 1:Login to ORACLE EBS Application HOME PAGE with Alert Manager Responsibility We need to Login the Oracle EBS Application…
Read MoreERROR: FORM session is not opening after the clone SOLUTION: Go to FORMS node if it is multi node. cd $ORACLE_HOME/lib32 ls -lrt ldflags unlink ldflags ln -s /devweb/oracle/TEST/apps/tech_st/10.1.2/lib32/ldflags ldflags…
Read MoreERROR: RC-50204: Error: – Web Listener Port in use: Port Value = 8009 CAUSE: When cloning we have faced this error. This is due to some other process is using…
Read MoreMonitoring Progress of a SQL Execution Plan / sql query is really hanged or not How to check the progress of a query is making from within the execution plan…
Read MoreError: Re-link fails on target “client_sharedlib”. Re-link fails on target “client_sharedlib”. Re-link fails on target “ldapmoddn”. Re-link fails on target “ldapmodifymt”. Re-link fails on target “ldapaddmt”. Re-link fails on target…
Read MoreERROR: ORA-19909: datafile 1 belongs to an orphan incarnation When I tried to Flashback on in standby database then suddenly below message found in alert log and standby database not…
Read MoreProblem Scheduled Request Goes Inactive/On Hold Status Automatically by Concurrent Manager User Cause: It is an oracle bug Solution 1.Apply the Patch -22549247 2.It will give you a newer file…
Read MoreFollow the below steps to resolve program stuck in OPP issues, 1.You will need to check and fix the Invalid FND Objects : select owner, object_name,object_type,status from dba_objects where status =’INVALID’ and object_name like ‘FND%’; 2.AQ$_FND_CP_GSM_OPP_AQTBL tables has a lot of rows and purge is needed select count(*) from applsys.FND_CP_GSM_OPP_AQTBL ; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_T; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_G; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_H; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_I;…
Read More1.Start the Tomcat a.source the java path $ cat tomcat_java.env export JAVA_HOME=/rupdb01/oracle/tomcat/java71_64 export PATH=/rupdb01/oracle/tomcat/java71_64/jre/bin:$PATH b.Go to the tomcat installed location $ cd apache-tomcat-8.5.37/bin c.execute startup.sh $ sh startup.sh Using CATALINA_BASE:…
Read MoreBelow steps for installing tomcat in oracle 1.Pre-req: Install Java 8 For Apache Tomcat 9 to be installed and configured properly, you need to have Java version 8 installed on…
Read More