Re: Moving from 32-bit to 64-bit Oracle 8.1.7 on Sun

From: NorwoodThree <norwoodthree_at_my-deja.com>
Date: 21 May 2003 08:57:31 -0700
Message-ID: <ba03e2c.0305210757.788c37ab@posting.google.com>

No! Not import export! Here is the offical doc from Oracle. There is nothing that mentions import export. Import export works, but what a pain in the ass.

goal: How to upgrade a database from 32 bit Oracle to 64 bit Oracle fact: Oracle Server - Enterprise Edition

fix:

Scenarios:

1. CURRENT: 8.0.X 32 bit ---> TARGET: 8.0.X 64 bit
2. CURRENT: 8.1.X 32 bit ---> TARGET: 8.1.X 64 bit
3. CURRENT: 8.0.X 64 bit ---> TARGET: 8.0.X 32 bit
4. CURRENT: 8.1.X 64 bit ---> TARGET: 8.1.X 32 bit

 Change the word size from 32 to 64 bit or 64 to 32 bit by running

     $ORACLE_HOME/rdbms/admin/utlirp.sql
     as described in <<Note:62290.1>>

(and $ORACLE_HOME/rdbms/doc/READMEMIG.

doc -

     note, this file may not exist in 8.1.6).

     If upgrading in addition to changing the word size 
     (eg, 8.0.5 (32 bit) --> 8.0.6 (64 bit) or 
          8.1.5 (64 bit) --> 8.1.6 (32 bit)), then run 
     utlirp.sql prior to running the first upgrade script.

This covers the cases where the CURRENT versions of Oracle is upgraded to a newer release. There may also be a word size change.

Scenarios:

1. CURRENT: 8.0.X 32 bit ---> TARGET: 8.1.X 32 bit
2. CURRENT: 8.0.X 32 bit ---> TARGET: 8.1.X 64 bit
3. CURRENT: 8.0.X 64 bit ---> TARGET: 8.1.X 64 bit
4. CURRENT: 8.0.X 64 bit ---> TARGET: 8.1.X 32 bit
5. upgrade to newer release ii. for scenarios (b) and (d), change the word size from 32 to 64 bit or 64 to 32 bit by running $ORACLE_HOME/rdbms/admin/utlirp.sql as described in <<Note:62290.1>>
   (and $ORACLE_HOME/rdbms/doc/READMEMIG.
   doc - note, this file may not exist in 8.1.6).

References:
Note:
62290.1 README: Oracle - Changing between 32-bit and 64- bit word sizes

. Received on Wed May 21 2003 - 10:57:31 CDT