Oracle 9206升级到10.2.0.2简要步骤

核心提示： *.aq_tm_processes=1*.background_dump_dest='D:oracleadminzhangyedump'*.compatible='9.2.0.0.0'*.control_files='D:oracleoradata

*.aq_tm_processes=1
*.background_dump_dest='D:oracleadminzhangyedump'
*.compatible='9.2.0.0.0'
*.control_files='D:oracleoradatazhangyecontrol01.ctl',
'D:oracleoradatazhangyecontrol02.ctl',
'D:oracleoradatazhangyecontrol03.ctl'
*.core_dump_dest='D:oracleadminzhangyecdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='zhangye'
*.fast_start_mttr_target=300
#*.hash_join_enabled=TRUE
*.instance_name='zhangye'
*.java_pool_size=67108864
*.job_queue_processes=10
*.large_pool_size=8388608
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=177861837
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:oracleadminzhangyeudump'
#*.log_archive_start=true
#*.log_archive_format=%s.arc
#*.log_archive_dest=D:oraclearchive
*.streams_pool_size=50331648
*.session_max_open_files=20

4.运行Oracle Net Configuration Assistant，生成10g的listener.ora

5.rman备份DB。

6.stop所有oracle 9i的服务。

删除oracle 9i的服务。

C:> ORADIM -DELETE -SID ZHANGYE

新建oracle 10g的服务

C:> ORADIM -NEW -SID ZHANGYE -MAXUSERS 10 -STARTMODE AUTO
-PFILE D:oracle10gdatabaseINITzhangye.ORA

7.UPGRADE选项启动DB.

SQL> STARTUP UPGRADE

8.创建SYSAUX表空间

CREATE TABLESPACE sysaux DATAFILE 'D:oracleoradatazhangyesysaux01.dbf'
SIZE 500M REUSE
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
ONLINE;

9.运行10g的ORACLE_HOME/rdbms/admin/catupgrd.sql，然后运行utlu102s.sql查看升级结果。

SQL> SPOOL upgrade.log
SQL> @catupgrd.sql
SQL> @utlu102s.sql
SQL> SPOOL OFF

检查upgrade.log，如果有错误，处理错误后再次运行catupgrd.sql。

10.重新启动DB，编译无效对象。

SQL> shutdown immediate
SQL> startup pfile=D:oracle10gdatabaseINITzhangye.ORA
SQL> @D:oracle10gRDBMSADMINutlrp.sql

编译后没有无效对象

SQL> SELECT count(*) FROM dba_objects WHERE status='INVALID';
COUNT(*)
----------
0

升级完成。