Oracle 10.2.0.1(32 Bit) to Oracle 10.2.0.1(64 Bit)

1. Install Oracle 10.2.0.1.0 64bit, on Windows 2003 64bit (either AMD64 or EM64T processors).
2. The same directory structure was used for both machines.
NOTE: If a different directory structure will be used, then you will need to recreate the controlfiles, before starting the migration process.

Alter database backup controlfiles to trace;

3. Copy the Database files from the 32bit machine, to the 64bit machine.
(Datafiles, Logfiles, Controlfiles, init.ora, tnsnames.ora, listener.ora, etc...)

4. Create the Oracle service on the 64bit system, using the ORADIM command.

(Eg, oradim –new –sid orcl –startmode auto –pfile

6.Run Sqlplus

sqlplus '/as sysdba'

SQL> startup upgrade

SQL>@$Oracle_Home\rdbms\admin\utlip.sql

SQL>@$Oracle_Home\rdbms\admin\utlrp.sql

SQL> shut immediate

SQL>startup

SQL>select name,platform_name,open_mode from v$database;