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 APRIL 17, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2 and later   [Release: 10.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
....

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms