OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » ora-600[6002]

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

ora-600[6002] [message #226401]

Fri, 23 March 2007 09:27

amit_p_dixit
Messages: 31
Registered: November 2006
Location: Mumbai

Member

hi,

i am getting ora-600[6002] error when i am querying one particular table...

can any one help in solving the same... should i rebuild/recreate index on the table to solve this problem.

kindly help

Regards,
Amit

Report message to a moderator

Re: ora-600[6002] [message #226402 is a reply to message #226401]

Fri, 23 March 2007 09:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You should submit a Service Request as with any ORA-00600 error.
I guess that this is occuring on some DB that is older than V10.2 & most likely a known bug that has been fixed in current release.

What OS name, version & Oracle version to 4 decimal places.
What is actual SQL that generates error & what are underlying table definitions?

Report message to a moderator

Re: ora-600[6002] [message #226406 is a reply to message #226402]

Fri, 23 March 2007 09:51

amit_p_dixit
Messages: 31
Registered: November 2006
Location: Mumbai

Member

I am using

OS:- Sun Solaris
version:- 9
Oracle version:- 9.2.0.6.0
DB size:- 400 GB

We are getting this error at the time when we try to insert some rows. We have raised SR.... Oracle ppl are saying to do analyse the table. but its taking a hell of time as the table is having around 255000 rows.

kindly help.

Regards,
Amit

Report message to a moderator

Re: ora-600[6002] [message #226414 is a reply to message #226406]

Fri, 23 March 2007 10:23

orausern
Messages: 826
Registered: December 2005

Senior Member

since this is an internal error, only the Oracle support guys can help..on the oracle metalink, there are many resources related to this error..so you can try to look up these resources. I think there is something called as Ora-600 look up tool that too u can use. this things Oracle guys will do anyway but you could as well refer to these.

Report message to a moderator

Re: ora-600[6002] [message #226665 is a reply to message #226414]

Mon, 26 March 2007 02:31

amit_p_dixit
Messages: 31
Registered: November 2006
Location: Mumbai

Member

hi,

thanx 4 ur support... we have solved this problem by doing incomplete recovery. by replacing the database with the cold backup and applying the archive logs.

recover database untill time '' using backup control file;

Regards,
Amit

Report message to a moderator

Previous Topic:	export problem
Next Topic:	allocating channel for backup, help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 12:18:05 CST 2024