Oracle 10g 32-bit upgrade 64-bit

After reading the upgrade documents provided by Oracle, the upgrade failed several times according to the method described above. After more experiments, the upgrade is successful. Now I will share the upgrade process with you.

1. Install Oracle 10 Gb to a 64-bit system. Do not create a database.

2. Shut down the original 32-bit dB and copy all data files to the 64-bit system.

3. Copy the 32-bit initialization file to the correct location of the 64-bit system.

4. Create a new instance with oradim (initialize the parameter file with copy)

5. Modify the initialization file and add the _ system_trig_enabled = false parameter.

6. Shutdown 64-bit Database

7. stratup nomount

8. Create control file (for example, You need to modify it according to your database)

Create controlfile reuse Database "T1" noresetlogs noarchivelog
Maxlogfiles 32
Maxlogmembers 2
Maxdatafiles 32
Maxinstances 16
# Maxloghistory 1815
Logfile
Group 1 'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl64 \ redo03.log 'size 1 m,
Group 2 'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl64 \ redo02.log 'size 1 m,
Group 3 'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl64 \ redo01.log' size 1 m
Datafile
'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl64 \ system01.dbf ',
'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl64 \ rbs01.dbf ',
'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl64 \ users01.dbf ',
'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl64 \ temp01.dbf ',
'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl64 \ tools01.dbf ',
'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl64 \ indx01.dbf ',
'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl64 \ dr01.dbf'
9. Shutdown immediate

10. startup upgrade

11. Spool catoutw. Log

12. Set echo on;

13. SQL> @ C: \ oracle \ product \ 10.2.0 \ Db_1 \ RDBMS \ admin \ utlirp. SQL;

14. spool off;

15. Shutdown immediate

16. Set echo off;

17. startup

18. SQL> @ C: \ oracle \ product \ 10.2.0 \ Db_1 \ RDBMS \ admin \ utlrp. SQL;

19. Shutdown immediate

20. Modify the initialization parameter file again and delete the parameter _ system_trig_enabled = false.

21. startup

Upgrade complete