Link to home
Start Free TrialLog in
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.
Avatar of Praveen Kumar Chandrashekatr
Praveen Kumar Chandrashekatr
Flag of India image

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
Avatar of madunix
madunix

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of photostephen
photostephen

ASKER

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.