OracleRAC10.2.0.1Linux升级到10.2.0.4步骤:
     1.下载升级补丁p6810189_10204_Linux-x86.zip,并上传到RAC的master node,解压.
     2.停止数据库,用rman备份全库,再用tar备份$CRS_HOME及$ORACLE_HOME.
     3.升级CRS.
          3.1停止EM及Isqlplus.
                 emctl stop dbconsole
                 isqlpusctl stop
          3.2关闭数据库,ASM,监听.
                 srvctl stop database -d racdb
                 srvctl stop asm -n myrac1
                 srvctl stop asm -n myrac2
                 srvctl stop listener -n myrac1
                 srvctl stop listener -n myrac2                
          3.3以root用户停止各个节点CRS.
                 /etc/init.d/init.crs stop
          3.4执行runinstaller,选择CRS_HOME.(oracle会自动选择所有节点)
          3.5一直next,最后出现用root在各节点执行的如下操作:
               crsctl stop crs
               $CRS_HOME/install/root102.sh
          3.6提示补丁包升级成功.              
     4.升级Oracle软件.
          4.1停止EM及Isqlplus.
                 emctl stop dbconsole
                 isqlplusctl stop
          4.2关闭数据库,ASM,监听.
                 srvctl stop database -d racdb
                 srvctl stop asm -n myrac1
                 srvctl stop asm -n myrac2
                 srvctl stop listener -n myrac1
                 srvctl stop listener -n myrac2                
          4.3执行runinstaller,选择ORACLE_HOME.(oracle会自动选择所有节点)    
          4.4一直next,执行最后一个界面是oracle提示以root用户在各个节点执行root.sh
                 $ORACLE_HOME/root.sh 
     5.升级数据库.
          5.1在一个节点启动ASM.
                 srvctl start asm -n myrac1
          5.1启动数据库并修改cluster_database参数为false.
                 conn /as sysdba
                 startup mount
                 alter system set cluster_database=false scope=spile;
          5.2停止数据库.
                 shutdown immediate
          5.3运行数据库预升级检查
                 conn /as sysdba
                 startup upgrade
                 spool /home/oracle/upgrade_pre.log
                 @?/rdbms/admin/utlu102i.sql
                 spool off
          5.4数据字典升级:
                 conn /as sysdba
                 spool /home/oracle/upgrade.log
                 @?/rdbms/admin/catupgrd.sql
                 spool off
                 检查upgrade.log文件,如果有问题,重新运行catupgrd.sql.
          5.5重启数据库
                 shutdown immediate
                 startup
          5.6重新编译无效对象.
                 spool /home/oracle/utlrp.log
                 @?/rdbms/admin/utlrp.sql
                 spool off
          5.7检查所有组件是否升级成功
                 select comp_name,version,status from sys.dba_registry;
                 所有输出为 VALID表示升级成功.
          5.8修改cluster_database为true并重启数据库;
                 alter system cluster_database=true scope=spfile;
                 shutdown immediate;
                 startup
     6.如果使用专门的catlog数据库,使用下面命令更新:
                 rman catalog username/password@mycatdb
                 upgrade catalog;
     7.检查基本的数据库工具可用性并对数据库进行备份.