Linux-RAC 升级 11.2.0.3 至 11.2.0.4 1 / 32 一、一、上传及解压相关文件上传及解压相关文件3 二、二、创建创建 GI 和和 DB 软件目录（新）软件目录（新）3 三、三、安装升级安装升级 GI 软件软件4 四、四、安装升级安装升级 DB 软件软件.13 五、五、修改环境变量修改环境变量26 六、六、升级结果验证升级结果验证27 6.1 验证环境变量是否生效.27 6.2 验证数据库所有组件是否成功升级.28 七、七、关闭数据库关闭关闭数据库关闭 CRS 重启服务器重启服务器31 2 / 32 一、 上传及解压相关文件 将 11204 版的 grid 以及 oracle 软件上传至服务器。并在合适的位置进行解压，得到 database 以及 grid 文件夹。 二、 创建 GI 和 DB 软件目录（新） mkdir -p /data/11.2.0.4/grid/base mkdir -p /data/11.2.0.4/grid/crs mkdir -p /data/11.2.0.4/oracle/app chown grid:oinstall /data/11.2.0.4/grid/base chown grid:oinstall /data/11.2.0.4/grid/crs chown -R oracle:oinstall /data/11.2.0.4/oracle/app chmod -R 775 /data/11.2.0.4/ chown -R grid:oinstall /oracle_new 三、 安装升级 GI 软件 停止数据库实例 3 / 32 4 / 32 5 / 32 6 / 32 7 / 32 节点一脚本执行情况：节点一脚本执行情况： rootlinux1 # sh /oracle/app/11.2.0/grid/rootupgrade.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /oracle/app/11.2.0/grid Enter the full pathname of the local bin directory: /usr/local/bin: The contents of “dbhome“ have not changed. No need to overwrite. The contents of “oraenv“ have not changed. No need to overwrite. The contents of “coraenv“ have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. 8 / 32 Using configuration parameter file: /oracle/app/11.2.0/grid/crs/install/crsconfig_params Creating trace directory User ignored Prerequisites during installation Installing Trace File Analyzer CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on linux1 CRS-2673: Attempting to stop ora.crf on linux1 CRS-2673: Attempting to stop ora.mdnsd on linux1 CRS-2677: Stop of ora.crf on linux1 succeeded CRS-2673: Attempting to stop ora.gipcd on linux1 CRS-2677: Stop of ora.mdnsd on linux1 succeeded CRS-2677: Stop of ora.gipcd on linux1 succeeded CRS-2673: Attempting to stop ora.gpnpd on linux1 CRS-2677: Stop of ora.gpnpd on linux1 succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on linux1 has completed CRS-4133: Oracle High Availability Services has been stopped. ASM 升级已在第一个节点上初始化。 OLR initialization - successful Replacing Clusterware entries in upstart clscfg: EXISTING configuration version 5 detected. clscfg: version 5 is 11g Release 2. Successfully accumulated necessary OCR keys. Creating OCR keys for user root, privgrp root Operation successful. ASM 升级已在第一个节点上开始。 9 / 32 Configure Oracle Grid Infrastructure for a Cluster . succeeded 节点二脚本执行情况：节点二脚本执行情况： rootlinux2 # sh /oracle/app/11.2.0/grid/rootupgrade.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /oracle/app/11.2.0/grid Enter the full pathname of the local bin directory: /usr/local/bin: The contents of “dbhome“ have not changed. No need to overwrite. The contents of “oraenv“ have not changed. No need to overwrite. The contents of “coraenv“ have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Using configuration parameter file: /oracle/app/11.2.0/grid/crs/install/crsconfig_params Creating trace directory User ignored Prerequisites during installation Installing Trace File Analyzer CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on linux2 CRS-2673: Attempting to stop ora.mdnsd on linux2 CRS-2673: Attempting to stop ora.crf on linux2 CRS-2677: Stop of ora.crf on linux2 succeeded CRS-2673: Attempting to stop ora.gipcd on linux2 10 / 32 CRS-2677: Stop of ora.mdnsd on linux2 succeeded CRS-2677: Stop of ora.gipcd on linux2 succeeded CRS-2673: Attempting to stop ora.gpnpd on linux2 CRS-2677: Stop of ora.gpnpd on linux2 succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on linux2 has completed CRS-4133: Oracle High Availability Services has been stopped. OLR initialization - successful Replacing Clusterware entries in upstart clscfg: EXISTING configuration version 5 detected. clscfg: version 5 is 11g Release 2. Successfully accumulated necessary OCR keys. Creating OCR keys for user root, privgrp root Operation successful. Started to upgrade the Oracle Clusterware. This operation may take a few minutes. Started to upgrade the CSS. Started to upgrade the CRS. The CRS was successfully upgraded. Successfully upgraded the Oracle Clusterware. Oracle Clusterware operating version was successfully set to 11.2.0.4.0 ASM 升级已在最后一个节点上完成。 Configure Oracle Grid Infrastructure for a Cluster . succeeded 11 / 32 12 / 32 四、 安装升级 DB 软件 13 / 32 14 / 32 15 / 32 16