Package bodies DBMS_NETWORK_ACL_ADMIN and DBMS_XS_PRINCIPAL_EVENTS_INT become invalid after upgrading database to 11.1.0.6 or higher version. (Doc ID 1257664.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 01-Sep-2014***

Symptoms

(i) Package bodies DBMS_NETWORK_ACL_ADMIN and DBMS_XS_PRINCIPAL_EVENTS_INT become invalid after upgrading database to 11.1.0.6 or higher version.

(ii) XDB can also be invalid but it is not the case every time.

(iii) Running XDBRELOD.SQL gives ORA-01775.


SQL> grant select on DBA_NETWORK_ACLS to select_catalog_role
2 /
grant select on DBA_NETWORK_ACLS to select_catalog_role
*
ERROR at line 1:
ORA-01775: looping chain of synonyms


SQL> comment on table DBA_NETWORK_ACLS is
2 'Access control lists assigned to restrict access to network hosts through PL/SQL network utility packages'
3 /
comment on table DBA_NETWORK_ACLS is
*
ERROR at line 1:
ORA-01775: looping chain of synonyms


(iv) Compilation of these package bodies gives ora-00942.



SQL> alter package DBMS_NETWORK_ACL_ADMIN compile body;

Warning: Package Body altered with compilation errors.

SQL> sho err
Errors for PACKAGE BODY DBMS_NETWORK_ACL_ADMIN:

LINE/COL ERROR
-------- -----------------------------------------------------------------
83/5 PL/SQL: SQL Statement ignored
84/16 PL/SQL: ORA-00942: table or view does not exist
SQL> alter package DBMS_XS_PRINCIPAL_EVENTS_INT compile body;

Warning: Package Body altered with compilation errors.

SQL> sho err
Errors for PACKAGE BODY DBMS_XS_PRINCIPAL_EVENTS_INT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
201/7 PL/SQL: SQL Statement ignored
201/18 PL/SQL: ORA-00942: table or view does not exist
209/7 PL/SQL: SQL Statement ignored
209/18 PL/SQL: ORA-00942: table or view does not exist



Changes


Database is upgraded to 11.1.0.6 or higher version.

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