Oracle errors ORA-00604 and ORA-20001

working in oracle and up to last night all wokred fine, but today I am getting this error and not too sure what is causing that, any help would be appreciated.
I get it everytime I create a user and try to login as that user.

Thanks

SQL> connect a/a
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-20001: User not found in the lookup
ORA-06512: at line 6
tfbsrAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

csachdevaCommented:
ORA-00604 error in Oracle 8i
 
Cause: An error occurred while processing a recursive SQL statement. A recursive SQL statement is one that applies to internal dictionary tables.  
 
Action: If the situation described in the next message on the stack can be corrected, do so; otherwise, contact customer support.  

and In oracle 9i & 10g

Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).  
 
Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support Services


Whenever you issue a query, the system must issue queries in the background to determine many things, such as "do you have permissions to perform the query?", "does the object you are accessing exist?". These queries that the system issues are called "recursive SQL". Sometimes, a recursive SQL statement needs recursive SQL of it's own. So these recursive SQL statements are at another level, level 2.

You won't see recursive SQL statements in SQL*Plus. The best way to see them is by starting a trace in the session. Start up SQL*Plus, then issue the following:

 ALTER SESSION SET sql_trace=TRUE;

Then run your process until it bombs out. Go ahead and exit SQL*Plus. Now go to your USER_DUMP_DEST directory. A trace file will have been generated for you. Look in the trace file for any ORA errors. This is the root cause of your problem. Correcting this ORA error will stop the ORA-600 error from occuring.

Most ORA-600 errors can be fixed by signing on as SYS and running CATALOG and CATPROC from ORACLE_HOME/rdbms/admin.

Hope it will sort out your query.

regards,
Chetan Sachdeva
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.