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