Dbabc.Net

Oracle rac 10.2.0.1升级10.2.0.4 具体请参考安装包解压后的readme.html，简单总结如下：
需要软件包p6810189_10204_Linux-x86-64.zip
1、升级CRS
1.1、停止服务
$srvctl stop service -d serv_name
执行此命令之后以下服务
ora….serv.cs application OFFLINE OFFLINE
ora….ct1.srv application OFFLINE OFFLINE
ora….ct2.srv application OFFLINE OFFLINE
关闭数据库
$srvctl stop database -d db_name
此命令关闭以下服务
ora….data.db application OFFLINE OFFLINE
ora….t1.inst application OFFLINE OFFLINE
ora….t2.inst application OFFLINE OFFLINE
关闭监听
$srvctl stop listener -n ract01
ora….01.lsnr application OFFLINE OFFLINE
$srvctl stop listener -n ract02
ora….02.lsnr application OFFLINE OFFLINE
关闭以上服务，只保留crs相关的6组服务（每个节点三组(gsd、ons和vip)）
1.2、升级CRS
解压p6810189_10204_Linux-x86-64.zip unzip
进入解压目录，
./runInstaller —>『Next』—>选择crs的安装目录—>『Next』—>选择所有节点—>『Next』—>『Next』—>『Next』—>『Next』 然后按照以下提示执行命令：

To complete the installation of this patchset, you must perform the following tasks on each node:

1. Log in as the root user.
2. As the root user, perform the following tasks:

a. Shutdown the CRS daemons by issuing the following command:
/u01/product/crs/bin/crsctl stop crs
b. Run the shell script located at:
/u01/product/crs/install/root102.sh
This script will automatically start the CRS daemons on the
patched node upon completion.

3. After completing this procedure, proceed to the next node and repeat.

分别在每个节点上运行以上两个脚本。运行完成之后 CRS升级完成。
注意这时候之前关闭的相关服务已经启动了,在升级数据库的时候需要重新关闭。

2、升级数据库软件
升级数据库软件与升级CRS基本相同，记得在第二步的时候选择数据库的安装路径即可，最后一步需要在每个节点上执行root.sh脚本。

3、升级数据库
在升级数据库的时候不仅要要确保crs的相关服务启动，还需要启动监听服务。

3.1启动crs服务和监听
$srvctl start listener -n ract01
$srvctl start listener -n ract02
3.2启动到nomount状态修改参数
[oracle@rac01 ~]$ sqlplus /nolog
SQL>CONN SYS AS SYSDBA
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP NOMOUNT
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
SQL> SHUTDOWN
3.2.1运行升级脚本
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql #此处执行时间较长
SQL> SHUTDOWN IMMEDIATE
SQL> SPOOL OFF
3.2.3编译无效对象
SQL> STARTUP
SQL> @?/rdbms/admin/utlrp.sql
SQL>ALTER SYSTEM SET CLUSTER_DATABASE=TRUE scope=spfile;
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
3.2.4升级后检查
[root@rac01 ~]# su – oracle
[oracle@rac01 ~]$ sqlplus /nolog
SQL> conn / as sysdba
Connected.
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

COMP_NAME VERSION STATUS
—————————————- —————- ———-
Oracle Enterprise Manager 10.2.0.4.0 VALID
Spatial 10.2.0.4.0 VALID
Oracle interMedia 10.2.0.4.0 VALID
OLAP Catalog 10.2.0.4.0 VALID
Oracle XML Database 10.2.0.4.0 VALID
Oracle Text 10.2.0.4.0 VALID
Oracle Expression Filter 10.2.0.4.0 VALID
Oracle Rule Manager 10.2.0.4.0 VALID
Oracle Workspace Manager 10.2.0.4.3 VALID
Oracle Data Mining 10.2.0.4.0 VALID
Oracle Database Catalog Views 10.2.0.4.0 VALID
Oracle Database Packages and Types 10.2.0.4.0 VALID
JServer JAVA Virtual Machine 10.2.0.4.0 VALID
Oracle XDK 10.2.0.4.0 VALID
Oracle Database Java Packages 10.2.0.4.0 VALID
OLAP Analytic Workspace 10.2.0.4.0 VALID
Oracle OLAP API 10.2.0.4.0 VALID
Oracle Real Application Clusters 10.2.0.4.0 VALID

18 rows selected.