Re: Upgrade to 8.1.7 or 9i

From: Joel Garry <joel-garry_at_home.com>
Date: 6 Dec 2001 17:20:26 -0800
Message-ID: <91884734.0112061720.6c6a2aa7@posting.google.com>

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<3c0fcd82$0$29048$afc38c87_at_news.optusnet.com.au>...

Since the main criteria is stability, I have to disagree. There will be more bugs and product changes in 9i, simply because it is early on the curve. 8i has plenty of features for largeness, it's only real problem is all the java stuff... which of course is the main reason for 9, eh?

If stability is truly the main criteria, I would go to 8i and watch 9
for at least a year.  If you are on 7.3, you probably aren't even
using anything that would necessitate 9, but perhaps could use 8's

partitioning. If you want something like portal, you probably want to put it on another box anyways. Even with 8, you'll likely have plenty to do like getting rid of svrmgrl scripts and rewriting backup procedures and all your other scripts that do anything useful. You perhaps do everything with scripts? Do you want to replace all that with manual operations? Even the new init.ora is now cat-juggling.

> 9i. It's robust, has lots of nice new features, can be migrated directly to
> from 7.3.4 (despite what the Oracle documentation itself says), and in many
> crucial areas is much more scalable than 8i (I'm thinking of dedicated
> agents for external procedures, multi-threaded heterogeneous service agents,
> and so on).
>
> 8.1.7 is de-supported in 2 years' time. Might as well hitch a ride on the
> newest version of the product, other things being equal.
>
> Regards
> HJR
> --
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Thomas" <thomas.hiller_at_warema.de> wrote in message
> news:6e366956.0112060715.62df1b88_at_posting.google.com...
> > Hello,
> >
> > i have a more basic question. We currently run an very old Oracle
> > Server Version (7.3.4.1). Now we plan to migrate to a more up to date
> > version. Therefore my question is what Oracle Version to choose (8.1.7
> > or 9i). What are the advantages or disadvantages of the particular
> > versions. Let me know your experince about that.
> >
> > The main criteria is stability, the second is to improve the handling
> > of very big tables, the third the scalability - because it is
> > preditctable that the database is growing rapidly in the future
> >
> > What would you advice me ?
> >
> > Regards
> > Thomas

--
Contrarian, as usual.
http://www.garry.to

Received on Thu Dec 06 2001 - 19:20:26 CST