OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-00600 error (10.1.0.5.0 / Windows 2003)

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

ORA-00600 error [message #282950]

Sun, 25 November 2007 08:39

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

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: ORA-00600 error [message #282952 is a reply to message #282951]

Sun, 25 November 2007 09:01

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

varu123
Messages: 754
Registered: October 2007

Senior Member

Setting _allow_resetlog_corruption=true might ignore ora-600 error.

Report message to a moderator

Re: ORA-00600 error [message #282958 is a reply to message #282957]

Sun, 25 November 2007 09:43

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

Report message to a moderator

Re: ORA-00600 error [message #282961 is a reply to message #282958]

Sun, 25 November 2007 10:57

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: ORA-00600 error [message #283001 is a reply to message #282950]

Sun, 25 November 2007 22:27

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.

Report message to a moderator

Re: ORA-00600 error [message #283365 is a reply to message #282950]

Mon, 26 November 2007 23:14

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.

Report message to a moderator

Re: ORA-00600 error [message #283419 is a reply to message #283365]

Tue, 27 November 2007 01:57

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.

Report message to a moderator

Previous Topic:	ora-01659
Next Topic:	dbms_mview

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 05:02:39 CST 2024