ORA-00980: synonym translation is no longer valid ORA-01775: looping chain of synonyms

        Dynamic And Static Views Are Not Working In Oracle DB

Symptoms: Views are not working in my database

SQL> select name from v$database;

Error at line 1;

ORA-00980: synonym translation is no longer valid 

SQL> Select * from dba_objects;

Error at line 1;

ORA-01775: looping chain of synonyms

Solution:

1. Ensure full database backup, pfile backup and export backup for metadata

2. Shutdown database in normal mode

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

3. Start Database in upgrade mode, upgrade mode behaves as restrict mode.

SQL> Startup upgrade;
Total System Global Area  599785472 bytes
Fixed Size                  1220804 bytes
Variable Size             180358972 bytes
Database Buffers          415236096 bytes
Redo Buffers                2969600 bytes
Database mounted.
Database opened.
SQL>

4. Run Catalog.sql, Cataproc.sql & Pupbld.sql

SQL>@$ORACLE_HOME/rdbms/admin/catalog.sql;
SQL>@$ORACLE_HOME/rdbms/admin/cataproc.sql;
SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql;

5. Now check views

SQL> Select name from v$database;
NAME
-----
ORADB

6. Shutdown Database And Startup As Normal Mode

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> Startup ;
Total System Global Area  599785472 bytes
Fixed Size                  1220804 bytes
Variable Size             180358972 bytes
Database Buffers          415236096 bytes
Redo Buffers                2969600 bytes
Database mounted.
Database opened.

SQL> Select name from v$database;
NAME
-----
ORADB

Note: By running Catalog.sql, Catproc.sql as normal startup mode is halmful to database

######################################################  All The Best ######################################################