Awinstall Errors with ORA-01775: looping chain of synonyms

Document ID : KB000084789
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
ORA-01775: looping chain of synonyms

When running awinstall with option one the above error message is displayed in the $AW_HOME/install/awinstall.log.
 
Cause:
Cause type:
Other
Root Cause: This is an Oracle database error generated by the database. Oracle defines the error message as followed….
ORA-01775: looping chain of synonyms
Cause: Through a series of CREATE synonym statements, a synonym was defined that referred to itself. For example, the following definitions are circular:


CREATE SYNONYM s1 for s2 CREATE SYNONYM s2 for s3 CREATE SYNONYM s3 for s1

Action: Change one synonym definition so that it applies to a base table or view and retry the operation.
Resolution:
Contact your database administrator to resolve the error on the Oracle database.

Fix Status: No Fix

Additional Information:
Workaround :
N/A