GRID/CRS 11.2.0.3升级到11.2.0.4.5操作步骤
下面是简单记录ORACLE GRID环境中,将GRID与RDBMS从11.2.0.3升级到11.2.0.4.5的过程,下面只能用于测试环境,请勿使用与生产环境。本方案是提前将新版本的GRID/RDBMS安装好并升级到11.2.0.4.5,在正式升级停机的时才将GRID/RDBMS切换到新环境,也就是才执行rootupgrade.sh的脚本,这样可以节约停机时间。grid/rdbms+psu安装估计也要差不多3个小时的。
1,环境介绍 |
|
升级前环境 |
升级后环境 |
环境变量配置文件 |
.bash_profile_old |
.bash_profile_new |
ORACLE_HOME(RDBMS) |
/u01/app/oracle/product/11.2.0/db_1 |
/u01/app/oracle/product/11.2.0/db_2 |
ORACLE_HOME(GRID) |
/u01/app/11.2.0/grid |
/u01/app/11.2.0/grid_1 |
OS VERSION |
Linux 11rac1 2.6.32-300.10.1.el5uek |
Linux 11rac1 2.6.32-300.10.1.el5uek |
OCR/VOTEDISK |
+CRS |
+CRS |
整个实验在LINUX 5.8的环境,其它的环境可以操作会不同。
2,环境备份 |
这些我们需要对原环境的一些脚本文件与OCR的信息做一次备份,用于在升级失败的时候回退。需要11g提供了deconfig ,config.sh脚本可用于快速卸载grid环境并重新配置grid环境,不过我还是建议大家做一个备份。GRID/RDBMS软件安装目录没有必要备份,新环境都是重新安装,不会影响原环境的安装目录文件。
这里的备份只能用于RHEL 5.8环境,不使用于RHEL 6的环境,应为RHEL 6里面INIT机制发生了变化。
备份脚本 mkdir /tmp/htz cp -p /etc/init.d/init.ohasd /tmp/htz cp -p /etc/init.d/ohasd /tmp/htz cp -p /etc/inittab /tmp/htz cp -pr /etc/oracle /tmp/htz cp -p /etc/oratab /tmp/htz cp -pr /u01/app/oraInventory /tmp/htz -- 还原 -- cp -pr /tmp/htz/oraInventory /u01/app/ -- cp -p /tmp/htz/init.ohasd /etc/init.d/ -- cp -p /tmp/htz/ohasd /etc/init.d/ -- cp -p /tmp/htz/inittab /etc/ -- cp -p /tmp/htz/oracle /etc/ -- cp -p /tmp/htz/oratab /etc -- ln -s /etc/rc2.d/K96init.crs /etc/init.d/ohasd -- ln -s /etc/rc2.d/S96init.crs /etc/init.d/ohasd -- ln -s /etc/rc3.d/K96init.crs /etc/init.d/ohasd -- ln -s /etc/rc3.d/S96init.crs /etc/init.d/ohasd -- ln -s /etc/rc5.d/K96init.crs /etc/init.d/ohasd -- ln -s /etc/rc5.d/S96init.crs /etc/init.d/ohasd 备份ocr信息 ocrconfig -local -manualbackup ocrconfig -local -showbackup ocrconfig -manualbackup ocrconfig -showbackup
3,上传文件 |
这里需要上传安装文件包,OPATCH,PSU包。
4,安装GRID |
下面的所有操作需要在两个节点同时执行,这里我只写了节点1的操作。
查看环境变量配置信息
[grid@11rac1 ~]$ mv .bash_profile .bash_profile_old [grid@11rac1 ~]$ cp .bash_profile_old .bash_profile_new [grid@11rac1 ~]$ cat .bash_profile_new # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH ORACLE_BASE=/u01/app/grid; export ORACLE_BASE ORACLE_HOME=/u01/app/11.2.0/grid_1; export ORACLE_HOME export PATH=$ORACLE_HOME/bin:$PATH export TNS_ADMIN=$ORACLE_HOME/network/admin export ORACLE_SID=+ASM1 export DISPLAY=192.168.111.1:0.0 stty erase ^h set -o vi [grid@11rac1 ~]$ exit logout [root@11rac1 ~]# su - grid -bash-3.2$ source .bash_profile_new [grid@11rac1 ~]$ 解压软件 这里使用root用户来解压的 [root@11rac1 soft]# unzip p13390677_112040_Linux-x86-64_3of7.zip [root@11rac1 soft]# chown -R 777 grid 开始安装 [root@11rac1 soft]# su - grid -bash-3.2$ source .bash_profile_new [grid@11rac1 ~]$ cd /soft/grid [grid@11rac1 grid]$ ./runInstaller Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 20590 MB Passed Checking swap space: must be greater than 150 MB. Actual 3999 MB Passed
这里要记住是选择最后一个
这里点YES
这里报不能创建grid_1目录,下面我们手动去创建目录。并且给777权限,在后面跑rootupgrade.sh的时候会自动更改这个目录的权限的
[root@11rac1 11.2.0]# mkdir grid_1 [root@11rac1 11.2.0]# chmod 777 grid_1
点OK在点NEXT
这里报了一些错误,请根据自己的环境确定是否忽略,这里我选择忽略所有。
点YES
开始安装
执行root.sh,需要在root.sh用户下执行 [root@11rac1 ~]# /u01/app/11.2.0/grid_1/root.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/11.2.0/grid_1 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. To configure Grid Infrastructure for a Stand-Alone Server run the following command as the root user: /u01/app/11.2.0/grid_1/perl/bin/perl -I/u01/app/11.2.0/grid_1/perl/lib -I/u01/app/11.2.0/grid_1/crs/install /u01/app/11.2.0/grid_1/crs/install/roothas.pl To configure Grid Infrastructure for a Cluster execute the following command: /u01/app/11.2.0/grid_1/crs/config/config.sh This command launches the Grid Infrastructure Configuration Wizard. The wizard also supports silent operation, and the parameters can be passed through the response file that is available in the installation media.
点OK
安装GRID完成,下面是升级到11.2.0.4.5
备份OPATCH [root@11rac1 ~]# su - grid -bash-3.2$ source .bash_profile_new [grid@11rac1 ~]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPATCH [grid@11rac1 ~]$ unzip /soft/p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME Archive: /soft/p6880880_112000_Linux-x86-64.zip 这里只要看到版本大于11.2.0.3.5就可以了 [grid@11rac1 ~]$ $ORACLE_HOME/OPatch/opatch version OPatch Version: 11.2.0.3.10 OPatch succeeded. 解压PSU软件,PSU的信息查询可以参考: Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets (文档 ID 1454618.1) [root@11rac1 soft]# unzip p19955028_112040_Linux-x86-64.zip [root@11rac1 soft]# chmod -R 777 19955028 [grid@11rac1 ~]$ /u01/app/11.2.0/grid_1/OPatch/opatch napply /soft/19955028/ -oh /u01/app/11.2.0/grid_1 -local Oracle Interim Patch Installer version 11.2.0.3.10 Copyright (c) 2015, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/11.2.0/grid_1 Central Inventory : /u01/app/oraInventory from : /u01/app/11.2.0/grid_1/oraInst.loc OPatch version : 11.2.0.3.10 OUI version : 11.2.0.4.0 Log file location : /u01/app/11.2.0/grid_1/cfgtoollogs/opatch/opatch2015-05-18_02-42-31AM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 19769469 19769476 17478514 18031668 18522509 19121551 19769489 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/11.2.0/grid_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '19769469' to OH '/u01/app/11.2.0/grid_1' ...................................................... Patching component oracle.rdbms.deconfig, 11.2.0.4.0... Verifying the update... Composite patch 19769489 successfully applied. Patches 19769469,19769476 successfully applied. Log file location: /u01/app/11.2.0/grid_1/cfgtoollogs/opatch/opatch2015-05-18_02-42-31AM_1.log OPatch succeeded. 确认是否升级成功 [grid@11rac1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches 19769489;Database Patch Set Update : 11.2.0.4.5 (19769489) 19769476;OCW Patch Set Update : 11.2.0.4.5 (19769476) 19769469;ACFS Patch Set Update : 11.2.0.4.5 (19769469) OPatch succeeded.
5,安装RDBMS软件 |
下面的操作也是需要在2个节点同时执行的,这里只写了节点1的操作。
[root@11rac1 soft]# su - oracle [oracle@11rac1 ~]$ mv .bash_profile .bash_profile_old [oracle@11rac1 ~]$ cp .bash_profile_old .bash_profile_new [oracle@11rac1 ~]$ vi .bash_profile_new export SHELL_HOME=$HOME/rs # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_2; export ORACLE_HOME export PATH=$ORACLE_HOME/bin:$PATH export TNS_ADMIN=$ORACLE_HOME/network/admin export ORACLE_SID=power1 export DISPLAY=192.168.111.1:0.0 stty erase ^h set -o vi 解压软件 [root@11rac1 soft]# unzip p13390677_112040_Linux-x86-64_1of7.zip [root@11rac1 soft]# unzip p13390677_112040_Linux-x86-64_2of7.zip [root@11rac1 soft]# chmod -R 777 database 开始安装 [root@11rac1 soft]# su - oracle -bash-3.2$ source .bash_profile_new [oracle@11rac1 ~]$ cd /soft/database [oracle@11rac1 database]$ ./runInstaller Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 14598 MB Passed Checking swap space: must be greater than 150 MB. Actual 3417 MB Passed Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
点YES
点YES
以root用户执行root.sh [root@11rac1 soft]# /u01/app/oracle/product/11.2.0/db_2/root.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0/db_2 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. Finished product-specific root actions. 点OK |
编译RAC功能
[root@11rac1 soft]# su - oracle -bash-3.2$ source .bash_profile_new [oracle@11rac1 ~]$ cd $ORACLE_HOME/rdbms/lib [oracle@11rac1 lib]$ make -f ins_rdbms.mk rac_on (if /u01/app/oracle/product/11.2.0/db_2/bin/skgxpinfo | grep rds;\ then \ make -f /u01/app/oracle/product/11.2.0/db_2/rdbms/lib/ins_rdbms.mk ipc_rds; \ else \ make -f /u01/app/oracle/product/11.2.0/db_2/rdbms/lib/ins_rdbms.mk ipc_g; \ fi) make[1]: Entering directory `/u01/app/oracle/product/11.2.0/db_2/rdbms/lib' rm -f /u01/app/oracle/product/11.2.0/db_2/lib/libskgxp11.so cp /u01/app/oracle/product/11.2.0/db_2/lib//libskgxpg.so /u01/app/oracle/product/11.2.0/db_2/lib/libskgxp11.so make[1]: Leaving directory `/u01/app/oracle/product/11.2.0/db_2/rdbms/lib' - Use stub SKGXN library cp /u01/app/oracle/product/11.2.0/db_2/lib/libskgxns.so /u01/app/oracle/product/11.2.0/db_2/lib/libskgxn2.so /usr/bin/ar d /u01/app/oracle/product/11.2.0/db_2/rdbms/lib/libknlopt.a ksnkcs.o /usr/bin/ar cr /u01/app/oracle/product/11.2.0/db_2/rdbms/lib/libknlopt.a /u01/app/oracle/product/11.2.0/db_2/rdbms/lib/kcsm.o [oracle@11rac1 lib]$ make -f ins_rdbms.mk ioracle chmod 755 /u01/app/oracle/product/11.2.0/db_2/bin - Linking Oracle rm -f /u01/app/oracle/product/11.2.0/db_2/rdbms/lib/oracle gcc -o /u01/app/oracle/product/11.2.0/db_2/rdbms/lib/oracle -m64 -z noexecstack -L/u01/app/oracle/product/11.2.0/db_2/rdbms/lib/ -L/u01/app/oracle/product/11.2.0/db_2/lib/ -L/u01/app/oracle/product/11.2.0/db_2/lib/stubs/ -Wl,-E /u01/app/oracle/product/11.2.0/db_2/rdbms/lib/opimai.o /u01/app/oracle/product/11.2.0/db_2/rdbms/lib/ssoraed.o /u01/app/oracle/product/11.2.0/db_2/rdbms/lib/ttcsoi.o -Wl,--whole-archive -lperfsrv11 -Wl,--no-whole-archive /u01/app/oracle/product/11.2.0/db_2/lib/nautab.o /u01/app/oracle/product/11.2.0/db_2/lib/naeet.o /u01/app/oracle/product/11.2.0/db_2/lib/naect.o /u01/app/oracle/product/11.2.0/db_2/lib/naedhs.o /u01/app/oracle/product/11.2.0/db_2/rdbms/lib/config.o -lserver11 -lodm11 -lcell11 -lnnet11 -lskgxp11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lvsn11 -lcommon11 -lgeneric11 -lknlopt `if /usr/bin/ar tv /u01/app/oracle/product/11.2.0/db_2/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap11" ; fi` -lslax11 -lpls11 -lrt -lplp11 -lserver11 -lclient11 -lvsn11 -lcommon11 -lgeneric11 `if [ -f /u01/app/oracle/product/11.2.0/db_2/lib/libavserver11.a ] ; then echo "-lavserver11" ; else echo "-lavstub11"; fi` `if [ -f /u01/app/oracle/product/11.2.0/db_2/lib/libavclient11.a ] ; then echo "-lavclient11" ; fi` -lknlopt -lslax11 -lpls11 -lrt -lplp11 -ljavavm11 -lserver11 -lwwg `cat /u01/app/oracle/product/11.2.0/db_2/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/db_2/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lmm -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lztkg11 `cat /u01/app/oracle/product/11.2.0/db_2/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u01/app/oracle/product/11.2.0/db_2/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `if /usr/bin/ar tv /u01/app/oracle/product/11.2.0/db_2/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo11"; fi` -L/u01/app/oracle/product/11.2.0/db_2/ctx/lib/ -lctxc11 -lctx11 -lzx11 -lgx11 -lctx11 -lzx11 -lgx11 -lordimt11 -lclsra11 -ldbcfg11 -lhasgen11 -lskgxn2 -lnnz11 -lzt11 -lxml11 -locr11 -locrb11 -locrutl11 -lhasgen11 -lskgxn2 -lnnz11 -lzt11 -lxml11 -loraz -llzopro -lorabz2 -lipp_z -lipp_bz2 -lippdcemerged -lippsemerged -lippdcmerged -lippsmerged -lippcore -lippcpemerged -lippcpmerged -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lsnls11 -lunls11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lasmclnt11 -lcommon11 -lcore11 -laio `cat /u01/app/oracle/product/11.2.0/db_2/lib/sysliblist` -Wl,-rpath,/u01/app/oracle/product/11.2.0/db_2/lib -lm `cat /u01/app/oracle/product/11.2.0/db_2/lib/sysliblist` -ldl -lm -L/u01/app/oracle/product/11.2.0/db_2/lib test ! -f /u01/app/oracle/product/11.2.0/db_2/bin/oracle ||\ mv -f /u01/app/oracle/product/11.2.0/db_2/bin/oracle /u01/app/oracle/product/11.2.0/db_2/bin/oracleO mv /u01/app/oracle/product/11.2.0/db_2/rdbms/lib/oracle /u01/app/oracle/product/11.2.0/db_2/bin/oracle chmod 6751 /u01/app/oracle/product/11.2.0/db_2/bin/oracle [oracle@11rac1 lib]$ ar -t $ORACLE_HOME/rdbms/lib/libknlopt.a|grep kcsm.o kcsm.o
升级PSU
[root@11rac1 soft]# su - oracle -bash-3.2$ source .bash_profile_new [oracle@11rac1 ~]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPATCH [oracle@11rac1 ~]$ unzip /soft/p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME [oracle@11rac1 ~]$ $ORACLE_HOME/OPatch/opatch version OPatch Version: 11.2.0.3.10 OPatch succeeded. 这里不需要解压11.2.0.4.5的PSU了,在GRID用户那里就已经解压了 [oracle@11rac1 19955028]$ $ORACLE_HOME/OPatch/opatch napply /soft/19955028/19769489/ -oh $ORACLE_HOME -local Oracle Interim Patch Installer version 11.2.0.3.10 Copyright (c) 2015, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_2 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_2/oraInst.loc OPatch version : 11.2.0.3.10 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db_2/cfgtoollogs/opatch/opatch2015-05-18_03-40-43AM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/11.2.0/db_2') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0/db_2' ........... Patching component oracle.rdbms.deconfig, 11.2.0.4.0... Verifying the update... OPatch found the word "warning" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ins_emagent.mk:113: warning: overriding commands for target `nmosudo' ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo' /u01/app/oracle/product/11.2.0/db_2/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo' /u01/app/oracle/product/11.2.0/db_2/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo' Composite patch 19769489 successfully applied. OPatch Session completed with warnings. Log file location: /u01/app/oracle/product/11.2.0/db_2/cfgtoollogs/opatch/opatch2015-05-18_03-40-43AM_1.log OPatch completed with warnings. [oracle@11rac1 19955028]$ $ORACLE_HOME/OPatch/opatch napply /soft/19955028/19769476/custom/server/19769476 -oh $ORACLE_HOME -local [oracle@11rac1 19955028]$ $ORACLE_HOME/OPatch/opatch lspatches 19769476;OCW Patch Set Update : 11.2.0.4.5 (19769476) 19769489;Database Patch Set Update : 11.2.0.4.5 (19769489) OPatch succeeded 已经成功了。
7,切换GRID到新环境 |
此步骤需要建议是停业务,会已经更新GRID节点到新环境,如果遇到更新失败的情况,正常回退时,是需要关闭GRID所有的节点。
[root@11rac1 soft]# su - grid -bash-3.2$ source .bash_profile_new [grid@11rac1 ~]$ /u01/app/11.2.0/grid_1/crs/config/config.sh
选择YES
脚本中我们需要注意几个地方,第一个主机执行的rotupgrade.sh脚本时,会更新ASM中的数据,然而在回退的时候,最后一个主机也就是lastnode节点会更新ASM中的数据,并且在12C直接以-nocrs模式启动CRS。另外我们需要了解rootupgrade.sh后面执行了那些操作,怎么去trace这个rootupgrade.sh脚本执行过程。 [root@11rac1 soft]# /u01/app/11.2.0/grid_1/rootupgrade.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/11.2.0/grid_1 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. Relinking oracle with rac_on option Using configuration parameter file: /u01/app/11.2.0/grid_1/crs/install/crsconfig_params Creating trace directory User ignored Prerequisites during installation Installing Trace File Analyzer ASM upgrade has started on first node. CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on '11rac1' CRS-2673: Attempting to stop 'ora.crsd' on '11rac1' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on '11rac1' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on '11rac1' CRS-2673: Attempting to stop 'ora.oc4j' on '11rac1' CRS-2673: Attempting to stop 'ora.cvu' on '11rac1' CRS-2673: Attempting to stop 'ora.CRS.dg' on '11rac1' CRS-2673: Attempting to stop 'ora.power.power1.svc' on '11rac1' CRS-2677: Stop of 'ora.power.power1.svc' on '11rac1' succeeded CRS-2673: Attempting to stop 'ora.power.db' on '11rac1' CRS-2672: Attempting to start 'ora.power.power1.svc' on '11rac2' CRS-2676: Start of 'ora.power.power1.svc' on '11rac2' succeeded CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on '11rac1' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on '11rac1' CRS-2677: Stop of 'ora.scan1.vip' on '11rac1' succeeded CRS-2672: Attempting to start 'ora.scan1.vip' on '11rac2' CRS-2677: Stop of 'ora.power.db' on '11rac1' succeeded CRS-2673: Attempting to stop 'ora.DATA.dg' on '11rac1' CRS-2676: Start of 'ora.scan1.vip' on '11rac2' succeeded CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on '11rac2' CRS-2677: Stop of 'ora.DATA.dg' on '11rac1' succeeded CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on '11rac2' succeeded CRS-2677: Stop of 'ora.oc4j' on '11rac1' succeeded CRS-2672: Attempting to start 'ora.oc4j' on '11rac2' CRS-2677: Stop of 'ora.cvu' on '11rac1' succeeded CRS-2672: Attempting to start 'ora.cvu' on '11rac2' CRS-2676: Start of 'ora.cvu' on '11rac2' succeeded CRS-2676: Start of 'ora.oc4j' on '11rac2' succeeded CRS-2677: Stop of 'ora.CRS.dg' on '11rac1' succeeded CRS-2673: Attempting to stop 'ora.asm' on '11rac1' CRS-2677: Stop of 'ora.asm' on '11rac1' succeeded CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on '11rac1' CRS-2677: Stop of 'ora.LISTENER.lsnr' on '11rac1' succeeded CRS-2673: Attempting to stop 'ora.11rac1.vip' on '11rac1' CRS-2677: Stop of 'ora.11rac1.vip' on '11rac1' succeeded CRS-2672: Attempting to start 'ora.11rac1.vip' on '11rac2' CRS-2676: Start of 'ora.11rac1.vip' on '11rac2' succeeded CRS-2673: Attempting to stop 'ora.ons' on '11rac1' CRS-2677: Stop of 'ora.ons' on '11rac1' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on '11rac1' CRS-2677: Stop of 'ora.net1.network' on '11rac1' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on '11rac1' has completed CRS-2677: Stop of 'ora.crsd' on '11rac1' succeeded CRS-2673: Attempting to stop 'ora.crf' on '11rac1' CRS-2673: Attempting to stop 'ora.ctssd' on '11rac1' CRS-2673: Attempting to stop 'ora.evmd' on '11rac1' CRS-2673: Attempting to stop 'ora.asm' on '11rac1' CRS-2673: Attempting to stop 'ora.mdnsd' on '11rac1' CRS-2677: Stop of 'ora.crf' on '11rac1' succeeded CRS-2677: Stop of 'ora.evmd' on '11rac1' succeeded CRS-2677: Stop of 'ora.mdnsd' on '11rac1' succeeded CRS-2677: Stop of 'ora.ctssd' on '11rac1' succeeded CRS-2677: Stop of 'ora.asm' on '11rac1' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on '11rac1' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on '11rac1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on '11rac1' CRS-2677: Stop of 'ora.cssd' on '11rac1' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on '11rac1' CRS-2677: Stop of 'ora.gipcd' on '11rac1' succeeded CRS-2673: Attempting to stop 'ora.gpnpd' on '11rac1' CRS-2677: Stop of 'ora.gpnpd' on '11rac1' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on '11rac1' has completed CRS-4133: Oracle High Availability Services has been stopped. OLR initialization - successful Replacing Clusterware entries in /etc/inittab 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. Configure Oracle Grid Infrastructure for a Cluster ... succeeded 另一个节点 [root@11rac2 ~]# /u01/app/11.2.0/grid_1/rootupgrade.sh Performing root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/11.2.0/grid_1 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. Relinking oracle with rac_on option Using configuration parameter file: /u01/app/11.2.0/grid_1/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 '11rac2' CRS-2673: Attempting to stop 'ora.crsd' on '11rac2' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on '11rac2' CRS-2673: Attempting to stop 'ora.cvu' on '11rac2' CRS-2673: Attempting to stop 'ora.CRS.dg' on '11rac2' CRS-2673: Attempting to stop 'ora.power.power1.svc' on '11rac2' CRS-2673: Attempting to stop 'ora.power.power2.svc' on '11rac2' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on '11rac2' CRS-2677: Stop of 'ora.power.power1.svc' on '11rac2' succeeded CRS-2677: Stop of 'ora.power.power2.svc' on '11rac2' succeeded CRS-2673: Attempting to stop 'ora.power.db' on '11rac2' CRS-2672: Attempting to start 'ora.power.power1.svc' on '11rac1' CRS-2672: Attempting to start 'ora.power.power2.svc' on '11rac1' CRS-2677: Stop of 'ora.cvu' on '11rac2' succeeded CRS-2672: Attempting to start 'ora.cvu' on '11rac1' CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on '11rac2' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on '11rac2' CRS-2677: Stop of 'ora.scan1.vip' on '11rac2' succeeded CRS-2672: Attempting to start 'ora.scan1.vip' on '11rac1' CRS-2676: Start of 'ora.cvu' on '11rac1' succeeded CRS-2677: Stop of 'ora.power.db' on '11rac2' succeeded CRS-2676: Start of 'ora.power.power2.svc' on '11rac1' succeeded CRS-2676: Start of 'ora.power.power1.svc' on '11rac1' succeeded CRS-2673: Attempting to stop 'ora.DATA.dg' on '11rac2' CRS-2677: Stop of 'ora.DATA.dg' on '11rac2' succeeded CRS-2676: Start of 'ora.scan1.vip' on '11rac1' succeeded CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on '11rac1' CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on '11rac1' succeeded CRS-2677: Stop of 'ora.CRS.dg' on '11rac2' succeeded CRS-2673: Attempting to stop 'ora.asm' on '11rac2' CRS-2677: Stop of 'ora.asm' on '11rac2' succeeded CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on '11rac2' CRS-2677: Stop of 'ora.LISTENER.lsnr' on '11rac2' succeeded CRS-2673: Attempting to stop 'ora.11rac2.vip' on '11rac2' CRS-2677: Stop of 'ora.11rac2.vip' on '11rac2' succeeded CRS-2672: Attempting to start 'ora.11rac2.vip' on '11rac1' CRS-2676: Start of 'ora.11rac2.vip' on '11rac1' succeeded CRS-2673: Attempting to stop 'ora.ons' on '11rac2' CRS-2677: Stop of 'ora.ons' on '11rac2' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on '11rac2' CRS-2677: Stop of 'ora.net1.network' on '11rac2' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on '11rac2' has completed CRS-2677: Stop of 'ora.crsd' on '11rac2' succeeded CRS-2673: Attempting to stop 'ora.mdnsd' on '11rac2' CRS-2673: Attempting to stop 'ora.ctssd' on '11rac2' CRS-2673: Attempting to stop 'ora.evmd' on '11rac2' CRS-2673: Attempting to stop 'ora.asm' on '11rac2' CRS-2677: Stop of 'ora.evmd' on '11rac2' succeeded CRS-2677: Stop of 'ora.mdnsd' on '11rac2' succeeded CRS-2677: Stop of 'ora.ctssd' on '11rac2' succeeded CRS-2677: Stop of 'ora.asm' on '11rac2' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on '11rac2' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on '11rac2' succeeded CRS-2673: Attempting to stop 'ora.cssd' on '11rac2' CRS-2677: Stop of 'ora.cssd' on '11rac2' succeeded CRS-2673: Attempting to stop 'ora.crf' on '11rac2' CRS-2677: Stop of 'ora.crf' on '11rac2' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on '11rac2' CRS-2677: Stop of 'ora.gipcd' on '11rac2' succeeded CRS-2673: Attempting to stop 'ora.gpnpd' on '11rac2' CRS-2677: Stop of 'ora.gpnpd' on '11rac2' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on '11rac2' has completed CRS-4133: Oracle High Availability Services has been stopped. OLR initialization - successful Replacing Clusterware entries in /etc/inittab 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. The CSS was successfully upgraded. 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 upgrade has finished on last node. Configure Oracle Grid Infrastructure for a Cluster ... succeeded
回到之前的图形界面
点OK
这里报错是正常的,点OK
点YES
GRID已经切换到新环境中。
[root@11rac1 soft]# su - grid -bash-3.2$ source .bash_profile_new [grid@11rac1 ~]$ crsctl query crs activeversion Oracle Clusterware active version on the cluster is [11.2.0.4.0]
关于GRID升级失败的回退我们将会在最后写出来
8,更新数据库 |
执行utlu112i.sql脚本
先面这个脚本在执行DBUA的时候会执行,不过建议在升级之前规划的时候就执行这个脚本,看有那些需要整改的,提前整改完成。
[oracle@11rac1 ~]$ source .bash_profile_old [oracle@11rac1 ~]$ sqlplus '/ as sysdba' SQL*Plus: Release 11.2.0.3.0 Production on Mon May 18 05:21:04 2015 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> @/u01/app/oracle/product/11.2.0/db_2/rdbms/admin/utlu112i.sql Oracle Database 11.2 Pre-Upgrade Information Tool 05-18-2015 05:21:18 Script Version: 11.2.0.4.0 Build: 007 . ********************************************************************** Database: ********************************************************************** --> name: POWER --> version: 11.2.0.3.0 --> compatible: 11.2.0.0.0 --> blocksize: 8192 --> platform: Linux x86 64-bit --> timezone file: V14 . ********************************************************************** Tablespaces: [make adjustments in the current environment] ********************************************************************** --> SYSTEM tablespace is adequate for the upgrade. .... minimum required size: 925 MB --> SYSAUX tablespace is adequate for the upgrade. .... minimum required size: 677 MB --> UNDOTBS1 tablespace is adequate for the upgrade. .... minimum required size: 400 MB --> TEMP tablespace is adequate for the upgrade. .... minimum required size: 60 MB . ********************************************************************** Flashback: OFF ********************************************************************** ********************************************************************** Update Parameters: [Update Oracle Database 11.2 init.ora or spfile] Note: Pre-upgrade tool was run on a lower version 64-bit database. ********************************************************************** --> If Target Oracle is 32-Bit, refer here for Update Parameters: -- No update parameter changes are required. . --> If Target Oracle is 64-Bit, refer here for Update Parameters: -- No update parameter changes are required. . ********************************************************************** Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile] ********************************************************************** -- No renamed parameters found. No changes are required. . ********************************************************************** Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile] ********************************************************************** -- No obsolete parameters found. No changes are required . ********************************************************************** Components: [The following database components will be upgraded or installed] ********************************************************************** --> Oracle Catalog Views [upgrade] VALID --> Oracle Packages and Types [upgrade] VALID --> JServer JAVA Virtual Machine [upgrade] VALID --> Oracle XDK for Java [upgrade] VALID --> Real Application Clusters [upgrade] VALID --> Oracle Workspace Manager [upgrade] VALID --> OLAP Analytic Workspace [upgrade] VALID --> OLAP Catalog [upgrade] VALID --> EM Repository [upgrade] VALID --> Oracle Text [upgrade] VALID --> Oracle XML Database [upgrade] VALID --> Oracle Java Packages [upgrade] VALID --> Oracle interMedia [upgrade] VALID --> Spatial [upgrade] VALID --> Expression Filter [upgrade] VALID --> Rule Manager [upgrade] VALID --> Oracle Application Express [upgrade] VALID ... APEX will only be upgraded if the version of APEX in ... the target Oracle home is higher than the current one. --> Oracle OLAP API [upgrade] VALID . ********************************************************************** Miscellaneous Warnings ********************************************************************** WARNING: --> The "cluster_database" parameter is currently "TRUE" .... and must be set to "FALSE" prior to running a manual upgrade. WARNING: --> Database contains INVALID objects prior to upgrade. .... The list of invalid SYS/SYSTEM objects was written to .... registry$sys_inv_objs. .... The list of non-SYS/SYSTEM objects was written to .... registry$nonsys_inv_objs. .... Use utluiobj.sql after the upgrade to identify any new invalid .... objects due to the upgrade. .... USER SCOTT has 1 INVALID objects. WARNING: --> Database contains schemas with objects dependent on DBMS_LDAP package. .... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs. .... USER APEX_030200 has dependent objects. .这个可以忽略 ********************************************************************** Recommendations ********************************************************************** Oracle recommends gathering dictionary statistics prior to upgrading the database. To gather dictionary statistics execute the following command while connected as SYSDBA: EXECUTE dbms_stats.gather_dictionary_stats; *********************************************************************
一些其它需要注意的地方
如:RDBMS需要禁用VAULT功能。
提前清理回收站。
提前编译无效对象。
备份数据库
在更新数据库之前建议对数据库做一次备份,强烈推荐使用RMAN对数据库做备份。另外如果数据库小,也可以使用expdp/exp等工具备份。另外对于核心的系统建议搭建DG环境,如果真遇到升级失败也不能回退的情况下,可以将业务切换到DG环境。
这里使用FLASHBACK DATABASE的功能,此功能我觉得还是很不错的,特别在这种升级中,可以快速闪回数据库。
关于数据库的FLASHBACK DATABASE功能,可以查看下面文档:
Flashback Database Best Practices & Performance (Doc ID 565535.1)
创建RESTORE POINT
确认FRA有足够的空间 SQL> show parameter recovery db_recovery_file_dest string +DATA db_recovery_file_dest_size big integer 4347M SQL> create restore point before_upgrade guarantee flashback database; SQL> SELECT NAME, 2 SCN, 3 to_char(TIME, 'yyyy-mm-dd hh24:mi:ss'), 4 DATABASE_INCARNATION# DI, 5 GUARANTEE_FLASHBACK_DATABASE, 6 STORAGE_SIZE 7 FROM V$RESTORE_POINT 8 WHERE GUARANTEE_FLASHBACK_DATABASE = 'YES'; NAME SCN TO_CHAR(TIME,'YYYY- DI GUA STORAGE_SIZE -------------------- ---------- ------------------- ---------- --- ------------ BEFORE_UPGRADE 29693860 2015-05-18 06:25:11 2 YES 52428800
DBUA开始升级
这里使用了静默的方式升级数据库。
[oracle@11rac1 ~]$ source .bash_profile_new [oracle@11rac1 ~]$ /u01/app/oracle/product/11.2.0/db_2/bin/dbua -silent -dbName power -oracleHome /u01/app/oracle/product/11.2.0/db_1 -sysDBAuserName sys -sysDBAPassword oracle -recompile_invalid_objects false -upgradeTimezone -emConfiguration NONE Log files for the upgrade operation are located at: /u01/app/oracle/cfgtoollogs/dbua/power/upgrade1 Performing Pre Upgrade 1% complete 7% complete Upgrading Oracle Server 8% complete 9% complete 10% complete 10% complete 11% complete 12% complete 13% complete 13% complete 14% complete 15% complete 16% complete 16% complete 17% complete 18% complete 19% complete 20% complete 20% complete Upgrading JServer JAVA Virtual Machine 22% complete 23% complete 23% complete 24% complete 25% complete 26% complete Upgrading Oracle XDK for Java 27% complete Upgrading Real Application Clusters 29% complete Upgrading OLAP Analytic Workspace 30% complete Upgrading OLAP Catalog 32% complete Upgrading EM Repository 33% complete 34% complete 35% complete 36% complete 36% complete 37% complete 38% complete 39% complete 40% complete 40% complete 41% complete 42% complete 43% complete 43% complete 44% complete 45% complete 46% complete 46% complete 47% complete 48% complete 49% complete 50% complete 50% complete 51% complete 52% complete 53% complete 53% complete 54% complete 55% complete Upgrading Oracle Text 56% complete Upgrading Oracle XML Database 58% complete 59% complete 60% complete 60% complete 61% complete 62% complete 63% complete 63% complete Upgrading Oracle Java Packages 65% complete Upgrading Oracle interMedia 66% complete 67% complete Upgrading Spatial 69% complete 70% complete 70% complete 71% complete 72% complete 73% complete 73% complete 74% complete 75% complete 76% complete 76% complete 77% complete Upgrading Oracle Workspace Manager 79% complete Upgrading Expression Filter 80% complete Upgrading Rule Manager 82% complete Upgrading Oracle Application Express 83% complete Upgrading Oracle OLAP API 84% complete Performing Post Upgrade 85% complete 86% complete 92% complete Generating Summary Database upgrade has been completed successfully, and the database is ready to use. 100% complete Check the log file "/u01/app/oracle/cfgtoollogs/dbua/logs/silent.log" for upgrade details.
更新PSU
[oracle@11rac1 ~]$ source .bash_profile_new [oracle@11rac1 ~]$ sqlplus '/ as sysdba' SQL*Plus: Release 11.2.0.4.0 Production on Mon May 18 07:09:51 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> @?/rdbms/admin/catbundle.sql psu apply
9,查看升级后的版本 |
[oracle@11rac1 ~]$ source .bash_profile_new [oracle@11rac1 ~]$ cd rs/sql [oracle@11rac1 sql]$ sqlplus '/ as sysdba' SQL*Plus: Release 11.2.0.4.0 Production on Mon May 18 07:13:25 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> @db_version.sql Session altered. BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production CORE 11.2.0.4.0 Production TNS for Linux: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 - Production COMP_ID COMP_NAME SCHEMA VERSION STATUS --------------- -------------------------------------------------- --------------- ---------- ---------------------- OWB OWB OWBSYS 11.2.0.3.0 VALID APEX Oracle Application Express APEX_030200 3.2.1.00.1 VALID 2 EM Oracle Enterprise Manager SYSMAN 11.2.0.4.0 VALID AMD OLAP Catalog OLAPSYS 11.2.0.4.0 VALID SDO Spatial MDSYS 11.2.0.4.0 VALID ORDIM Oracle Multimedia ORDSYS 11.2.0.4.0 VALID XDB Oracle XML Database XDB 11.2.0.4.0 VALID CONTEXT Oracle Text CTXSYS 11.2.0.4.0 VALID EXF Oracle Expression Filter EXFSYS 11.2.0.4.0 VALID RUL Oracle Rules Manager EXFSYS 11.2.0.4.0 VALID OWM Oracle Workspace Manager WMSYS 11.2.0.4.0 VALID CATALOG Oracle Database Catalog Views SYS 11.2.0.4.0 VALID CATPROC Oracle Database Packages and Types SYS 11.2.0.4.0 VALID JAVAVM JServer JAVA Virtual Machine SYS 11.2.0.4.0 VALID XML Oracle XDK SYS 11.2.0.4.0 VALID CATJAVA Oracle Database Java Packages SYS 11.2.0.4.0 VALID APS OLAP Analytic Workspace SYS 11.2.0.4.0 VALID XOQ Oracle OLAP API SYS 11.2.0.4.0 VALID RAC Oracle Real Application Clusters SYS 11.2.0.4.0 VALID 19 rows selected. ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS ------------------------------ -------------------- ---------- ---------- ---------- --------------- -------------------------------------------------- 2011-09-17 10:21:11.595816 APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.0 2013-02-06 05:49:54.054481 APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.0 2015-05-18 07:04:45.421102 VIEW INVALIDATE 8289601 view invalidation 2015-05-18 07:04:45.463247 UPGRADE SERVER 11.2.0.4.0 Upgraded from 11.2.0.3.0 2015-05-18 07:05:27.637844 APPLY SERVER 11.2.0.4 5 PSU PSU 11.2.0.4.5 2015-05-18 07:11:39.018714 APPLY SERVER 11.2.0.4 5 PSU PSU 11.2.0.4.5
查看RDBMS软件
[oracle@11rac1 sql]$ $ORACLE_HOME/OPatch/opatch lspatches 19769476;OCW Patch Set Update : 11.2.0.4.5 (19769476) 19769489;Database Patch Set Update : 11.2.0.4.5 (19769489) OPatch succeeded.
查看GRID软件
[root@11rac1 soft]# su - grid -bash-3.2$ source .bash_profile_new [grid@11rac1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches 19769489;Database Patch Set Update : 11.2.0.4.5 (19769489) 19769476;OCW Patch Set Update : 11.2.0.4.5 (19769476) 19769469;ACFS Patch Set Update : 11.2.0.4.5 (19769469) OPatch succeeded.
从上面的信息可以看到,整个升级成功,下面重启一下服务器,开还正常不。
回退的方案与升级失败的回退方案我们将在一次笔记中记录
本文固定链接: http://www.htz.pw/?p=1064 | 认真就输
最活跃的读者