基于Windows Server 2003升级Oracle9.2.0.1至Oracle10.2.0.1目录安装Oracle 9.2.0.8数据库软件 (2)检查系统参数并升级数据库至Oracle 9.2.0.8版本 (6)安装Oracle 10.2.0.1数据库软件 (9)检查系统参数并升级数据库至Oracle 10.2.0.1版本 (13)测试Oracle 10.2.0.1升级是否成功 (23)安装Oracle9.2.0.8数据库软件由于Oracle不支持从9.2.0.1直接升级至10.2.0.1，所以先将Oralce 9.2.0.1升级至中间本本9.2.0.8。

双击setup，开始安装Oracle9.2.0.8。

点击下一步：选择安装的路径，一定要与Oracle9.2.0.1的ORACLE_HOME路径一致：出现错误提示，没有将Oracle 9.2.0.1的服务关掉：进入服务中查看Oracle的服务：将Oracle的服务禁用：显示安装概要，点击下一步：开始安装：安装完成：检查系统参数并升级数据库至Oracle9.2.0.8版本1.检查system表空间可用大小：SQL>selecttablespace_name,sum(bytes)/1024/10242fromdba_free_space3 wheretablespace_name='SYSTEM'4 group by tablespace_name;2.更新system 表空间数据文件的大小：alter database datafile 'C:\oracle\oradata\orcl\SYSTEM01.DBF' resize 500M;更新完成后保证system 表空间有至少10M 的空间。

3.以sys 用户登录数据库，并启动数据库：C:\>sqlplus /NOLOGSQL> CONNECT SYS/oracle AS SYSDBA SQL> STARTUP4.查看PFILE 文件参数，查看共享池、JAVA池的大小：SQL> SHOW PARAMETER PFILE;SQL> SHOW PARAMETER SHARED_POOL_SIZE; SQL> SHOW PARAMETER JAVA_POOL_SIZE;5.更改共享池、JAVA 池的大小：SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile; SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;6.修改完成后关闭数据库：SQL> SHUTDOWN7.升级数据库：执行C:\oracle\ora92\rdbms\admin\目录下的catpatch.sql 脚本：C:\>sqlplus /NOLOG SQL> conn / as sysdba SQL> STARTUP migrate SQL> SPOOL patch.logSQL> @C:\oracle\ora92\rdbms\admin\catpatch.sql SQL> SPOOL OFF关闭数据库，并重新启动：SQL> SHUTDOWN SQL> STARTUP执行C:\oracle\ora92\rdbms\admin\目录下的utlrp.sql 脚本，重新编译错误：SQL> @C:\oracle\ora92\rdbms\admin\utlrp.sql升级至Oracle9.2.0.8成功。

安装Oracle10.2.0.1数据库软件点击oracle10.2.0.1a安装介质，点击setup进行安装，选择高级安装：选择安装企业版（652MB）：指定Oracle10.2.0.1的ORACLE_HOME目录位置，要求与Oracle9i的位置不同：进行先决条件检查：注意在此处选择否，即不使用DBUA升级现有数据库：选择仅安装数据库软件：显示数据库安装概要，点击安装：安装完成，点击退出完成安装：检查系统参数并升级数据库至Oracle10.2.0.1版本1.以sys用户登录数据库：C:\>sqlplus /NOLOGSQL> CONNECT SYS/oracle AS SYSDBA2.运行C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlu102i.sql脚本查看需要修改的系统参数：SQL> spool SQL> @C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlu102i.sql; Oracle Database 10.2 Upgrade Information Utility 08-29-2012 15:07:31.**************************************************************** ******Database:**************************************************************** ******-->name: ORCL-->version: 9.2.0.8.0-->compatible: 9.2.0.0.0.**************************************************************** ******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: 506 MB.... AUTOEXTEND additional space required: 6 MB--> TEMP tablespace is adequate for the upgrade..... minimum required size: 58 MB.... AUTOEXTEND additional space required: 17 MB--> XDB tablespace is adequate for the upgrade..... minimum required size: 47 MB.... AUTOEXTEND additional space required: 1 MB.**************************************************************** ******Update Parameters: [Update Oracle Database 10.2 init.ora or spfile] **************************************************************** ******WARNING: --> "shared_pool_size" needs to be increased to at least 188767027WARNING: --> "streams_pool_size" is not currently defined and needs a value ofat least 50331648WARNING: --> "session_max_open_files" needs to be increased to at least 20.**************************************************************** ******Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]**************************************************************** ******-- No deprecated parameters found. No changes are required..**************************************************************** ******Obsolete 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-->JServer JAVA Virtual Machine [upgrade] VALID...The 'JServer JAVA Virtual Machine' JAccelerator (NCOMP)...is required to be installed from the 10g Companion CD.--> Oracle XDK for Java [upgrade] VALID--> Oracle Java Packages [upgrade] VALID--> Oracle Text [upgrade] VALID--> Oracle XML Database [upgrade] VALID--> Oracle Workspace Manager [upgrade] VALID--> Oracle interMedia [upgrade] VALID...The 'Oracle interMedia Image Accelerator' is...required to be installed from the 10g Companion CD.--> Spatial [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.... XDB.... WMSYS.... MDSYS.**************************************************************** ******SYSAUX Tablespace:[Create tablespace in the Oracle Database 10.2 environment]**************************************************************** ******--> New "SYSAUX" tablespace.... minimum required size for database upgrade: 500 MB.PL/SQL 过程已成功完成。