RE: Re[1]: How to change to new ORACLE_HOME while upgrading to 9.2.0.6 ?
- From: "Hallas, John, Tech Dev" <John.Hallas@xxxxxxxxxxxxxxxxx>
- To: "Prem" <premjhere@xxxxxxxxx>
- Date: Mon, 18 Jul 2005 14:06:42 +0100
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@xxxxxxxxx]
Sent: 18 July 2005 13:07
To: Hallas, John, Tech Dev
Cc: zhuchao@xxxxxxxxx; oracle-l; Les.Hollis@xxxxxx;
mark.strickland@xxxxxxxxxxxx; cichomitiko@xxxxxxxxx
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@xxxxxxxxxxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
