Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

55724Dec 10 2008 — edited Dec 17 2008
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.

Comments

Peter Fong-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
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 14 2009
Added on Dec 10 2008
#database-upgrade
7 comments
3,946 views