Forum Stats

  • 3,757,257 Users
  • 2,251,216 Discussions
  • 7,869,781 Comments

Discussions

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

55724
55724 Member Posts: 17
edited Dec 17, 2008 3:24PM in Database Upgrade
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.

Answers

  • P F-Oracle
    P F-Oracle Member Posts: 77
    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
    Mike Dietrich-Oracle Member Posts: 217 Employee
    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
    55724 Member Posts: 17
    Thanks all for your reply
  • 669771
    669771 Member Posts: 826
    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
    55724 Member Posts: 17
    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
    669771 Member Posts: 826
    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
    55724 Member Posts: 17
    ok. Thanks again
This discussion has been closed.