Home » RDBMS Server » Backup & Recovery » ora-600[6002]
ora-600[6002] [message #226401] Fri, 23 March 2007 09:27 Go to next message
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
Re: ora-600[6002] [message #226402 is a reply to message #226401] Fri, 23 March 2007 09:32 Go to previous messageGo to next message
BlackSwan
Messages: 25045
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?
Re: ora-600[6002] [message #226406 is a reply to message #226402] Fri, 23 March 2007 09:51 Go to previous messageGo to next message
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
Re: ora-600[6002] [message #226414 is a reply to message #226406] Fri, 23 March 2007 10:23 Go to previous messageGo to next message
orausern
Messages: 817
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.
Re: ora-600[6002] [message #226665 is a reply to message #226414] Mon, 26 March 2007 02:31 Go to previous message
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
Previous Topic: export problem
Next Topic: allocating channel for backup, help
Goto Forum:
  


Current Time: Wed Dec 07 18:20:42 CST 2016

Total time taken to generate the page: 0.14105 seconds