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

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

    • 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
    //Feedback