Thanks for the info Dick. I also found an article on metalink 62290.1 (changing between 32-bit and 64-bit word sizes).
Murali. |---------+-------------------------------> | | <[EMAIL PROTECTED]| | | tate.fl.us> | | | Sent by: | | | [EMAIL PROTECTED]| | | m | | | | | | | | | 11/14/2003 09:34 AM | | | Please respond to | | | ORACLE-L | | | | |---------+-------------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> | | 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:[EMAIL PROTECTED] 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? - Hmmm, create database , export, import. -----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/[EMAIL PROTECTED] 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/[EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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/[EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).