Basic understanding: The Information Technology Infrastructure Library (ITIL) mainly deals with services, is a set of concepts and practices for Information Technology Services Management (ITSM), Information Technology (IT) development and…
Read MoreAPPLIES TO: Oracle XML Gateway - Version 11.5 to 12.2.7 [Release 11.5 to 12.2] Information in this document applies to any platform. GOAL: Provide a SQL Script to Determine if…
Read MoreAPPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [Release 10.2] Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine -…
Read MoreFind Index Fragmentation and Usage To Find Index Fragmentation ~~~~~~~~~~~~~~~~~~~~~~~~~~~ analyze index <index_name> validate structure; select round((del_lf_rows/lf_rows)*100,2) ratio, height, lf_blks, lf_rows from index_stats; We are comparing the ratio between no…
Read MoreTroubleshoot RMAN-06214 error RMAN> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK; If error still occurs, then try the below RMAN> CROSSCHECK COPY OF CONTROLFILE; rman> DELETE FORCE NOPROMPT OBSOLETE DEVICE…
Read MoreFix for ORA-03113: end-of-file on communication channel Oracle Database Server 12c Here is how to fix ORA-03113: end-of-file on communication channel [oracle@host ~]$ sqlplus / as sysdba … … Copyright…
Read MoreCREATE OR REPLACE PACKAGE BODY APPS.XXWEBADI_MTL_ONHANDQTY_PKG AS PROCEDURE XXWEBADI_MTL_ONHAND_QTY_INS ( errbuff OUT VARCHAR2, retcode OUT NUMBER ) IS LV_BATCH_MODE VARCHAR2(3); LN_BATCH_ID NUMBER; LV_ERROR VARCHAR2(240) := ‘Unable to load reocords in…
Read MoreE-Business Suite Applications Technology Stack, HTTP / IAS Server related issues Users report cache initialization errors in OA Framework related pages. The oacorestd.err file shows: Exception in static block of…
Read MoreError Noticed in the log file $LOG_HOME/ora/10.1.3/Apache Solution: 1. Noticed the When we have started the Application Services the load average was 1. 2. When executed ps -ef |grep applmgr…
Read MoreError : http 500 internal server error: java.lang.NoClassDefFoundError at oracle.apps.fnd.sso.AppsLoginRedirect.doGet(AppsLoginRedirect.java:623) at javax.servlet.http.HttpServlet.service(HttpServlet.java:743) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0)]. server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) Solution : $cd $ADMIN_SCRIPTS_HOME $adopmnctl.sh stopall…
Read More