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

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

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

Good luck

John

-----Original Message-----
From: Prem [mailto:premjhere_at_gmail.com] Sent: 18 July 2005 13:07
To: Hallas, John, Tech Dev
Cc: zhuchao_at_gmail.com; oracle-l; Les.Hollis_at_ps.net; mark.strickland_at_cingular.com; cichomitiko_at_gmail.com Subject: Re: Re[1]: How to change to new ORACLE_HOME while upgrading to 9.2.0.6 ?

Hi John,

Thanks for your reply . As you said , ONLY step 1 can be done well ahead.
But step 2 - 5 is part of the upgrade phase. i need to start the instance
from this new oracle_home and then run catpatch/utlrp to get it upgraded to 9.2.0.6.

1. Install 9201 binaries alone in new oracle_home (do this well ahead)
2. shutdown the existing instance
3. copy init.ora & other files in dbs directory (of old oracle_home) to new oracle_home
4. change the oracle_home in oratab to new one
5. change the ENV variables to point to new oracle_home
6. startup the instance in "startup migrate" mode
7. run catpatch.sql & utlrp.sql
8. shutdown/start

I can proceed as mentioned above in my original mail. Am i right ? Please correct me if i'm wrong.

Many thanks to Les,Mark,Zhu,Dimitre for your inputs.

Regards,
Prem.

On 7/14/05, Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk> wrote:
> Oracle did not used to support that method of installing Oracle. There
> may also be issues with the Inventory.
>
> Why not just create a $ORACLE_BASE/product/9.2.0.6 directory. Install
> 9.2.0.1 into there and then upgrade it to 9.2.0.6. That can all be
done
> well before the day o fthe migration.
>
> John

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