ora-00054 Error!Resource busy!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ora-00054 Error!Resource busy!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    Query:

    1.I encountered this error to-day:

    ora-00054:resource busy and acquire with noawait result.

    Why this error occurs!

    What should be done to solve this!

    Regards,

    Amitstora.

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Nothing. Retry. This is a quite normal message and is reported if a SQL statement would have blocked waiting for
    another user to complete some operation.

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    solution

    Dear Friend, 2nd Sep 2001 17:11 hrs chennai

    Problemra-00054:resource busy and acquire with noawait result.

    Cause:While you're trying to alter/drop a table when someone is busy updating the thing.

    Solution:Run the fololwing script to find the root cause user and kill his session.

    -----------------------------------
    column oracle_username heading "Ora User" format a10
    column os_user_name heading "OS User" format a10
    column session_id heading "Sess#" format 999
    column process heading "PID" format 999999
    column object_name heading "Object" format a30

    select oracle_username,
    os_user_name,
    session_id,
    process,
    object_name
    from v$locked_object a,
    dba_objects b
    where a.object_id = b.object_id
    order by oracle_username
    /

    clear columns
    --------------------------------

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width