Oracle 9206升级到10.2.0.2简要步骤

核心提示： SQL> spool off;copy oracle 9i的pfile(D:oracleora92databaseINITzhangye.ORA)到oracle 10g的pfile(D:oracle10gdatabaseINITzhangye.ORA).检查info.log，对ora

SQL> spool off;

copy oracle 9i的pfile(D:oracleora92databaseINITzhangye.ORA)到oracle 10g的pfile(D:oracle10gdatabaseINITzhangye.ORA).

检查info.log，对oracle 10g的pfile修改.

--oracle 10g修改前的pfile

*.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=0
*.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=50331648
*.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

--oracle 10g修改后的pfile