-
ORA-01775: looping chain of synonyms when compiling SYS.DBMS_SQLTUNE_INTERNAL
I'm preparing to upgrade a Symantec DLP (v16.0) environment and running into an issue during the Upgrade Readiness Tool (URT) process. Everything passes except the Index Definition Validation, which fails due to errors compiling the SYS.DBMS_SQLTUNE_INTERNAL package body.
I?m receiving the following error when trying to compile manually:
ALTER PACKAGE SYS.DBMS_SQLTUNE_INTERNAL COMPILE BODY;
-- ORA-01775: looping chain of synonyms
However, when I check for synonyms pointing to this package, I find none:
SELECT * FROM dba_synonyms WHERE synonym_name = 'DBMS_SQLTUNE_INTERNAL'; -- no rows
SELECT * FROM dba_dependencies WHERE name = 'DBMS_SQLTUNE_INTERNAL' AND referenced_type = 'SYNONYM'; -- no rows
DBMS_SQLTUNE_INTERNAL package spec is VALID, body is INVALID
Oracle version: 19c SE2
DLP database is functional and schema is valid (ENFORCEVERSION and all critical tables are present)
This issue is blocking some internal URT checks, but does not seem to impact DLP functionality directly
My Questions:
What could cause ORA-01775 when no synonym loops are present?
Is there a way to resolve or bypass this compilation error without Oracle Support?
Is it safe to proceed with the DLP upgrade if this is the only failed check in URT?
What I've Tried:
Ran utlrp.sql ? no change
Attempted manual recompile (ALTER PACKAGE) ? fails with same error
Verified that no synonyms or recursive dependencies exist
Reviewed dba_errors ? no helpful output beyond the synonym error
Any insights, especially from those who've dealt with internal Oracle package issues or Symantec DLP upgrades, would be appreciated.
Capture1.PNG
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|