Re: Oracle 9.2.0.1 Patch to 9.2.0.2

Khalid Eidoo wrote:

> Thanks for your response DA. When I read the installation, the post
> installation instructions seemed odd to me, which I why I posted my
> question. The way I understood the instructions it seemed like I only need
> to upgrade databases/server instances that existed prior to the installation
> of the patchset.
>
> I watched the memory guidelines for the JVM and Large Pool, and everything
> went off without a hitch.
>
> I find it odd that server instances created after an upgrade still have to
> go through the migration process. Coming from the informix word, once a
> patchset was appied, newly created server instances did not need to be
> migrated.
>
> P.S. I'm running this server on Linux, and we are specifically going to it
> because it solves an INSO file format issue format for us.
>
> Thanks Again,
>
> Khalid.
>
> "DA Morgan" <damorgan_at_exxesolutions.com> wrote in message
> news:3E7A68FE.EFA9F8AA_at_exxesolutions.com...
> > Khalid Eidoo wrote:
> >
> > > I'm about to install Oracle 9.2.0.1 and the 9.2.0.2 patchset on a test
> linux
> > > server. My plan is to install 9.2.0.1, software only (and only standard
> > > edition). Afterwards, I will go ahead with the upgrade to 9.2.0.2.
> Assuming
> > > create databases (and listeners) after 9.2.0.2 has been installed, I
> assume
> > > I wont't need to perform any of the 'startup migrate' scripts
> afterwards.
> > > Can anyone confirm/refute this assumption?
> > >
> > > Thanks,
> > >
> > > Khalid.
> >
> > Why don't you just read the installation instructions?
> >
> > Of course you have to.
> >
> > But be careful about the number of zeros when you modify your init
> parameters. I
> > thought I did everything correctly and messed up that way much to my
> > embarrasement.
> >
> > Daniel Morgan
> >

The catpatch.sql is basically nothing but a rebuild of the data dictionary and related code owned by SYS and SYSTEM. If you don't do it you may find many invalid objects.

Daniel Morgan Received on Fri Mar 21 2003 - 22:29:44 CST