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

Environment Details Server Name                         : primegg.localdomain OS Version                           : Oracle Linux Server release 7 Database Version                 : 19.0.0.0 [...]

Step-1: Check the SCN of Standby ( Data guard ) database and Find the lowest SCN from the following Queries. SQL> SELECT CURRENT_SCN FROM V$DATABASE; CURRENT_SCN -------------- 1165261 SQL> [...]