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成功。』
13、 创建sysaux表空间。
Sql>create tablespace sysaux
Datafile ‘。。。。。sysaux01.dbf’ size 500m
Extent management local
Segment space management auto
Online;
15、执行@oracle10.2/rdbms/admin/catupgrd.sql;(此过程比较长,请耐心。。。可以做些其他事情,呵呵)。
16、重启数据库,执行查询所有重新编译错误
sql>shutdown immediate;
sql>startup
sql>@oracle10.2/rdbms/admin/utlrp.sql
To recompile any invalid application object
执行完毕后执行查询所有重新编译错误
Sql> select * from utl_recomp_errors;
说明没有错误。
17、启动10G的listerner服务
18、测试
升级完毕。来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26812308/viewspace-742033/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26812308/viewspace-742033/