1.安装oracle 10g r2的软件
2.打oracle 10g最新的补丁，我打的是升级到10.2.0.2的补丁
3.运行Pre-Upgrade Information Tool。它用来分析升级到10g前你要做的一些操作，比如需要增加或减少的参数等。
启动要升级的DB，用SYSDBA运行10g的ORACLE_HOME/rdbms/admin下的utlu102i.sql，查看产生的日志。
SQL> SPOOL info.log
SQL> @utlu102i.sql
SQL> SPOOL OFF |
下面是我的info.log.
SQL> @d:utlu102i.sql;
Oracle Database 10.2 Upgrade Information Utility 01-17-2007 13:22:37
.
***********************************************************
Database:
***********************************************************
–> name: ZHANGYE
–> version: 9.2.0.6.0
–> compatible: 9.2.0.0.0
–> blocksize: 8192
.
***********************************************************
Logfiles: [make adjustments in the current environment]
***********************************************************
–> The existing log files are adequate. No changes are required.
.
***********************************************************
Tablespaces: [make adjustments in the current environment]
***********************************************************
–> SYSTEM tablespace is adequate for the upgrade.
…. minimum required size: 248 MB
–> TEMP tablespace is adequate for the upgrade.
…. minimum required size: 58 MB
…. AUTOEXTEND additional space required: 18 MB
.
***********************************************************
update Parameters: [update Oracle Database 10.2 init.ora or spfile]
***********************************************************
WARNING: –> “shared_pool_size” needs to be increased to at least 177861837
WARNING: –> “java_pool_size” needs to be increased to at least 67108864
WARNING: –> “streams_pool_size” is not currently defined and needs a value of
at least 50331648
WARNING: –> “session_max_open_files” needs to be increased to at least 20
.
***********************************************************
renamed Parameters: [update Oracle Database 10.2 init.ora or spfile]
***********************************************************
— No renamed parameters found. No changes are required.
.
***********************************************************
Obsolete/Deprecated Parameters: [update Oracle Database 10.2 init.ora or spfile]
***********************************************************
–> “hash_join_enabled”
–> “log_archive_start”
.
***********************************************************
Components: [The following database components will be upgraded or installed]
***********************************************************
–> Oracle Catalog Views [upgrade] VALID
–> Oracle Packages and Types [upgrade] VALID
.
***********************************************************
Miscellaneous Warnings
***********************************************************
WARNING: –> Deprecated CONNECT role granted to some user/roles.
…. CONNECT role after upgrade has only create SESSION privilege.
WARNING: –> Database contains stale optimizer statistics.
…. Refer to the 10g Upgrade Guide for instructions to update
…. statistics prior to upgrading the database.
…. Component Schemas with stale statistics:
…. SYS
.
************************************************************
SYSAUX Tablespace:
[create tablespace in the Oracle Database 10.2 environment]
************************************************************
–> New “SYSAUX” tablespace
…. minimum required size for database upgrade: 500 MB
|
PL/SQL 过程已成功完成。
copy oracle 9i的pfile(D:oracleora92databaseINITzhangye.ORA)到oracle 10g的pfile (D:oracle10gdatabaseINITzhangye.ORA)。
检查info.log，对oracle 10g的pfile修改。
我们一直都在努力坚持原创.......请不要一声不吭，就悄悄拿走。
我原创，你原创，我们的内容世界才会更加精彩！
【所有原创内容版权均属TechTarget，欢迎大家转发分享。但未经授权，严禁任何媒体（平面媒体、网络媒体、自媒体等）以及微信公众号复制、转载、摘编或以其他方式进行使用。】
微信公众号
TechTarget
官方微博
TechTarget中国
