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.

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Contact your database administrator to resolve the error on the Oracle database.

Fix Status: No Fix

Additional Information

Workaround :
N/A