Install Oracle Database 19c for 64-bit Windows.

Create the new Oracle Database 19c service at the command prompt:

C:\> ORADIM -NEW -SID SID [-INTPWD PASSWORD ] -MAXUSERS USERS 
-STARTMODE AUTO -PFILE ORACLE_HOME\DATABASE\INITSID.ORA

The following table provides more information about the values you must supply.

Copy the 32-bit data files to the new 64-bit Oracle home.

Copy the 32-bit configuration files to the 64-bit Oracle home.

1. If your 32-bit initialization parameter file has an IFILE (include file) entry, then copy the file specified by the IFILE entry to the 64-bit Oracle home and edit the IFILE entry in the initialization parameter file to point to its new location.

2. If you have a password file that resides in the 32-bit Oracle home, then copy the password file to the 64-bit Oracle home. The default 32-bit password file is located in ORACLE_HOME\database\pwdSID.ora, where SID is your Oracle instance ID.

If 19c Oracle home uses a Windows User Account as the Oracle Home User, then add this Oracle Home User to the list of users and grant file permissions or directory permissions for all the database files, init.ora files, oracle password files and so on.

Add the _SYSTEM_TRIG_ENABLED = false parameter to the ORACLE_HOME\database\ORACLE_SID \init.ora file in the 64-bit Oracle home before changing the word size.

Remove this parameter from the initialization file after the word size change is complete.

Go to the 64-bit ORACLE_HOME\rdbms\admin directory from the command prompt.

Start SQL*Plus:

C:\> sqlplus /NOLOG 

Connect to the database instance as SYSDBA:

SQL> CONNECT / AS SYSDBA;

Re-create the 64-bit control files using the CREATE CONTROLFILE command. This creates the new control file in the ORACLE_HOME\database directory.

Here is an example of a database named orcl32 on a 32-bit computer migrating to orcl64 on a 64-bit computer:

CREATE CONTROLFILE REUSE DATABASE "T1" NORESETLOGS NOARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 32
    MAXINSTANCES 16
    MAXLOGHISTORY 1815
LOGFILE
    GROUP 1 'C:\app\username\oradata\orcl64\REDO03.LOG'  SIZE 1M, 
    # was   'C:\app\username\oradata\orcl32\...LOG' 
    # on the 32-bit computer
    GROUP 2 'C:\app\username\oradata\orcl64\REDO02.LOG'  SIZE 1M,
    GROUP 3 'C:\app\username\oradata\orcl64\REDO01.LOG'  SIZE 1M
DATAFILE
   'C:\app\username\oradata\orcl64\SYSTEM01.DBF',
    # was 'C:\app\username\oradata\orcl32\...DBF' 
    # on the 32-bit computer
   'C:\app\username\oradata\orcl64\RBS01.DBF',
   'C:\app\username\oradata\orcl64\USERS01.DBF',
   'C:\app\username\oradata\orcl64\TEMP01.DBF',
   'C:\app\username\oradata\orcl64\TOOLS01.DBF',
   'C:\app\username\oradata\orcl64\INDX01.DBF',
   'C:\app\username\oradata\orcl64\DR01.DBF'
CHARACTER SET AL32UTF8;

Alter the init file from the 32-bit computer to include the new control file generated in the preceding step.

Shut down the database on the 64-bit computer:

SQL> SHUTDOWN IMMEDIATE;

Start the database migration:

SQL> STARTUP MIGRATE;

Migrate the database.

Shut down the database:

SQL> SHUTDOWN IMMEDIATE;

Restart the database:

SQL> STARTUP OPEN;