My Oracle Support Banner

Oracle Database Server Invalid After Upgrade To 10.2.0.2 Ora-00980 on DBMS_XPLAN and DBMS_SQLTUNE_INTERNAL (Doc ID 390221.1)

Last updated on MARCH 09, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.2 and later
Information in this document applies to any platform.


Symptoms

After upgrading 10.2.0.1 to 10.2.0.2 Oracle Database Server component is INVALID.
There are two packages compiled with errors: DBMS_XPLAN and DBMS_SQLTUNE_INTERNAL.

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY DBMS_XPLAN:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1507/9 PL/SQL: SQL Statement ignored
1511/34 PL/SQL: ORA-00980: synonym translation is no longer valid
1518/9 PL/SQL: SQL Statement ignored
1520/34 PL/SQL: ORA-00980: synonym translation is no longer valid
1526/9 PL/SQL: SQL Statement ignored
1540/27 PL/SQL: ORA-00980: synonym translation is no longer valid

...

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY DBMS_SQLTUNE_INTERNAL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1341/9 PL/SQL: SQL Statement ignored
1344/33 PL/SQL: ORA-00980: synonym translation is no longer valid
1349/9 PL/SQL: Statement ignored
1349/13 PLS-00364: loop index variable 'STAT_REC' use is invalid
1356/9 PL/SQL: Statement ignored
1357/19 PLS-00364: loop index variable 'STAT_REC' use is invalid
3958/8 PL/SQL: SQL Statement ignored
3974/35 PL/SQL: ORA-00980: synonym translation is no longer valid
4003/7 PL/SQL: Statement ignored
....

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.