My Oracle Support Banner

ORA-1775 Reported When Compiling Package Body (Doc ID 1933987.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Whilst a specific case is detailed here , please follow this following analysis to establish whether you may be encountering
the same root issue .


1. When applying the 11.2.0.4. patchset and running upgrade script, the following is observed :

...
SQL> CREATE OR REPLACE PACKAGE BODY sys.dbms_logmnr_internal wrapped
...
766  /

Warning: Package Body created with compilation errors.

SQL> show errors
Errors for PACKAGE BODY SYS.DBMS_LOGMNR_INTERNAL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      ORA-01775: looping chain of synonyms

2.  There are no dependent synonyms for this object :

select owner,object_name,object_id,object_type,status from dba_objects where object_id in ( select p_OBJ# from DEPENDENCY$ where d_obj# = (select object_id from dba_objects where object_name like 'DBMS_LOGMNR_INTERNAL' and object_type = 'PACKAGE BODY'));

3. "hcheck.sql" script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g - Doc id  136697.1

On running this script , the following is reported in the output :

...

HCKW-0018: OBJECT name clashes with SCHEMA name    <<<<
Schema=SYSTEM Object=PUBLIC.SYSTEM (SYNONYM)     

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
Cause
Solution


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