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.

10g R2 - when to make the jump?

rpapajMar 22 2006 — edited Mar 23 2006
Considering the current desupport date for the 9iR2 db server software of June 30, 2007, what's your feedback on jumping from 9iR2 to 10gR2 this summer of 2006? Is it too soon? Is 10gR2 stable/reliable enough at this point for mission-critical production systems in your opinion? Does 10gR2 provide enough added functionality, such as the security features, to merit a summer 2006 upgrade rather than waiting for a timeframe closer to the 9iR2 desupport date? And when upgrading to 10gR2, any gotchas to look out for that you may have encountered? I realize we will have to work through any compatibility issues between 3rd party vendor software & 10gR2; that may be one thing that potentially forces a timeline for upgrades for some of our databases.

Thanks in advance for any feedback on any of the above.

-Rick Papaj
papaj@buffalo.edu

Comments

181444
We are also thinking about making the same move (9.2.0.6 to 10R2) sometime this year. We use a few obsolete Oracle products that are certified with 10gR1 but not with R2, but we figure if the application works in test we will go to R2 instead of R1.

HTH -- Mark D Powell --
rodneyli
I would recommend going to R2. There are some bugs within R1 that are resolved only in R2. e.g. Datapump issues in R1 are quite common with huge stats. I would wait for the application to be certified though. No point going uncertified:P
181444
Some of the products we use will never be certified with R2. Oracle does not certify obsolete products like Forms 6i anymore. We would love for Oracle to go ahead an certify everything that in fact should work with R2 that is still out in the market being used. I just do not think it will happen.

-- Mark D Powell --
340688
We moved our major Production system over to 10gR2 (10.2.0.1) a few weeks ago. Of course, 10.2.0.2 came out right before we upgraded, so we had no chance to put it through regression testing, but it sure would have been nice.

It is hard to say if we "made the jump" too soon or not. As with anything else, there are pros and cons to consider. One of the biggest problems we have come up against so far is that Oracle Support is not fully versed in 10g, yet. We filed a Sev 1 SR and were assigned analysts who were complaining about all the new features in 10g that they did not know (good thing one our DBAs speaks Hindi). The new version is a very mixed bag - there are some really cool new features, but with the sad state of software development currently, there are a ton of bugs. Just take a look at all the bug fixes in 10.2.0.2 - and that is the known bugs. Another area that is tricky are staticistics, since Oracle is attempting to phaze out the RBO. I have found that there is not much written about new features (understandbly), so you have to dig for them, or attempt to comprehend the documentation.

In my opinion, if you are stable on 9i, I would wait to upgrade until you need (or really want) a new feature. I realize that sticking with 9i means you will probably have to apply many many patches (when is 9208 coming out?), but the core functionality does not change as much as when you jump to 10g. In the meantime, get up a few 10g databases and practice a lot with it. grin
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 20 2006
Added on Mar 22 2006
#general-database-discussions
4 comments
385 views