Home » RDBMS Server » Server Administration » ORA-00600 error (10.1.0.5.0 / Windows 2003)
ORA-00600 error [message #282950] Sun, 25 November 2007 08:39 Go to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

One of my production database I got below error message.
Did not find more details at metalink site.

ORA-00600: internal error code, arguments: [17302], [20], [], [], [], [], [], []

[Updated on: Sun, 25 November 2007 22:52]

Report message to a moderator

Re: ORA-00600 error [message #282951 is a reply to message #282950] Sun, 25 November 2007 08:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Found atleast a dozen hits.
Exact issue depends on your oracle version,what you were doing and stack message you got.
https://metalink.oracle.com/metalink/plsql/f?p=130:10:5438650624484037238::::alltext,knowledge,numHits:17302,TRUE,100
Re: ORA-00600 error [message #282952 is a reply to message #282951] Sun, 25 November 2007 09:01 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Thank you Mahesh,
Yesterday night I gather schema statistics and parameter cursor_sharing='FORCE' that time I got ORA-00600 error message.

Exact Metalink Note:301853.1
My apologies, I checked but didn't find above note.

Regards
Mohammed

[Updated on: Sun, 25 November 2007 09:37]

Report message to a moderator

Re: ORA-00600 error [message #282957 is a reply to message #282950] Sun, 25 November 2007 09:38 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Setting _allow_resetlog_corruption=true might ignore ora-600 error.
Re: ORA-00600 error [message #282958 is a reply to message #282957] Sun, 25 November 2007 09:43 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Setting _allow_resetlog_corruption=true might ignore ora-600 error.
Why I am put me in trouble when i got easily correct solution.
"Hidden" parameter is used only by oracle supported.

above ORA-00600 is bug. and bug fixed through latest patchset.

Neverever set Hidden parameter it is danger.

Regards
Mohammed
Re: ORA-00600 error [message #282961 is a reply to message #282958] Sun, 25 November 2007 10:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> My apologies, I checked but didn't find above note.
Not sure where you are checking.
I was able to retrieve the said metalink note.
https://metalink.oracle.com/metalink/plsql/f?p=130:3:750897918272756766::::p3_database_id,p3_docid,p3_show_header,p3_show_help,p3_bla ck_frame,p3_font:NOT,301853.1,1,1,1,helvetica
Re: ORA-00600 error [message #283001 is a reply to message #282950] Sun, 25 November 2007 22:27 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Taj, if there any associate message? Your oracle version. Let me check in metalink.
Re: ORA-00600 error [message #283365 is a reply to message #282950] Mon, 26 November 2007 23:14 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

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

Mohammad, Have you tried with this lookup.
Re: ORA-00600 error [message #283419 is a reply to message #283365] Tue, 27 November 2007 01:57 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Thank you Arjn & Mahesh.

I got suggested Metalink Note. Smile
Problem is solved.
Previous Topic: ora-01659
Next Topic: dbms_mview
Goto Forum:
  


Current Time: Fri Apr 19 17:33:38 CDT 2024