oracle 10g 10.2.0,升级oracle10g，从10.2.0.1.0到10.2.0.4.0

因为安装Streams的一个patch，需要将DB升级到10.2.0.4.0。

1. 安装patch，使用 p6810189_10204_Linux-x86-64.zip

2. 使用dbua，升级instance.

3. 出错如下：

DBUA thinks this is a Rerun operation and is trying to connect to the database with oracle home /u01/oracle/product/10g/db. If you believe this is not a Rerun operation,remove the below file and invoke DBUA again.

手工升级，步骤如下：

一、 设置共享内存空间

sqlplus "/as sysdba"

SQL> startup nomount;

SQL> show parameter pfile;

SQL> show parameter shared_pool_size;

SQL> show parameter java_pool_size;

SQL> show parameter sga_target;

SQL> alter system set SHARED_POOL_SIZE='512M'  scope=spfile;

SQL> alter system set JAVA_POOL_SIZE='128M'  scope=spfile;

SQL> alter system set sga_target='2048M'  scope=spfile;

SQL> shutdown

SQL> exit

二、 升级数据库实例

sqlplus "/as sysdba"

SQL> startup upgrade;

SQL> spool patch.log;

SQL> @?/rdbms/admin/catupgrd.sql;

SQL> spool off;

SQL> shutdown immediate;

SQL> exit

sqlplus "/as sysdba"

SQL> startup;

SQL> @?/rdbms/admin/utlrp.sql

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE    10.2.0.4.0      Production

TNS for Linux: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL> exit

结束。

参考了如下文档： http://qzone.qq.com/blog/21751098-1219454272