1 Reply Latest reply on Mar 19, 2014 1:40 PM by SunilSharma

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

    Suman OTN

      Hi

       

      I get the below error every week in DAC and its been repetitive these days. What we do is restart the job after some time and it runs successfully.

       

      9426  SEVERE  Sun Mar 16 03:03:36 CDT 2014 

      ANOMALY INFO::: DataWarehouse:TRUNCATE TABLE W_AP_XACT_FS

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

       

      Since this error related to database. I have checked with my DBA's and they are also not sure why this is coming repetitively.

       

      I have checked the previous posts on this and I could find the below link. Where the solution for this is stated as to restart the job. And the other one was to clearup archive logs. I have checked with DBA and we got the info that the database which we are using is not in archive mode. So this solution rules out in our case.

       

      Please share our ideas on this if you have faced similar kind of this issue before.

       

      Errors: ORA-00054 & ORA-01452 while running DAC Full Load

       

       

      Thanks