升级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