Re: 10g or 9.2?

Tim Smith wrote:
> Hi,
> Our small business uses 8.0.5 Standard Edition for 20-60 user
> applications. Lots of stored procedures, Powerbuilder 6.5, MS .Net
> 1.1. We would like to upgrade to a new version and are deciding
> between 9i or 10g.
> If we go with 10g then we are offered RAC free with Standard
> Edition otherwise we must upgrade to Enterprise Edition in 9.2. That
> appears to be the main benefit of 10.2
>
> 10.2 is 2 months out of beta and 9.2 will be supported until (very
> rough sales estimate 2009).
>
> Some developers wish to go to 10g so they dont need to upgrade
> again for a while. One DBA thinks 10g is too new. One DBA thinks RAC
> is easy. I recall Oracle Parallel Server was a bear and I am not sure
> what benefits RAC will give us with our small 2 node dual CPU server
> which already has interfaces/webapplications on the non-Oracle node.
>
> If it takes 9 months to migrate, 10g will be out for 11 months. Are
> they are reasons not to go directly to 10g?
>
> Tim

Considering the fact that 9i R1 is already desupported (not going into finer details since with 60 users you probably won't have EMS ), while 8.1.7 is still supported on most platforms until the end of this year, I think in the long run you're better off with 9iR2 and then in one or two years time start considering 10g R2 or what ever it will be called.

But for development, there's nothing that would stop me from using 10g, although some of your development tools might need to be upgraded.

My 2c

Holger Received on Sat May 08 2004 - 04:58:35 CDT