Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to change to new ORACLE_HOME while upgrading to 9.2.0.6 ?

How to change to new ORACLE_HOME while upgrading to 9.2.0.6 ?

From: Prem <premjhere_at_gmail.com>
Date: Thu, 14 Jul 2005 16:14:06 +0530
Message-ID: <56d3d56105071403441a826726@mail.gmail.com>


Hi All,

I have to upgrade an instance from 9.2.0.1 to 9.2.0.6. Existing ORACLE_HOME is /u01/oracle/product/9201/

Now i want a new oracle_home for 9206 binaries. say new ORACLE_HOME = /u01/oracle/product/9206/

I am not very much sure about how to do it and one of my peer suggested to :

  1. Install 9201 binaries alone in new oracle_home
  2. shutdown the existing instance
  3. copy init.ora & other files in dbs directory (of existing 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

Is this the right procedure ?
Hope someone has already done such work ! Suggestions are welcome.

Regards,
Prem

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 14 2005 - 05:46:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US