Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Errors in clear_vir01, file-03, and Oracle alert log

    Errors in clear_vir01, file-03, and Oracle alert log

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    1. clear_vir01 and file-03 ((Export Database Tables) take 8 minutes (rather than a single minute)

    2. clear_vir01 has the following errors:

    identifier 'F1_Z52' must be declared
    object F1_Z52 does not exist
    Username:SQL*Loader-350: Syntax error at line 1.
    Expecting keyword LOAD, found "*".

    3. file-03 has the following error:

    identifier 'DUMP_DLM_TABLE_1_Z305' must be declared

    4. Error in Oracle alert log:

    ORA-1654: unable to extend index SYS.I_WARNING_SETTINGS by 8 in tablespace
    SYSTEM

    Cause:
    As seen in util o/14/1:

    TABLESPACE_WITHOUT_FREE_SPACE
    ------------------------------
    SYSTEM

    Resolution:
    Add datafile to SYSTEM tablespace using util o/13/3 (or directly in Oracle).

    Additional Information

    1. The complete clear_vir01 log shows the following errors:

    vir01@ALEPH20> > > > > 2 begin f1_Z52; end;
    *
    ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'F1_Z52' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored


    No errors.
    1* begin f1_Z52; end;
    drop procedure f1_Z52
    *
    ERROR at line 1:
    ORA-04043: object F1_Z52 does not exist


    2 begin f2_Z52; end;
    *
    ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'F2_Z52' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    <etc.>


    2. file-03 log showing errors:

    ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'DUMP_DLM_TABLE_1_Z305' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored


    No errors.
    1* begin dump_dlm_table_1_Z305; end;
    2 begin dump_dlm_table_2_Z305; end;
    *
    ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'DUMP_DLM_TABLE_2_Z305' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    <etc.>

    Category: System Management (500)

    Subject: Oracle (500)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Errors in circulation statistics
      • Errors in util sp step "8. Extract products updates"
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Oracle (500)
      4. Prod:Aleph
      5. System Management (500)
      6. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved