Introduction During the ADOP (Online Patching) process of Oracle E-Business Suite (EBS), you might encounter the following error message while running Autoconfig as part of adop phase=prepare: ORA-20001: Synonym does…
Read MoreIntroduction: The ADOP (Autonomous Database Operations) process is a crucial component of the Oracle E-Business Suite (EBS) used during patching, cloning, and upgrades. During the validation phase of ADOP, a series of…
Read MoreIntroduction: In Oracle E-Business Suite 12.2, concurrent requests can occasionally be placed on hold due to various system behaviors and user actions. This blog will outline the key scenarios that…
Read MoreIntroduction: In this blog, we will walk through the process of enabling debug logging and tracing in Oracle APEX applications. Debug logging and tracing are essential techniques for diagnosing problems, understanding application behavior, and improving performance. By capturing detailed logs and execution traces, developers can gain insights into the inner workings of their APEX applications, making it easier to pinpoint and address issues. Step 1: In the Browser login into APEX as “DEVELOPER” Step 2: Run the application which will be running the Report Take down the URL’s session ID as like below. “https://***.**.*.**/ords/f?p=521:101:8786047580303:::::” In my scenario the session ID is 8786047580303 Navigate to Administration–>Monitor Activity as per below snip Step 3: Monitor Activity–>Active Sessions Search for the session ID of Apex runtime “8786047580303” The screen appears like below. Click on Active session id. We can find the session details below Step 4: Make below changes as per below image attached Debug Level –>”APEX Trace” & Trace Mode –>”SQL Trace” Apply the changes. Step 5: After applying changes we can able to see the Debug id as below Once you click the “Debug ID”, you should be seeing page Step 6: Clicking Actions–>Download–>HTML. Step 7: Finally we can download the trace file as PDF or HTML Format. Conclusion: Enabling debug logging and tracing for our Apex application is crucial for effectively diagnosing and resolving runtime issues. By carefully configuring debug logs, we can capture detailed information on code execution, database operations, and other critical components of our environment.This detailed logging allows us to identify and address problems efficiently.
Read MoreIntroduction: In this article, we are here to know different ways to generate the backup in the MySQL database server. It is essential to make regular backups of all data…
Read MoreINTRODUCTION: This doc will guide you through the process of performing a MySQL replication switchover, ensuring a smooth transition without any data loss. Let’s dive into the step-by-step instructions. Step…
Read MoreProblem: After patching an Oracle 19.8 GRID_HOME on Oracle Restart setup with 19.20 RU patch [35319490], I was not able to start up Oracle Restart HAS due to mentioned error.…
Read MoreIn this case how to open your standby database in read/write mode when you don’t have any access (Lost) on Primary database. NOTE: Currently both Primary and Standby database are…
Read MoreINTRODUCTION What is scan name for Oracle database? Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments that provides a single name for clients to…
Read More1.To Display the execution plan of the last SQL statement executed by the current session SET LINESIZE 150 SET PAGESIZE 2000 SELECT * FROM table (DBMS_XPLAN.DISPLAY_CURSOR); 2.To display the execution…
Read More