Awinstall Errors with ORA-01775: looping chain of synonyms

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.
 

Environment

CA Automic Applications Manager

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.

Additional Information

Workaround :
N/A