Managing large datasets efficiently is a key challenge for database administrators (DBAs). One solution to this problem is table partitioning, a feature in Oracle databases that allows large [...]

In Oracle E-Business Suite (EBS) environments, it’s a good practice to occasionally analyze the largest database objects to identify potential inefficiencies. Recently, I discovered that the [...]

Exploring the New Features in Oracle 23c: What You Need to Know Oracle’s latest release, Oracle 23c, brings a suite of new features and enhancements designed to improve database management, [...]

Introduction In today’s fast-paced digital landscape, maintaining the health and performance of your Oracle databases is critical. The Oracle Autonomous Health Framework (AHF) is your go-to suite [...]

Introduction: Upgrading from Oracle E-Business Suite 11i to R12 or transitioning between 12.x versions is a crucial step for organizations seeking enhanced functionality and improved performance. [...]

During Cutover phase while Patching  , ADOP failed with below error stating unable to start the application. Please find the root cause and its related solution below Error :   *******FATAL [...]

Login to AWS Management Console Then Navigate to EC2 Click Launch Instance   Choose an AMI       Choose Instance Type   Configure Security Group Launch the instance [...]

Description : When triggering ADOP prepare phase on 12.2.8 environment for patching got below error. Error: PROCEDURE] Calling: [...]

Below was the detailed error found on /u01/TEST/R12apps/fs2/inst/apps/TEST_Mars/admin/log/clone/patch/txkSetOHSConfig_01567873/provision_01567873.log Error : ======= Connecting Run file system [...]

My user name which not synced is “JASON” There are two methods to synchronize user data. First Method : This one is our usual method , which will be done by all our APPS DBA. 1. End [...]