Re: Is this serious?

Hi All,

Moving from a significant digit release to another significant digit release (eg. 7 => 8, 8 => 9) is a "migration" and requires among other things and options the running of the migration utility and the recreation of the control files via the CONVERT command.

Whereas the moving of a point release to another point release (eg. 8.1.5 => 8.1.7, 9.0.1 => 9.2) is an "upgrade" and only requires the running of the appropriate "upgrade" script to update the data dictionary and to then update the data dictionary views.

In answer the original posters question of whether the problem is serious, you can't do many laps in a 6M shared pool and it's a bit like Ian Thorpe trying to practice in a spa bath whist having a toe stuck in a tap. It's not really serious but it is a tad difficult ;)

Cheers

Richard
"Peter van Rijn" <p.vanrijn-rmthis_at_zhew.nl> wrote in message news:unbm6kcpmrcu72_at_corp.supernews.com...
> Vladimir,
>
> You can disagree as much as you like, but acoording to Oracle's own
> definitions 8.1.7 *is* a maintenance release (chapter 1 Migration Guide
 rel.
> 8.1.7).
>
> All Sybrand wanted to say (I suppose) is that *because* it's a maintenance
> release upgrading is quite easy. It is *not* a migration as it would have
> been if you come from for example rel 7.x.
>
> regards,
> Peter
>
>
> "Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> schreef in bericht
> news:al4hc5$qo9$1_at_babylon.agtel.net...
> > "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> > news:c3eanucg76e2ik9hfu4m6phqojupqio48k_at_4ax.com...
> > > If your database is not badly fragmented there is no need to create a
> > > new database, as 8.1.7 is a maintenance release, you can install it
> > > safely (provided you do make backups) over 8.1.5
> >
> > Well, I totally disagree that 8i Release 3 is 'maintenance' release. It
> > introduced quite a few new features compared to Release 1 and even
> > Release 2 - just check "what's new" sections in 8.1.7 docs. :)
> >
> > You need to excercise upgrade with caution, strictly follow migration
> > docs and notes and make yourself familiar with all 8.1.5 to 8.1.7
> > migration issues and workarounds published on MetaLink. And
> > of course, have a full cold backup of the database and copy of original
> > $ORACLE_HOME handy in case something goes wrong, so that you
> > can easily revert to previous state. MetaLink note 133920.1 has a
> > complete checklist for manual upgrades, recommended reading if you
> > want to upgrade manually.
> >
> > And you cannot install 8.1.7 over 8.1.5 into the same home without
> > deinstalling 8.1.5 first - OUI won't let you. Either install into new
 home
> > (and then you can skip copying original Oracle home) or deinstall 8.1.5
> > and then install 8.1.7 where previous version used to be.
> >
> > Corrections and additions welcome.
> >
> > --
> > Vladimir Zakharychev (bob_at_dpsp-yes.com)
 http://www.dpsp-yes.com
> > Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
 applications.
> > All opinions are mine and do not necessarily go in line with those of my
 employer.
> >
>
>
Received on Wed Sep 04 2002 - 06:01:32 CDT