Re: Re[1]: How to change to new ORACLE_HOME while upgrading to 9.2.0.6 ?

From: Prem <premjhere_at_gmail.com>
Date: Mon, 18 Jul 2005 20:22:04 +0530
Message-ID: <56d3d5610507180752714cdee7@mail.gmail.com>

On 7/18/05, Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk> wrote:
> Prem,
> You need to install the 9.2.0.6 binaries as well. That should be step
> 1a) Upgrade 9.2.0.1 binaries to 9.2.06. This can be done beforehand

John ... i have to install 9iR2 first . i.e., 9.2.0.1 and then upgrade it to 9.2.0.6 . Is there a direct installation of 9.2.0.6 ??!! (i dont think so) . So only 9201 can be installed beforehand.

Moreover , 9206 can have some new/changed v$ views. In that case, i have to startup the OLD 9201 database from NEW 9206 oracle_home . i mean using the NEW 9206 binaries and environment . Then run catpatch/utlrp SQLs.

Hope i am clear. Do you agree with me John ?

> The rest of the steps seem to be OK.
>
> I had forgotten about the startup migrate (although I would have
> remembered when I read the readme files)
>
> Make sure you change your listener.ora and tnsnames.ora files to show
> the new Oracle HOME

Thanks for reminding this : )

Kind Regards,
Prem.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 18 2005 - 09:54:41 CDT