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

• 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