Avatar of photostephen
photostephen asked on

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.
Enterprise SoftwareOracle Database

Avatar of undefined
Last Comment
photostephen

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
madunix

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
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
ASKER
photostephen

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
William Peck