升级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.zip2. 使用dbua,升级instance.3. 出错如下:DBUA thinks this is a Rerun operation and is trying to connect to the database
因为安装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
结束。
更多推荐
所有评论(0)