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: [...]

Introduction: 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 [...]

Introduction: 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 [...]

Introduction: [...]

Introduction: 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 in case of loss. Why we [...]

INTRODUCTION: 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 [...]

Problem: 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. Cause: This issue [...]

In 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 in sync. [...]

INTRODUCTION 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 [...]

1.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 [...]