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. Error when running utlrp.sql during upgrade from Oracle 10.2.0.3 to 10.2.0.4

    Error when running utlrp.sql during upgrade from Oracle 10.2.0.3 to 10.2.0.4

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 19.01

    Description:
    I'm trying to complete the upgrade to Oracle 10.2.0.4, and I ran into a problem when running utlrp.sql. It reported 2 errors during the recompilation. Here are the errors:

    idle> select * from UTL_RECOMP_ERRORS;

    OBJ# ERROR_AT
    ---------- ---------------------------------------------------------------------------
    COMPILE_ERR
    -----------------------------------------------------------------------------------------------------------------------------------
    10095 14-MAY-10 07.53.30.180956 AM
    ORA-04045: errors during recompilation/revalidation of I161_ILL01.Z50
    ORA-00980: synonym translation is no longer valid

    10250 14-MAY-10 07.53.30.185573 AM
    ORA-04045: errors during recompilation/revalidation of I161_ACPIL.Z50
    ORA-00980: synonym translation is no longer valid

    Are these anything we need to worry about, or do these need to be corrected? If so, how?

    Resolution:
    Whereas the following SQL retrieves 8 rows on your (v19) server:
    SQL> select synonym_name, owner from all_synonyms where owner like 'I1%';

    It retrieves 0 rows on our v19 or v20 servers.

    Also, though the following SQL retrieves 171 rows on your (v19) server, it retrieves 0 rows on our servers:
    SQL> select owner, table_name from all_tables where owner like 'I1%';

    Though the ILLSV library shows (in UTIL-A-17-5-1) a synomym of usm50.z50 for the Z50 table, that is the only synonym of this nature that I find.

    You can do the following SQL to drop these extraneous synonyms:
    DROP SYNONYM I161_ILL01.Z50;
    DROP SYNONYM I161_ACPIL.Z50;

    I believe you can also drop the other synonyms and tables with 'I161_' as the owner (-- though their continued presence should do no active harm).


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Error when logging into xxx01 library
      • Error when trying to save new records, IDN already exists
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 19.01
      2. contype:kba
      3. Prod:Aleph
      4. 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