Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    Unable to lock table xxx01.Z0102 due to ORACLE error 54"

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 14.2

    Description:
    In running p_manage_32 you get this message:

    Username: SQL*Loader-908: Unable to lock table ABC01.Z0102 due to ORACLE error 54.

    Resolution:
    It seems that this occurs when you try to cancel a run of p_manage_32 (or _320) and you kill the manage_32 (or _320) but not the z0102 load process. When the job is restarted, the log will show messages like this:.

    ERROR at line 1:.
    ORA-00054: resource busy and acquire with NOWAIT specified.
    CREATE TABLE ABC01.Z0102 (.
    ERROR at line 1:.
    ORA-00955: name is already used by an existing object.

    Then later, when actually tries to do the load, you get the "Unable to lock ... due to ORACLE error 54".

    • Article last edited: 10/8/2013