Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Today, between 3:00pm-3:30pm, my Oracle 10g database on Windows hanged on twice. Error messages were related to ORA-00604. I'm pretty sure it was some query or queries that some user run as owner of some schema.

I'm checking listener.log, archived redo logs from that time (about 20 million records) and alert.instance-name.log on C:\oracle\product\10.2.0\admin\instance-name\bdump, but I don't find any anormal related to ORA-00604.

Would you suggest how or what else to search?

share|improve this question
    
Look at the other errors that surround it. If nothing jumps out, contact Oracle support. –  Mat Oct 16 '12 at 5:00
    
As @Mat said, ORA-00604 usually has associated errors which should be under the ORA-00604 report. Where did you see the ORA-00604 error report? –  Phil Oct 16 '12 at 8:22
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.