Database Administration (MOSC)

MOSC Banner

Getting further information on an ORA-604 error

edited Feb 20, 2015 10:01AM in Database Administration (MOSC) 6 commentsAnswered

Hello,

I saw a few entries in a given alert log file such as the one pasted below:

opidcl aborting process unknown ospid (10450) as a result of ORA-604

I'd like to dig down futher into the error stack to identify the root cause. I could perhaps set sql_trace to true and turn it off once the error recurs; however, this error comes intermittently, and I want to be careful with leaving sql_trace on for a long period of time. Another option would be to audit all statements issued to the database, and extract the SQL statement on a given, reported PID.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center