题记windowsXP下oracle9.2.0.6到oracle10.2.0升级（二）

以下是在执行目录D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN下的SQL脚本utlu102i.sql的显示结果：

SQL> @ D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlu102i.sql
Oracle Database 10.2 Upgrade Information Utility    01-12-2008 11:17:59
.
**********************************************************************
Database:
**********************************************************************
--> name:       ORA
--> version:    9.2.0.6.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: 567 MB
.... AUTOEXTEND additional space required: 167 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: 10 MB
--> DRSYS tablespace is adequate for the upgrade.
.... minimum required size: 27 MB
.... AUTOEXTEND additional space required: 7 MB
--> EXAMPLE tablespace is adequate for the upgrade.
.... minimum required size: 150 MB
.... AUTOEXTEND additional space required: 1 MB
--> ODM tablespace is adequate for the upgrade.
.... minimum required size: 9 MB
--> XDB tablespace is adequate for the upgrade.
.... minimum required size: 41 MB
.... AUTOEXTEND additional space required: 3 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
.
**********************************************************************
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]  VALID
--> 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.6.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 过程已成功完成。

 

 

从这个脚本的分析结果可以看出，目前数据库版本已经是ORACLE9.2.0.6，如果要升级到ORACLE10G，那么有几个地方需要修改：

A，系统表空间该增加的要增加，该调整的要调整；

B，修改pfile或者spfile中部分参数值，删除ORACLE10G中不需要用到的参数值；

C，升级前执行脚本catpatch.sql（此SQL脚本位于D:\oracle\ora92\rdbms\admin下）；

上述所有修改可以通过ORACLE10G自带的工具Database Upgrade Assistant进行一步步提示性升级，也可以手工进行升级，在这里我采取手工升级的方式。