GRID/CRS 11.2.0.3升级到11.2.0.4.5操作步骤
May172015
下面是简单记录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 | 认真就输
最新评论
K.I.S.S.LANG:
来过，总要留下点什么brokensword:
非常感谢博主的分享，不知博主可以冰冻心灵:
主库使用ALTER DATABAcsdw:
是 1031
哈哈,,黄大师,总结得好huangtingzhong:
Loading Hinted E
下面是ASM磁盘头的部分ASM
RMAN backup to F
Database Crashed
How to Resolve O
最活跃的读者