Awinstall Errors with ORA-01775: looping chain of synonyms
book
Article ID: 84789
calendar_today
Updated On:
Products
CA Automic Applications Manager (AM)
Issue/Introduction
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.