当前位置: 首页 > UPDATE > 正文

GRID/CRS 11.2.0.3升级到11.2.0.4.5操作步骤

       下面是简单记录ORACLE GRID环境中,将GRIDRDBMS11.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

clip_image001

这里要记住是选择最后一个

clip_image002

clip_image003

clip_image004

这里点YES

clip_image005

clip_image006

clip_image007

这里报不能创建grid_1目录,下面我们手动去创建目录。并且给777权限,在后面跑rootupgrade.sh的时候会自动更改这个目录的权限的

[root@11rac1 11.2.0]# mkdir grid_1
[root@11rac1 11.2.0]# chmod 777 grid_1

 

点OK在点NEXT

 

clip_image008

 

这里报了一些错误,请根据自己的环境确定是否忽略,这里我选择忽略所有。

 

clip_image009

 

点YES

 

clip_image010

 

开始安装

 

clip_image011

 

clip_image012

 

执行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.

 

clip_image013

 

点OK

 

clip_image014

 

安装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

clip_image015

clip_image016

YES

clip_image017

clip_image018

clip_image019

clip_image020

clip_image021

clip_image022

clip_image023

clip_image024

clip_image025

YES

clip_image026

clip_image027

clip_image028

以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.

clip_image029

OK

clip_image030

编译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

clip_image031

clip_image032

clip_image033

clip_image034

clip_image035

选择YES

clip_image036

clip_image037

脚本中我们需要注意几个地方,第一个主机执行的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

回到之前的图形界面

clip_image038

OK

clip_image039

这里报错是正常的,点OK

clip_image040

clip_image041

YES

clip_image042

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/2015/05/17/gridcrs-11-2-0-3%e5%8d%87%e7%ba%a7%e5%88%b011-2-0-4-5%e6%93%8d%e4%bd%9c%e6%ad%a5%e9%aa%a4.html | 认真就输

该日志由 huangtingzhong 于2015年05月17日发表在 UPDATE 分类下, 通告目前不可用,你可以至底部留下评论。
原创文章转载请注明: GRID/CRS 11.2.0.3升级到11.2.0.4.5操作步骤 | 认真就输
关键字: ,