Oracle Database Discussions

Hello,

I had some issues with the database and then we need to force this database open.

After opening it we need to take the full export of the database which I took.

Then I recreate the database and ran ran catalog, catproc and other component's cripts.

I created additional tablespaces and users.

Later I imported the database -

imp full=y file=full_tlsbx01_20100127.dmp log=imp_tlsbx01_20100127.log ignore=Y

But import gave me lot of errors like ORA errors like -

ORA-04055, ORA-06550,ORA-00001,ORA-02264,ORA-20000

and some IMP erros like -

IMP-00061,IMP-00041,IMP-00003,IMP-00003,IMP-00017,IMP-00019,IMP-00032,IMP-00008.

While looking at the INVALID objects I can see number of SYSMAN objects are in invalid state -

SQL> select owner,count(*) from dba_objects where status='INVALID' group by owner;

OWNER COUNT(*)
------------------------------ ----------
SYSTEM 3
PUBLIC 4
SYSMAN 96

while trying to look at these objects I found that some of the objects are created error -

ORA-01775: looping chain of synonyms

Problem is with the SYSMAN (GRID)

Looking forward to your advice/recommendations.