oracle 10.2.0.4 rac 升级到oracle 10.2.0.5 rac步骤

       环境 aix 6.1 + emc cx500 +oracle 10gR2 

       oracle 10.2.0.5 for aix 版本到今天为止已经推出一周。

       今天有时间在公司做了 oracle 10.2.0.4 rac 升级到 oracle 10.2.0.5 rac 的 实验,操作步骤与oracle 10.2.0.1

升级到oracle 10.2.0.4一样,以下为oracle 10.2.0.4 rac 升级到oracle 10.2.0.5 rac 实验步骤:

1.先升级cluster到10.2.0.5

   slibclean

   运行runInstaller,选择CRS_HOME ,软件安装完成后,每个节点运行以下脚本

   cd /crs/app/oracle/product/crs_1/bin

   ./crsctl stop crs

  cd /crs/app/oracle/product/crs_1/install

  ./root102.sh

2.安装ORACLE代码到10.2.0.5

   slibclean

   运行runInstaller,选择ORACLE_HOME ,软件安装完成后,每个节点运行以下脚本

   cd  /oracle/app/oracle/product/10.2.0/clusterdb

   ./root.sh

2.升级数据库数据字典到oracle 10.2.0.5

1.    SQL> STARTUP NOMOUNT
   

2. Set the CLUSTER_DATABASE initialization parameter to FALSE:

   SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile; 
   

3. Shut down the database:

   SQL> SHUTDOWN

4. SQL> STARTUP UPGRADE
   SQL> SPOOL patch.log
   SQL> @?/rdbms/admin/catupgrd.sql
   SQL> SPOOL OFF
   

5. @?/rdbms/admin/utlrp.sql
   

6. ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile; 
   

7. SQL> SHUTDOWN IMMEDIATE
   SQL> STARTUP
   

8. srvctl start database -d db_name

9. srvctl start service -d db_name -s service_name

升级成功

我们验证下结果:

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio
NLSRTL Version 10.2.0.5.0 - Production

5 rows selected.

SQL> select comp_id,comp_name,version,status,modified from dba_registry;

COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
VERSION                        STATUS                 MODIFIED
------------------------------ ---------------------- -----------------------
OWM
Oracle Workspace Manager
10.2.0.5.0                     VALID                  10-JUN-2010 13:05:24

CATALOG
Oracle Database Catalog Views
10.2.0.5.0                     VALID                  10-JUN-2010 13:04:12

CATPROC
Oracle Database Packages and Types
10.2.0.5.0                     VALID                  10-JUN-2010 13:04:12

RAC
Oracle Real Application Clusters
10.2.0.5.0                     VALID                  10-JUN-2010 13:04:14

4 rows selected.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-664903/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-664903/