Getting ORA-00604 error when connecting to database user

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

I am getting the following error: ORA-00604:error occurred at recursive sql level 1. This error occurred when I was trying to connect to the database user. But if I grant DBA role, that user is able to connect. System user is able to connect but scott is not able to connect.
Oracle does a lot of work behind the scenes for you. It does this through its own SQL statements. Any SQL statement Oracle issues for you is a "recursive SQL" statement. There could be many SQL statements that are causing your problem. What I would do is to set SQL_TRACE=TRUE in my INIT.ORA and restart the database. I would then duplicate the ORA-604 error. This will generate many trace files in your USER_DUMP_DEST directory for all user processes. Immediately after the error, bring down the database and set SQL_TRACE=FALSE. You can then start your database again. Now dig through the trace files you just generated in your USER_DUMP_DEST directory to find the one that has the ORA-604 error. Right where the ORA-604 error is found will be the recursive SQL statement that had the problem and the "real" error that it experienced. Your solution will depend on the statement and the real error.

This was last published in December 2003

Dig Deeper on Oracle database design and architecture

All
News
Get Started
Evaluate
Manage
Problem Solve

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Related Resources

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.