Why there are so many ORA-00600 for 10.2 releases?

55724

Have 10.1.0.4 production and testing databases on HP Itanium. Planning to upgrade to 10.2.0.4
However checked entries on Metalink, I found that 10.2.0.3 has a lot of bugs that would cause ORA-00600, some of them would hung or crush the database. 10.2.0.4 is not much better; it introduced new ORA-00600 bugs. Such as this bug 7014646-- ORA-00600 [kkocxj : pjpCtx] error on a complex query. How do you define a complex query? Is this ridiculous or not?

Have anyone upgraded to 10.2.0.3 or 10.2.0.4 releases? What is like to get ORA-00600 all the time?
Maybe I should go to 11g instead? By the way, is there a date that 10.2.0.5 would be released for HP Itanium?

Any response would be appreciated.

P F-Oracle

All software will have bugs, it's normal that a piece of software that is complicated as Oracle will have some bugs. It does not matter what version you go to. What does matter is whether or not the bugs that are there will affect you in the way your application uses the software. And testing thoroughly is the best way to mitigate the risk of hitting one unexpectedly.

And yes... even SQL Server service packs fix lots of bugs => http://support.microsoft.com/?kbid=921896
And some of these are not documented as their note says
" * Other fixes that are not documented may be included in the service pack."
" * This list will be updated when more articles are released."

Mike Dietrich-Oracle

Hi there,

all software has bugs. The bug you are refering to (bug7014646 : A complex query can fail during parse with ORA-600 [kkocxj : pjpCtx]) has a valid workaround:
set "_optimizer_push_pred_cost_based"=false
AND:
There's a fix available - so I really don't see your point. You might either use the workaround or apply the patch on top of 10.2.0.4.

10.2.0.4 has more than 2000 bug fixes included. You may check Note:555579.1 for (in your environment!!!) necessary fixes on top of 10.2.0.4.

Kind regards
Mike

55724

Thanks all for your reply

669771

Hi,

I upgraded our db from 9208 to 10204 and everything was ok. Last month i upgraded to 11107 and again without any ORa-600.

I think it depends on the system.
My opinium is to use higher version than if you can go to 11g

Regards,
Tom
http://oracledba.cz

55724

Thank you Tom for your input. Can you let know what OS do you have? We have a Windows 2003 server installed with 10.2.0.4 without any problem. Just worry about the HP Itanium box.

669771

Hi,

We have SuSE 10 on 32b or 64b Intel on all server.
We doesn't like win as server OS.

Regards,
Tom
http://oracledba.cz

55724

ok. Thanks again