Re: need to upgrade from 9.2.0.4 to 9.2.0.5

Maybe I wasn't clear in my first post... is going from one version to another in Oracle accomplished by loading the first patch of the next version?

In MS Windows for example, when one upgrades from version to version, there is an executable, which is independent of bug fixes, one runs to go from SP1 to SP2.

With Oracle I find no such beast. On metalink I see a table of patches and it lists the last update for 9.2.0.4 underneath the update for 9.2.0.5. So if I download 4195791, and run it, is that the same as a version upgrade to 9.2.0.5?

DA Morgan wrote:
> Adam Sandler wrote:
> > Hello,
> >
> > I hope this is an easy question. At any rate I need to upgrade from
> > 9.2.0.4 to 9.2.0.5. I'm asking becuase I've intalled patches before
> > but never changed release numbers and I don't want to screw anything
> > up. Is upgrading to 9.2.0.5 as simple as loading the first 9.2.0.5
> > patch??? I'm on metalink and looking at Doc ID: Note:161549.1 as I'm
> > writing this. Am I in the correct area to download the 9.2.0.5 patch?
> >
> > Thanks!
>
> Upgrades are trivial as long as you:
>
> 1. Run a test first on a test server
> 2. Have a good backup
> 3. Read and follow Oracle documentation on how to do it.
>
> But why 9.2.0.5? Why not 9.2.0.6?
> --
> Daniel A. Morgan
> Relational theory is not something that is simply a nice-to-have.
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)
Received on Thu May 26 2005 - 15:10:19 CDT