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)
I've got the ORA-600 error, but metalink can not help me much more! [message #381591] Sun, 18 January 2009 21:37 Go to next message
trantuananh24hg
Messages: 668
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!
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 Go to previous messageGo to next message
BlackSwan
Messages: 25048
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.
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 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
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!
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 Go to previous messageGo to next message
BlackSwan
Messages: 25048
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!
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 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
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!
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 Go to previous message
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:
  


Current Time: Fri Dec 09 09:47:23 CST 2016

Total time taken to generate the page: 0.24198 seconds