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