Oracle 11.2.0.1 RAC+DG升级至11.2.0.4

        此次升级总体流程：先升级DG数据库软件版本，再升级主库RAC双节点，最后DG从库实时同步高版本数据。

        源环境变量介绍

        rac01节点环境

oracle用户
​
ORACLE_SID=qpos1; export ORACLE_SID
​
ORACLE_UNQNAME=qpos; export ORACLE_UNQNAME
​
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
​
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
​
grid用户
​
ORACLE_SID=+ASM1; export ORACLE_SID
​
JAVA_HOME=/usr/local/java;export JAVA_HOME
​
ORACLE_BASE=/u01/app/grid; export ORACLE_BASE
​
ORACLE_HOME=/u01/app/11.2.0/grid; export ORACLE_HOME

        rac02节点环境

oracle用户
​
ORACLE_SID=qpos2; export ORACLE_SID
​
ORACLE_UNQNAME=qpos; export ORACLE_UNQNAME
​
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
​
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
​
grid用户
​
ORACLE_SID=+ASM2; export ORACLE_SID
​
JAVA_HOME=/usr/local/java;export JAVA_HOME
​
ORACLE_BASE=/u01/app/grid; export ORACLE_BASE
​
ORACLE_HOME=/u01/app/11.2.0/grid; export ORACLE_HOM

        具体操作步骤如下：

        1.主库暂停归档向备库传输

alter system set log_archive_dest_state_4=defer scope=both sid='*';

        2.备库在新目录下安装新版本软件

        2.1 关闭数据库，监听

shutdown immediate
lsnrctl stop

        2.2 备库在新目录下安装Oracle 11.2.0.4 软件。原有参数变量只修改ORACLE_HOME目录即可

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1;

        创建新的$ORACLE_HOME目录

$ mkdir -p /u01/app/oracle/product/11.2.0.4/dbhome_1

        编辑oracle用户环境变量，修改ORACLE_HOME变量值为新的目录

vi ~/.bash_profile
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/dbhome_1

        修改11.2.0.4软件安装的响应文件

oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=true
oracle.install.db.DBA_GROUP=dba
oracle.install.db.isRACOneInstall=false
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
DECLINE_SECURITY_UPDATES=true

        静默安装高版本数据库软件

[oracle@qposs1 database]$ ./runInstaller -silent -noconfig -responseFile /database/response/db_install.rsp  -ignoreSysPrereqs

        3.备库启动到mount状态

        环境变量修改为新目录 ORACLE_HOME 11.2.0.4 新目录注意copy之前的orapw文件，spfile和network file(tnsnames.ora listener.ora)等并修改里面的oracle home路径

        network file路径修改

[oracle@oracle2 admin]$ cp /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/*.ora  /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/

        spfile与orapwd文件路径修改

[oracle@qposs1 dbs]$ cp /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initqposs1.ora /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/
[oracle@qposs1 dbs]$ cp /u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwqposs1    /u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/

        4.备库以新版本启动数据库到mount状态，启动监听。

        5.查看RAC组件版本信息

SQL> col comp_name for a35;
SQL> select comp_name,version,status from dba_registry;
COMP_NAME          VERSION         STATUS
----------------------------------- ------------------------------ --------------------------------------------
OWB            11.2.0.1.0         VALID
Oracle Application Express      3.2.1.00.10        VALID
Oracle Enterprise Manager      11.2.0.1.0         VALID
OLAP Catalog          11.2.0.1.0         VALID
Spatial           11.2.0.1.0         VALID
Oracle Multimedia        11.2.0.1.0         VALID
Oracle XML Database        11.2.0.1.0         VALID
Oracle Text          11.2.0.1.0         VALID
Oracle Expression Filter      11.2.0.1.0         VALID
Oracle Rules Manager        11.2.0.1.0         VALID
Oracle Workspace Manager      11.2.0.1.0         VALID
Oracle Database Catalog Views      11.2.0.1.0         VALID
Oracle Database Packages and Types  11.2.0.1.0         VALID
JServer JAVA Virtual Machine      11.2.0.1.0         VALID
Oracle XDK          11.2.0.1.0         VALID
Oracle Database Java Packages      11.2.0.1.0         VALID
OLAP Analytic Workspace       11.2.0.1.0         VALID
Oracle OLAP API         11.2.0.1.0         VALID
Oracle Real Application Clusters    11.2.0.1.0         LOADED
19 rows selected.

        6.查看集群状态信息

[root@rac01 ~]# /u01/app/11.2.0/grid/bin/crsctl stat res -t
------------------------------------------------------------