Posts by Ragunathan Kannan

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired The error is raised when the following statement is executed against the Oracle Database. SQL> truncate table WRI$_OPTSTAT_HISTHEAD_HISTORY; truncate…

Read More

ORA-16826: apply service state is inconsistent with the DelayMins property

ORA-16826: apply service state is inconsistent with the DelayMins property Workaround: Check DG configuration: DGMGRL> show configuration Configuration – new_DG_CONFIG Protection Mode: MaxPerformance Databases: new – Primary database newia –…

Read More

To find the user process_id from EBS Front End R12

Navigate to System Administrator–> Security –> User –> Monitor Note the User Name and Oracle Process ID Now run this sql as &PID=Oracle Process ID &USER_NAME=User Name SELECT SUBSTR(d.user_name,1,30) “User…

Read More

UPGRADE ORACLE APEX FROM 5.0.X TO 18.1

Current Setup : Apex Version : Oracle Apex 5.0 Webserver : ORDS Running on Apache Tomcat 9 DB Version : Oracle 12.2 • Step 1: Download Apex 18.1 from Oracle…

Read More

After Upgrade to 12C utlrp got hang

We were performing database upgrade from oracle 11g to oracle 12c with Oracle Apps 12.1.3. We faced an issue where database upgrade took < 30 mins. However, it made huge…

Read More