OraFAQ Forum: Server Administration » I've got the ORA-600 error, but metalink can not help me much more!

Home » RDBMS Server » Server Administration » I've got the ORA-600 error, but metalink can not help me much more! (Linux x86_64, Oracle 9.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I've got the ORA-600 error, but metalink can not help me much more! [message #381591]

Sun, 18 January 2009 21:37

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Hi all!

Before I post here, I've just searched in Google/at_here_OraFaq/Metalink. I've got error:

Quote:

ORA-12801: error signaled in parallel query server P000
ORA-00600: internal error code, arguments: [ksmals], [qrarr], [], [], [], [], [], []

At metalink, I found that, this is the bug 3204937
Bug 3204937 PQ slave may fail with OERI [ksmals], [qrarr]

https://metalink.oracle.com/metalink/plsql/f?p=130:14:8043186014275975382::::p14_database_id,p14_docid,p14_show_header,p14_show_help, p14_black_frame,p14_font:NOT,3204937.8,1,0,1,helvetica

But it can not help me to solve the problem.
Whenever execute the query with ORDER BY, I've got this error.

May you help me?

Thank you!

Report message to a moderator

Re: I've got the ORA-600 error, but metalink can not help me much more! [message #381595 is a reply to message #381591]

Sun, 18 January 2009 22:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> Oracle 9.2.0.1
V9 is obsoleted, retired & unsupported.
At a minimum you should patch up to V9.2.0.7 or upgrade to a supported version.

Report message to a moderator

Re: I've got the ORA-600 error, but metalink can not help me much more! [message #381598 is a reply to message #381595]

Sun, 18 January 2009 22:19

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

First time, thank you!

I'll upgrade to this patch_set as soon as possible.

May you clarify more about this error, eg:
- What did cause it?
- Why it occurred?
- If I decrease the parameter parallel_max_servers=0, will the error occur again?

Thank you!

Report message to a moderator

Re: I've got the ORA-600 error, but metalink can not help me much more! [message #381600 is a reply to message #381591]

Sun, 18 January 2009 22:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

any/every ORA-00600 indicates Oracle detected a condition which "should not" occur; also known as a internal bug.
As such you either learn how to work around it or apply a patch so Oracle no longer throws ORA-00600.
If the solution was already known, it would no longer be a bug!

Report message to a moderator

Re: I've got the ORA-600 error, but metalink can not help me much more! [message #381602 is a reply to message #381600]

Sun, 18 January 2009 22:36

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Yeap!

The Oracle database bug list introduces only the brief information, not internal why, what, and how.

Example:
http://www.wowunix.com/down/patch/oracle/patchset/man/9207_buglist.htm

Some time, I might work as with my experience, some time I can not.

With this error, because of the result was not slowly with few rows to retrieve, ~ 20.000 rows, no such more sessions call concurrently, then I removed parallel hint in this query and it works now.

But I think I need to upgrade to 9.2.0.7.

Thanks again!

Report message to a moderator

Re: I've got the ORA-600 error, but metalink can not help me much more! [message #383207 is a reply to message #381591]

Tue, 27 January 2009 14:17

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

even better, go to 9.2.0.8.0

Rule of thumb, for Ora-600 errors, research and if needed open SR with Oracle. Since your version is not supported, upgraded to the highest possible version to see if the error stops.

[Updated on: Tue, 27 January 2009 14:20]

Report message to a moderator

Previous Topic:	Huge migration from Windows to Solaris.
Next Topic:	finding all databases at os level

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 15:43:18 CST 2024