1、将Oracle9201升级到Oracle9208

解压缩p4547809_92080_WINNT.zip，双击setup，进行GUI升级9208.

2、关闭原9208数据库，执行一个完全冷备。

3、安装ORACLE10g10201，选择一个跟9208不同的Home，安装的时候选择不升级现有数据库，只安装软件。

4、以SYSDBA身份登陆到SQLPLUS，执行：

Sql>spool upgrade.info

Sql>@ORACLE10G_HOME/rdbms/admin/utlu102i.sql

Sql>spool off

注意屏幕的输出

SQL> @C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlu102i.sql

Oracle Database 10.2 Upgrade Information Utility 08-27-2012 13:52:39

.

**********************************************************************

Database:

**********************************************************************

--> name: ORA9I

--> 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: 170 MB

--> TEMP tablespace is adequate for the upgrade.

.... minimum required size: 58 MB

.... AUTOEXTEND additional space required: 18 MB

--> CWMLITE tablespace is adequate for the upgrade.

.... minimum required size: 1 MB

--> DRSYS tablespace is adequate for the upgrade.

.... minimum required size: 17 MB

--> EXAMPLE tablespace is adequate for the upgrade.

.... minimum required size: 2 MB

--> ODM tablespace is adequate for the upgrade.

.... minimum required size: 0 MB

--> XDB tablespace is adequate for the upgrade.

.... minimum required size: 3 MB

.

**********************************************************************

Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]

**********************************************************************

WARNING: --> "shared_pool_size" needs to be increased to at least 187928166

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

.

**********************************************************************

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"

.

**********************************************************************

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 Data Mining [upgrade] LOADED

--> OLAP Analytic Workspace [upgrade] LOADED

--> OLAP Catalog [upgrade] INVALID

--> Oracle OLAP API [upgrade] LOADED

--> Oracle interMedia [upgrade] LOADED

...The 'Oracle interMedia Image Accelerator' is

...required to be installed from the 10g Companion CD.

--> Spatial [upgrade] LOADED

--> Oracle Ultra Search [upgrade] VALID

... To successfully upgrade Ultra Search, install it from

... the 10g Companion CD.

.

**********************************************************************

Miscellaneous Warnings

**********************************************************************

WARNING: --> The database has not been patched to release 9.2.0.8.0.

... Run catpatch.sql prior to upgrading.

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

.... CTXSYS

.... XDB

.... WMSYS

.... ODM

.... OLAPSYS

.... ORDSYS

.... MDSYS

.... WKSYS

.

**********************************************************************

SYSAUX Tablespace:

[Create tablespace in the Oracle Database 10.2 environment]

**********************************************************************

--> New "SYSAUX" tablespace

.... minimum required size for database upgrade: 500 MB

.

PL/SQL 过程已成功完成。

SQL> spool off;

4、在Tablespace栏提示有些表空间需要额外的空间：

.... AUTOEXTEND additional space required: 18 MB

查询原原数据库的空间大小和剩余空间。

Sql>select tablespace_name,bytes/1024/1024 MB from dba_data_files;

Sql>select tablespace_name,bytes/1024/1024 MB from dba_temp_files;

Sql>select tablespace_name,sum(bytes) from dba_free_space group by tablespace_name;

扩展提示需增加空间的表空间。

5、拷贝9iHOME/database的initsid.ora文件到10gHome/database目录下。

如果没有

根据upgrade.info的提示，修改10GHome/database/initSid.ora参数文件。

6、拷贝9i的密码文件pwdsid.ora到10gHome/database目录下。

7、拷贝9iHome/network/admin下的tnsname.ora、listerna.ora、sqlnet.ora到10GHome/networkadmin目录。

8、关闭9I数据库

9、在命令行用oradim –delete –sid sid删除WINDOWS服务下的实例。

10、在命令行用oradim –new –sid sid –pfile ’path’建立新的实例。

11、停止原9i的listerner服务

12、用sysdba的身份登陆到sqlplus，以upgrade的方式启动数据库。

Startup upgrade

『启动时提示LRM-00116: ‘D:ORACLELOGSDB后跟’=’出现语法错误
ORA-01078：处理系统参数失败
根据提示，修改10GHome/database/initsid.ora,将utl_file_dir=draclelogs
注释掉。重新执行sql>startup upgrade成功。』