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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Migration utility to convert 32 bit DB to 64 bit?

RE: Migration utility to convert 32 bit DB to 64 bit?

From: <Murali_Pavuloori/Claritas_at_claritas.com>
Date: Fri, 14 Nov 2003 06:59:45 -0800
Message-ID: <F001.005D6AD8.20031114065945@fatcity.com>

Thanks for the info Dick. I also found an article on metalink 62290.1
(changing between 32-bit and 64-bit word sizes).

Murali.

|---------+------------------------------->
|         |           <Paula_Stankus_at_doh.s|
|         |           tate.fl.us>         |
|         |           Sent by:            |
|         |           ml-errors_at_fatcity.co|
|         |           m                   |
|         |                               |
|         |                               |
|         |           11/14/2003 09:34 AM |
|         |           Please respond to   |
|         |           ORACLE-L            |
|         |                               |
|---------+------------------------------->
  >--------------------------------------------------------------------------------------------------------------|
  |                                                                                                              |
  |       To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                                  |
  |       cc:                                                                                                    |
  |       Subject:  RE: Migration utility to convert 32 bit DB to 64 bit?                                        |
  >--------------------------------------------------------------------------------------------------------------|




Thanks Dick. It is worth a try.

-----Original Message-----
Sent: Thursday, November 13, 2003 6:35 PM To: Multiple recipients of list ORACLE-L

To the best of my knowledge, & I've done this several times now, you run the appropriate upgrade script then the utlirp.sql script to migrate from 32 to 64 bit. Now you must have the 64 bit executables installed or it creates some interesting results. But you don't have to rebuild the database. UNLESS your changing os platforms like Sun to WinDoze.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
[mailto:Paula_Stankus_at_doh.state.fl.us]
Sent: Thursday, November 13, 2003 3:29 PM To: Multiple recipients of list ORACLE-L

So - this is a stupid question:

We cannot use Oracle's migration utility to go from 32-bit 8.1.7 to 64-bit 9i?

-----Original Message-----
Sent: Thursday, November 13, 2003 2:49 PM To: Multiple recipients of list ORACLE-L

It's actually an sql script that's located in the $ORACLEHOME/rdbms/admin directory called utlirp.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
[mailto:Murali_Pavuloori/Claritas_at_claritas.com] Sent: Thursday, November 13, 2003 10:39 AM To: Multiple recipients of list ORACLE-L

hello,

We currently have oracle (32 bit) 9.2.0.3 db running on Win 2000. We got new itanium machines running Win 2003 (64 bit). We want to move the db running on 32 bit win 2000 server to Wiin 2003 (64 bit) server.

Someone suggested that (after installing the 64 bit oracle software) we copy the datafiles over and run a migration utility to convert the 32 bit db to 64 bit. I personally have never heard of such utility. Could you please share your experiences. How reliable is this utility and where to find the docs on this....

Thanks,
Murali.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
  INET: Murali_Pavuloori/Claritas_at_claritas.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: DGoulet_at_vicr.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <Paula_Stankus_at_doh.state.fl.us INET: Paula_Stankus_at_doh.state.fl.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: DGoulet_at_vicr.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <Paula_Stankus_at_doh.state.fl.us INET: Paula_Stankus_at_doh.state.fl.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/Claritas_at_claritas.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Nov 14 2003 - 08:59:45 CST

Original text of this message

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