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

    p_manage_01 z98_id build: "Resource busy and acquire with NOWAIT specified"

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    There were error messages reported with creation of z97 and z98 indexes at the end of p_manage_01 in ABC01.

    For Z97, the indexes were created regardless.

    For Z98:

    > CREATE UNIQUE INDEX LDS01.Z98_ID ON ABC01.Z98 (Z98_REC_KEY ASC)
    ERROR at line 1:
    ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

    Error : Only 0 indexes out of 1 for table z98 were created
    Error : index list for index creation was 'z98_id'

    util a/17/14 also shows that the index was not created.

    Should we try to recreate the index with util a/17/18?

    Resolution:
    You do not want or need to do util a/17/18 -- that applies only to the case where the index-building has failed because of duplicates --that's different than "Resource Busy".

    From site: The issue was resolved by adding space to the TEMP dir. We do not use this in our standard RAC setup; that is why it was so small.

    KB's 8192-7895 and 8192-7896 also discuss "Resource Busy".


    • Article last edited: 10/8/2013