[Oracle-l] How to change to new ORACLE_HOME while upgrading to 9.2.0.6 ?

You mean 9206, right?

Yes, it works.

I always follow the steps in the patchset readme file anyway...

Cheers
Dimitre

Original Message -----
From: "Prem"
To: "oracle-l"
Sent: Thursday, July 14, 2005 12:44 PM
Subject: How to change to new ORACLE_HOME while upgrading to 9.2.0.6 ?

Dimitre,

I have to install 9201 and then upgrade it to 9206.
i cannot straightaway install 9206 .... isn't it ?
Hope you got me !
can you tell me does it work ?

Regards,
Prem.

Hi,
You have to install 9201, and then upgrade it to 9206.
But to shorten the downtime, you can pre-install such a copy on
another host, make a tar file, copy it to the target box and relink
it. all these can be done without affect existing instance.
also edit listener.ora file and copy tns.ora
Regards
Zhu Chao
www.cnoug.org

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

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
On Behalf Of zhu chao
Sent: 14 July 2005 15:02
To: premjhere_at_gmail.com
Cc: oracle-l
Subject: Re: Re[1]: How to change to new ORACLE_HOME while upgrading to
9.2.0.6 ?

Hi,
You have to install 9201, and then upgrade it to 9206.
But to shorten the downtime, you can pre-install such a copy on
another host, make a tar file, copy it to the target box and relink
it. all these can be done without affect existing instance.
also edit listener.ora file and copy tns.ora
Regards
Zhu Chao
www.cnoug.org

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.

Install 9201 binaries alone in new oracle_home (do this well ahead)
shutdown the existing instance
copy init.ora & other files in dbs directory (of old oracle_home)
to new oracle_home
change the oracle_home in oratab to new one
change the ENV variables to point to new oracle_home
startup the instance in "startup migrate" mode
run catpatch.sql & utlrp.sql
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.

No Oracle does not support the TAR method, however, it DOES work
providing you use the -p option along with the others The -p will
preserve the permissions on all files ...and you need it on the
$ORACLE_HOME/bin/oracle file or else nothing works for users other
than oracle.

tar -cvpf tarball $ORACLE_HOME

then of course use the -p on the "un"tar

tar -xvpf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
On Behalf Of Hallas, John, Tech
Dev
Sent: Thursday, July 14, 2005 10:09 AM
To: zhuchao_at_gmail.com; premjhere_at_gmail.com
Cc: oracle-l
Subject: RE: Re[1]: How to change to new ORACLE_HOME while upgrading to
9.2.0.6 ?

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

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
On Behalf Of zhu chao
Sent: 14 July 2005 15:02
To: premjhere_at_gmail.com
Cc: oracle-l
Subject: Re: Re[1]: How to change to new ORACLE_HOME while upgrading to
9.2.0.6 ?

Hi,
You have to install 9201, and then upgrade it to 9206.
But to shorten the downtime, you can pre-install such a copy on
another host, make a tar file, copy it to the target box and relink
it. all these can be done without affect existing instance.
also edit listener.ora file and copy tns.ora
Regards
Zhu Chao
www.cnoug.org

Thanks Les,
Do you have a reference to support the statement re Oracle supporting
the tar option with -p.

Not that I don't believe you of course, it would be a useful argument in
a project I am working on at the moment

Thanks

John

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

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 ?
Thanks for reminding this : )

Kind Regards,
Prem.

Hi Jo,

note 214887.1 says :
=> Install Oracle9i Enterprise Edition Release 2 (9.2.0.1) in new ORACLE_HOME
=> Install 9i Release 2 Patch Set (9.2.0.6)
.........

So this doesn't mean a direct 9.2.0.6 installation.
Hope you agree with me.

Thanks & Regards,
Prem

Jo wrote :

No, you CAN install 9.2.0.6 beforehand : see Metalink note 214887.1

mvg/regards

Jo

Prem

om> cc: zhuchao_at_gmail.com, oracle-l, Les.Hollis_at_ps.net,
Sent by: mark.strickland_at_cingular.com, cichomitiko_at_gmail.com
oracle-l-bounce_at_fr Subject: Re: Re[1]: How to change to new ORACLE_HOME while upgrading to 9.2.0.6 ?
eelists.org

07/18/2005 16:52
Please respond to
premjhere
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.

But the point is you can do it beforehand;
You do NOT have to upgrade a database to 9.2.0.1 and then upgrade again to
9.2.0.6.

You install 9.2.0.1 and then upgrade the software (not a database) to
9.2.0.6.
The migration of your database can then be done from 8.1.7 to 9.2.0.6
without going through 9.2.0.1.

mvg/regards

Jo

Prem
cc: oracle-l, "Hallas, John"

07/19/2005 12:06 Subject: Re: Re[1]: How to change to new ORACLE_HOME while upgrading to 9.2.0.6 ?
Please respond
to Prem

Hi Jo,

note 214887.1 says :
=> Install Oracle9i Enterprise Edition Release 2 (9.2.0.1) in new
ORACLE_HOME

=> Install 9i Release 2 Patch Set (9.2.0.6)
.........

So this doesn't mean a direct 9.2.0.6 installation.
Hope you agree with me.

Thanks & Regards,
Prem

Jo wrote :

Hi John / Jo,

now i understand that John, you and me have meant the same.
Perhaps i mis-understood ur previous mails OR i was not
clear in explaining things.

Thanks a lot for your replies.

Regards,
Prem.