Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
ORA 600 and ORA 3137 errors after upgrading to Oracle 11g
We recently upgraded our Oracle Database from Oracle 10g to 11g. Now we see Oracle errors, specifically ORA-0600 and ORA-3137 errors.
When we find an ORA-0600 error, we can find the query in the log which causes the error, and by using the command
ANALYSE TABLE <<tabl;e name here>> DELETE STATISTICS
this clears the error.
When we find an ORA-3137 error, we can not identify the exact query which causes the error.
Both errors are happening a few times per week.
I need suggestions on how to solve this problem, or at least hints on what additional places I should look for information about these errors and what else I should be doing proactively.
8/22/2022 - Mon
Praveen Kumar Chandrashekatr
It looks like oracle internal error raise and SR with oracle support... if you and metalink account.
please post your alert log file details when that error occurred and related trace file..
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Thank you for suggesting notes to check in MetaLink.
I have submitted this error as an SR to Oracle, now I just have to wait for a reply.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent