2. 将原来的32位DB Shutdown,将所有Data文件Copy到64位系统上

3. 将32位的初始化文件Copy到64系统正确的位置

4. 用oradim Create一新的实例(用Copy过来的初始化参数文件)

5. 修改初始化文件,增加 _SYSTEM_TRIG_ENABLED = false参数

6. Shutdown 64位Database

7. Stratup nomount

8. Create control file(例如,你的要根据你的DB修改)

CREATE CONTROLFILE REUSE DATABASE "T1" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 16
MAXLOGHISTORY 1815
LOGFILE
GROUP 1 'C:oracleproduct10.1.0oradataorcl64REDO03.LOG' SIZE 1M,
GROUP 2 'C:oracleproduct10.1.0oradataorcl64REDO02.LOG' SIZE 1M,
GROUP 3 'C:oracleproduct10.1.0oradataorcl64REDO01.LOG' SIZE 1M
DATAFILE
'C:oracleproduct10.1.0oradataorcl64SYSTEM01.DBF',
'C:oracleproduct10.1.0oradataorcl64RBS01.DBF',
'C:oracleproduct10.1.0oradataorcl64USERS01.DBF',
'C:oracleproduct10.1.0oradataorcl64TEMP01.DBF',
'C:oracleproduct10.1.0oradataorcl64TOOLS01.DBF',
'C:oracleproduct10.1.0oradataorcl64INDX01.DBF',
'C:oracleproduct10.1.0oradataorcl64DR01.DBF'9. Shutdown immediate

10. Startup upgrade

11. SPOOL catoutw.log

12. SET ECHO ON;

13. SQL>@C:oracleproduct10.2.0db_1RDBMSADMINutlirp.sql;

14. SPOOL OFF;

15. Shutdown immediate

16. SET ECHO OFF;

17. Startup

18. SQL>@C:oracleproduct10.2.0db_1RDBMSADMINutlrp.sql;

19. Shutdown immediate

20.再次修改初始化参数文件,删除参数 _SYSTEM_TRIG_ENABLED = false

21.Startup

升级完成

转自http://www.cnblogs.com/kevinsun/archive/2006/09/08/499068.html