Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 394 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
Why there are so many ORA-00600 for 10.2 releases?

55724
Member Posts: 17
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.
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
-
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." -
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 -
Thanks all for your reply
-
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 -
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.
-
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 -
ok. Thanks again
This discussion has been closed.