Error ORA-20001: ORA-01775 running Oracle grant script (4252839)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error ORA-20001: ORA-01775 running Oracle grant script
Description

When running Oracle cartridge grant script manually directly on the Oracle database the following error appears:

ORA-2001: ORA-01775: looping chain of synonyms, sql: grant select on dba_waiters
ORA-06512: at "SYS.EXECUTE_IMMEDIATE", line 34
ORA-06512: at line 318
Cause

Oracle DBA_WAITERS view was not created or was created and deleted
Resolution
Perform following steps:
1. Recreate DBA_WAITERS view that dynamically displays lock dependency by running the catblock.sql script as SYS user
  $ORACLE_HOME/rdbms/admin/catblock.sql
2. Re-run Oracle grant script

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title