Re: Upgrading

I think you're making a mountain out of a mole hill here. Upgrading the database is easy. However, there are certain steps you need take depending on what options you have installed on the database and are using, for instance, oracle JVM loaded into the db.

Check out technet.oracle.com or metalinks, there's docs in there that give you step by step instruction on what to do for upgrading the database. At a very high level, this is what you need to do:

1. Determine the options you have installed on the OS
2. Load the new version, 8.1.7, in a different oracle home, btw, follow the IG(that's Installation Guide).
3. Determine what's used in the DB, jvm, AQ, etc....
4. Convert the database, this is simple, one script is run.
5. Upgrade the jvm and other options in the DB.

This is more or less cookbook upgrading from 8.1.6 to 8.1.7. I also suggest you do you upgrade to a test instance before doing a production one. Check out technet.

HTH
Pete's

Note-The views/information stated here are solely my own and not that of my employer.

"The Raven" <wsmc_at_flashmail.com> wrote in message news:<a7e88d$27j0$1_at_otis.netspace.net.au>...
> "damorgan" <damorgan_at_exesolutions.com> wrote in message
> news:3C9A1686.70BE21F7_at_exesolutions.com...
> > The specific steps depend on the hardware amd operating system but always
> follow
> > this basic methodology.
> >
> > 1. Put the CD into the CDROM drive.
> > 2. Find the readme file that details the installation steps.
> > 3. Follow it without exception
> >
> > I am not trying to make light of your serious question. It is just,
> truthfully,
> > the best answer possible.
>
> Thanks for the answer. You pretty well summed it up. I guess what I was
> really asking was "Is it as simple as a Microsoft upgrade is supposed to be
> (or used to be....)"?
>
> The concern was that you'd be checking version numbers and installed
> components and then reinstalling each and every Oracle one of them for the
> server and clients and then doing some sort of database conversion.
>
> The Raven
Received on Fri Mar 22 2002 - 07:57:06 CST