当前位置: 首页 > BACKUP & RESTORE > 正文

最小停机时间:给GRID/DB打PSU补丁或者UPDATE

      下面的测试来至于MOS文档

Minimal downtime patching via cloning 11gR2 ORACLE_HOME directories (Doc ID 1136544.1)

       本方案采用的是复制ORACLE_HOME/GRID_HOME到新目录,对新目录升级后,将数据库或者ASM切换到新目录环境。此方法在单机环境相当有效,GRID单节节点环境打PSUOPATCH要运行大概30分钟,如果采用此方法大概5分钟就可以切换完成。但是对RAC没有任何作用,因为RAC可以采用滚动升级的方式,并且可以不用停生产。虽然在此方法测试中,GRID同时运行在两个不同的ORACLE_HOME目录下,其中一个节点的实例仍正常运行,但是MOS上面没有找到文档说支持此方式。

环境介绍

www.htz.pw > select * from V$version;

 

BANNER

——————————————————————————–

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production

PL/SQL Release 11.2.0.3.0 – Production

CORE    11.2.0.3.0      Production

TNS for Linux: Version 11.2.0.3.0 – Production

NLSRTL Version 11.2.0.3.0 – Production

 

www.htz.pw > !lsb_release -a

LSB Version:    :core-4.0-amd64:core-4.0-ia32:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-ia32:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-ia32:printing-4.0-noarch

Distributor ID: RedHatEnterpriseServer

Description:    Red Hat Enterprise Linux Server release 5.8 (Tikanga)

Release:        5.8

Codename:       Tikanga

1,准备工作

准备工作见RAC 11.2.0.3滚动升级11.2.0.3.10的准备工作部分,并且包括了OPATCH工具安装

2,升级GRID目录

 

2.1 创建新GRID目录与COPY文件

COPY文件前,建议手动删除一些不需要的日志文件,一般情况下日志文件都上10G,浪费空间与时间。

[root@11rac1 ~]# mkdir -p /u01/app/11.2.0/grid_2

[root@11rac1 ~]# chmod 755 /u01/app/11.2.0/grid_2

[root@11rac1 ~]# ls -ld /u01/app/11.2.0/grid_2

drwxr-xr-x 2 root root 4096 Oct 14 07:26 /u01/app/11.2.0/grid_2

[root@11rac1 ~]# chown root:dba /u01/app/11.2.0/grid_2

[root@11rac1 ~]# ls -ld /u01/app/11.2.0/grid_2

drwxr-xr-x 2 root dba 4096 Oct 14 07:26 /u01/app/11.2.0/grid_2

[root@11rac1 grid]# cd /u01/app/11.2.0/grid

[root@11rac1 grid]# tar cfp – . | ( cd /u01/app/11.2.0/grid_2; tar xf – )

2.2 克隆GRID

[root@11rac1 grid]#  export ORACLE_HOME=/u01/app/11.2.0/grid_2

[root@11rac1 grid]# /usr/bin/perl $ORACLE_HOME/OPatch/crs/patch112.pl -unlock -desthome=$ORACLE_HOME

Prototype mismatch: sub main::trim: none vs ($) at /u01/app/11.2.0/grid_2/OPatch/crs/patch112.pl line 401.

opatch auto log file location is /u01/app/11.2.0/grid_2/crs/install/../../cfgtoollogs/opatchauto2014-10-14_07-32-13.log

Detected Oracle Clusterware install

Using configuration parameter file: /u01/app/11.2.0/grid_2/crs/install/crsconfig_params

Successfully unlock /u01/app/11.2.0/grid_2

[grid@11rac1 grid]#  export ORACLE_HOME=/u01/app/11.2.0/grid_2

[grid@11rac1 ContentsXML]$ /usr/bin/perl $ORACLE_HOME/clone/bin/clone.pl ORACLE_BASE=/u01/app/grid  ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME=Ora11g_gridinfrahome1_2 INVENTORY_LOCATION=/u01/app/oraInventory -O’"CLUSTER_NODES={11rac1,11rac2}"’ -O’"LOCAL_NODE=11rac1"’ CRS=false -O"SHOW_ROOTSH_CONFIRMATION=false"

 

./runInstaller -clone -waitForCompletion  "ORACLE_BASE=/u01/app/grid" "ORACLE_HOME=/u01/app/11.2.0/grid_2" "ORACLE_HOME_NAME=Ora11g_gridinfrahome1_2" "INVENTORY_LOCATION=/u01/app/oraInventory" "CLUSTER_NODES={11rac1,11rac2}" "LOCAL_NODE=11rac1" "CRS=false" SHOW_ROOTSH_CONFIRMATION=false -silent -noConfig -nowait

Starting Oracle Universal Installer…

 

Checking swap space: must be greater than 500 MB.   Actual 3999 MB    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-10-14_07-41-33AM. Please wait …Oracle Universal Installer, Version 11.2.0.3.0 Production

Copyright (C) 1999, 2011, Oracle. All rights reserved.

 

You can find the log of this install session at:

 /u01/app/oraInventory/logs/cloneActions2014-10-14_07-41-33AM.log

.

Performing tests to see whether nodes 11rac2 are available

……………………………………………………… 100% Done.

 

 

 

Installation in progress (Monday, October 13, 2014 4:41:43 PM PDT)

………………………………………………………………                                                        72% Done.

Install successful

 

Linking in progress (Monday, October 13, 2014 4:41:46 PM PDT)

Link successful

 

Setup in progress (Monday, October 13, 2014 4:42:18 PM PDT)

……………..                                               100% Done.

Setup successful

 

End of install phases.(Monday, October 13, 2014 4:42:41 PM PDT)

The cloning of Ora11g_gridinfrahome1_2 was successful.

Please check ‘/u01/app/oraInventory/logs/cloneActions2014-10-14_07-41-33AM.log’ for more details.

 

 

下面查看一下新环境是否增加到inventory.xml文件中

[grid@11rac1 ContentsXML]$ cat inventory.xml

<?xml version="1.0" standalone="yes" ?>

<!– Copyright (c) 1999, 2011, Oracle. All rights reserved. –>

<!– Do not modify the contents of this file by hand. –>

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>11.2.0.3.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="Ora11g_gridinfrahome1" LOC="/u01/app/11.2.0/grid" TYPE="O" IDX="1" CRS="true">

   <NODE_LIST>

      <NODE NAME="11rac1"/>

      <NODE NAME="11rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraDb11g_home1" LOC="/u01/app/oracle/product/11.2.0/db_1" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="11rac1"/>

      <NODE NAME="11rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="Ora11g_gridinfrahome1_2" LOC="/u01/app/11.2.0/grid_2" TYPE="O" IDX="3">

   <NODE_LIST>

      <NODE NAME="11rac1"/>

      <NODE NAME="11rac2"/>

   </NODE_LIST>

</HOME>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>

2.3 升级新GRID目录

这里采用了AUTO的方式自动升级,这里需要注意在OPATCH的时候,增加上-oh参数,指定新GRID目录

[root@11rac1 grid]# /u01/app/11.2.0/grid_2/OPatch/opatch auto /tmp/patch/ -ocmrf /tmp/ocm.rsp  -oh /u01/app/11.2.0/grid_2/

Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid_2/OPatch/crs/patch11203.pl -patchdir /tmp -patchn patch -ocmrf /tmp/ocm.rsp -oh /u01/app/11.2.0/grid_2/ -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

 

This is the main log file: /u01/app/11.2.0/grid_2/cfgtoollogs/opatchauto2014-10-14_08-01-07.log

 

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/u01/app/11.2.0/grid_2/cfgtoollogs/opatchauto2014-10-14_08-01-07.report.log

 

2014-10-14 08:01:07: Starting Clusterware Patch Setup

Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

 

Stopping RAC /u01/app/11.2.0/grid_2 …

Stopped RAC /u01/app/11.2.0/grid_2 successfully

 

patch /tmp/patch/17592127/custom/server/17592127  apply successful for home  /u01/app/11.2.0/grid_2

patch /tmp/patch/18031683  apply successful for home  /u01/app/11.2.0/grid_2

 

Starting RAC /u01/app/11.2.0/grid_2 …

Started RAC /u01/app/11.2.0/grid_2 successfully

 

opatch auto succeeded.

3 升级ORACLE目录

 

3.1 创建ORACLE目录与复制软件

这里我使用的root用户执行的,MOS文件使用的ORACLE用户执行,但是会报几个文件错误,属主root

[root@11rac1 ~]# export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_2

[root@11rac1 ~]# cd /u01/app/oracle/product/11.2.0/db_1/

[root@11rac1 db_1]# tar cpf – . | ( cd $ORACLE_HOME ; tar xf -)

3.2 克隆ORACLE目录

[root@11rac1 db_1]# su – oracle

[oracle@11rac1 ~]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_2

[oracle@11rac1 ~]$ cd $ORACLE_HOME/clone/bin

[oracle@11rac1 bin]$ ./clone.pl ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME=OraDB_home2 ORACLE_BASE=/u01/app/oracle

 

./runInstaller -clone -waitForCompletion  "ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_2" "ORACLE_HOME_NAME=OraDB_home2" "ORACLE_BASE=/u01/app/oracle" -silent -noConfig -nowait

Starting Oracle Universal Installer…

 

Checking swap space: must be greater than 500 MB.   Actual 3999 MB    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-10-14_09-25-55AM. Please wait …Oracle Universal Installer, Version 11.2.0.3.0 Production

Copyright (C) 1999, 2011, Oracle. All rights reserved.

 

You can find the log of this install session at:

 /u01/app/oraInventory/logs/cloneActions2014-10-14_09-25-55AM.log

………………………………………………………………………………………. 100% Done.

 

 

 

Installation in progress (Monday, October 13, 2014 6:26:07 PM PDT)

…………………………………………………………………….                                                 79% Done.

Install successful

 

Linking in progress (Monday, October 13, 2014 6:26:12 PM PDT)

Link successful

 

Setup in progress (Monday, October 13, 2014 6:26:52 PM PDT)

Setup successful

 

End of install phases.(Monday, October 13, 2014 6:27:15 PM PDT)

WARNING:

The following configuration scripts need to be executed as the "root" user.

/u01/app/oracle/product/11.2.0/db_2/root.sh

To execute the configuration scripts:

    1. Open a terminal window

    2. Log in as "root"

    3. Run the scripts

   

The cloning of OraDB_home2 was successful.

Please check ‘/u01/app/oraInventory/logs/cloneActions2014-10-14_09-25-55AM.log’ for more details.

[oracle@11rac1 bin]$ exit

logout

[root@11rac1 db_1]# /u01/app/oracle/product/11.2.0/db_2/root.sh

Check /u01/app/oracle/product/11.2.0/db_2/install/root_11rac1_2014-10-14_09-27-39.log for the output of root script

[oracle@11rac1 ~]$ $ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={11rac1,11rac2}" -silent  -noClusterEnabled CRS=false local_node=11rac1

Starting Oracle Universal Installer…

 

Checking swap space: must be greater than 500 MB.   Actual 3995 MB    Passed

The inventory pointer is located at /etc/oraInst.loc

The inventory is located at /u01/app/oraInventory

‘UpdateNodeList’ was successful.

 

 

 

[grid@11rac1 ContentsXML]$ cat inventory.xml

<?xml version="1.0" standalone="yes" ?>

<!– Copyright (c) 1999, 2011, Oracle. All rights reserved. –>

<!– Do not modify the contents of this file by hand. –>

<INVENTORY>

<VERSION_INFO>

   <SAVED_WITH>11.2.0.3.0</SAVED_WITH>

   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="Ora11g_gridinfrahome1" LOC="/u01/app/11.2.0/grid" TYPE="O" IDX="1" CRS="true">

   <NODE_LIST>

      <NODE NAME="11rac1"/>

      <NODE NAME="11rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraDb11g_home1" LOC="/u01/app/oracle/product/11.2.0/db_1" TYPE="O" IDX="2">

   <NODE_LIST>

      <NODE NAME="11rac1"/>

      <NODE NAME="11rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="Ora11g_gridinfrahome1_2" LOC="/u01/app/11.2.0/grid_2" TYPE="O" IDX="3">

   <NODE_LIST>

      <NODE NAME="11rac1"/>

      <NODE NAME="11rac2"/>

   </NODE_LIST>

</HOME>

<HOME NAME="OraDB_home2" LOC="/u01/app/oracle/product/11.2.0/db_2" TYPE="O" IDX="4">

   <NODE_LIST>

      <NODE NAME="11rac1"/>

      <NODE NAME="11rac2"/>

   </NODE_LIST>

</HOME>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>

3.3 升级新ORACLE目录

[root@11rac1 db_1]# /u01/app/oracle/product/11.2.0/db_2/OPatch/opatch auto /tmp/patch -oh /u01/app/oracle/product/11.2.0/db_2 -ocmrf /tmp/ocm.rsp

Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/oracle/product/11.2.0/db_2/OPatch/crs/patch11203.pl -patchdir /tmp -patchn patch -oh /u01/app/oracle/product/11.2.0/db_2 -ocmrf /tmp/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

 

This is the main log file: /u01/app/oracle/product/11.2.0/db_2/cfgtoollogs/opatchauto2014-10-14_09-33-34.log

 

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/u01/app/oracle/product/11.2.0/db_2/cfgtoollogs/opatchauto2014-10-14_09-33-34.report.log

 

2014-10-14 09:33:34: Starting Clusterware Patch Setup

Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

 

Stopping RAC /u01/app/oracle/product/11.2.0/db_2 …

Stopped RAC /u01/app/oracle/product/11.2.0/db_2 successfully

 

patch /tmp/patch/17592127/custom/server/17592127  apply successful for home  /u01/app/oracle/product/11.2.0/db_2

patch /tmp/patch/18031683  apply successful for home  /u01/app/oracle/product/11.2.0/db_2

 

Starting RAC /u01/app/oracle/product/11.2.0/db_2 …

Started RAC /u01/app/oracle/product/11.2.0/db_2 successfully

 

opatch auto succeeded.

4 2节点操作

另一个节点的操作步骤与1节点相同,这里就不写了

5 切换GRID到新目录

手动停数据库与相同的服务

[oracle@11rac1 ~]$ /u01/app/oracle/product/11.2.0/db_1/bin/srvctl stop home -o /u01/app/oracle/product/11.2.0/db_1 -n 11rac1  -s /tmp/11rac1.txt

[oracle@11rac2 ~]$ /u01/app/oracle/product/11.2.0/db_1/bin/srvctl stop home -o /u01/app/oracle/product/11.2.0/db_1 -n 11rac2  -s /tmp/11rac2.txt

 

[grid@11rac1 ~]$ su – grid

Password:

[grid@11rac1 ~]$ crsctl stat resource -t

——————————————————————————–

NAME           TARGET  STATE        SERVER                   STATE_DETAILS      

——————————————————————————–

Local Resources

——————————————————————————–

ora.CRS.dg

               ONLINE  ONLINE       11rac1                                      

               ONLINE  ONLINE       11rac2                                      

ora.DATA.dg

               ONLINE  ONLINE       11rac1                                      

               ONLINE  ONLINE       11rac2                                      

ora.LISTENER.lsnr

               ONLINE  ONLINE       11rac1                                      

               ONLINE  ONLINE       11rac2                                      

ora.asm

               ONLINE  ONLINE       11rac1                   Started            

               ONLINE  ONLINE       11rac2                   Started            

ora.gsd

               OFFLINE OFFLINE      11rac1                                      

               OFFLINE OFFLINE      11rac2                                      

ora.net1.network

               ONLINE  ONLINE       11rac1                                      

               ONLINE  ONLINE       11rac2                                      

ora.ons

               ONLINE  ONLINE       11rac1                                      

               ONLINE  ONLINE       11rac2                                      

——————————————————————————–

Cluster Resources

——————————————————————————–

ora.11rac1.vip

      1        ONLINE  ONLINE       11rac1                                      

ora.11rac2.vip

      1        ONLINE  ONLINE       11rac2                                      

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       11rac1                                      

ora.cvu

      1        ONLINE  ONLINE       11rac2                                      

ora.oc4j

      1        ONLINE  ONLINE       11rac1                                      

ora.power.db

      1        OFFLINE OFFLINE                               Instance Shutdown  

      2        OFFLINE OFFLINE                               Instance Shutdown  

ora.power.power1.svc

      1        OFFLINE OFFLINE                                                  

ora.power.power2.svc

      1        OFFLINE OFFLINE                                                  

ora.power.powera.svc

      1        OFFLINE OFFLINE                                                  

ora.power.powerb.svc

      1        OFFLINE OFFLINE                                                  

ora.scan1.vip

      1        ONLINE  ONLINE       11rac1   

这里看到GRID还正常运行的

patch11203.pl脚本会自动停GRID并修改切换文件,切换到新目录环境

[root@11rac1 utl]#  /usr/bin/perl /u01/app/11.2.0/grid_2/OPatch/crs/patch11203.pl -patch -desthome=/u01/app/11.2.0/grid_2

 

This is the main log file: /u01/app/11.2.0/grid_2/cfgtoollogs/opatchauto2014-10-14_19-10-19.log

 

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/u01/app/11.2.0/grid_2/cfgtoollogs/opatchauto2014-10-14_19-10-19.report.log

 

2014-10-14 19:10:19: Starting Clusterware Patch Setup

Using configuration parameter file: /u01/app/11.2.0/grid_2/crs/install/crsconfig_params

CRS-4544: Unable to connect to OHAS

CRS-4000: Command Stop failed, or completed with errors.

CRS-4123: Oracle High Availability Services has been started.

 

 

[root@11rac1 utl]# ps -ef|grep css

root     11401     1  0 19:10 ?        00:00:00 /u01/app/11.2.0/grid_2/bin/cssdmonitor

root     11421     1  0 19:10 ?        00:00:00 /u01/app/11.2.0/grid_2/bin/cssdagent

grid     11435     1  1 19:10 ?        00:00:01 /u01/app/11.2.0/grid_2/bin/ocssd.bin

这里可以看到节点1的新目录,节点2是旧目录,但是GRID仍是正常运行的,说明GRID可以支持两个ORACLE_HOME可以不一致                                  

下面看一看节点2运行patch11203.pl脚本的详细输出

[root@11rac2 grid]# /usr/bin/perl /u01/app/11.2.0/grid_2/OPatch/crs/patch11203.pl -patch -desthome=/u01/app/11.2.0/grid_2

 

This is the main log file: /u01/app/11.2.0/grid_2/cfgtoollogs/opatchauto2014-10-14_19-16-26.log

 

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/u01/app/11.2.0/grid_2/cfgtoollogs/opatchauto2014-10-14_19-16-26.report.log

 

2014-10-14 19:16:26: Starting Clusterware Patch Setup

Using configuration parameter file: /u01/app/11.2.0/grid_2/crs/install/crsconfig_params

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.oc4j’ 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.DATA.dg’ on ’11rac2′

CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN1.lsnr’ on ’11rac2′

CRS-2673: Attempting to stop ‘ora.LISTENER.lsnr’ on ’11rac2′

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.LISTENER.lsnr’ on ’11rac2′ succeeded

CRS-2673: Attempting to stop ‘ora.11rac2.vip’ on ’11rac2′

CRS-2677: Stop of ‘ora.scan1.vip’ on ’11rac2′ succeeded

CRS-2672: Attempting to start ‘ora.scan1.vip’ on ’11rac1′

CRS-2677: Stop of ‘ora.11rac2.vip’ on ’11rac2′ succeeded

CRS-2672: Attempting to start ‘ora.11rac2.vip’ on ’11rac1′

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.11rac2.vip’ on ’11rac1′ succeeded

CRS-2676: Start of ‘ora.LISTENER_SCAN1.lsnr’ on ’11rac1′ succeeded

CRS-2677: Stop of ‘ora.oc4j’ on ’11rac2′ succeeded

CRS-2672: Attempting to start ‘ora.oc4j’ on ’11rac1′

CRS-2677: Stop of ‘ora.cvu’ on ’11rac2′ succeeded

CRS-2672: Attempting to start ‘ora.cvu’ on ’11rac1′

CRS-2676: Start of ‘ora.cvu’ on ’11rac1′ succeeded

CRS-2676: Start of ‘ora.oc4j’ 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.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.crf’ 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-2673: Attempting to stop ‘ora.mdnsd’ on ’11rac2′

CRS-2677: Stop of ‘ora.crf’ on ’11rac2′ succeeded

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

CRS-4123: Oracle High Availability Services has been started.

 

 

[root@11rac2 cfgtoollogs]# cat /u01/app/11.2.0/grid_2/cfgtoollogs/opatchauto2014-10-14_19-16-26.log

2014-10-14 19:16:26: Using Oracle CRS home /u01/app/11.2.0/grid_2

2014-10-14 19:16:26: Checking parameters from paramfile /u01/app/11.2.0/grid_2/crs/install/crsconfig_params to validate installer variables

2014-10-14 19:16:26: The configuration parameter file /u01/app/11.2.0/grid_2/crs/install/crsconfig_params is valid

2014-10-14 19:16:26: ### Printing the configuration values from files:

2014-10-14 19:16:26:    /u01/app/11.2.0/grid_2/crs/install/crsconfig_params

2014-10-14 19:16:26:    /u01/app/11.2.0/grid/crs/install/s_crsconfig_defs

2014-10-14 19:16:26: ASM_AU_SIZE=1

2014-10-14 19:16:26: ASM_DISCOVERY_STRING=

2014-10-14 19:16:26: ASM_DISKS=

2014-10-14 19:16:26: ASM_DISK_GROUP=

2014-10-14 19:16:26: ASM_REDUNDANCY=

2014-10-14 19:16:26: ASM_SPFILE=

2014-10-14 19:16:26: ASM_UPGRADE=false

2014-10-14 19:16:26: CLSCFG_MISSCOUNT=

2014-10-14 19:16:26: CLUSTER_GUID=

2014-10-14 19:16:26: CLUSTER_NAME=

2014-10-14 19:16:26: CRFHOME="/u01/app/11.2.0/grid_2"

2014-10-14 19:16:26: CRS_LIMIT_CORE=unlimited

2014-10-14 19:16:26: CRS_LIMIT_MEMLOCK=unlimited

2014-10-14 19:16:26: CRS_LIMIT_OPENFILE=65536

2014-10-14 19:16:26: CRS_LIMIT_STACK=2048

2014-10-14 19:16:26: CRS_NODEVIPS=

2014-10-14 19:16:26: CRS_STORAGE_OPTION=0

2014-10-14 19:16:26: CSS_LEASEDURATION=400

2014-10-14 19:16:26: DIRPREFIX=

2014-10-14 19:16:26: DISABLE_OPROCD=0

2014-10-14 19:16:26: EXTERNAL_ORACLE=/opt/oracle

2014-10-14 19:16:26: EXTERNAL_ORACLE_BIN=/opt/oracle/bin

2014-10-14 19:16:26: GNS_ADDR_LIST=

2014-10-14 19:16:26: GNS_ALLOW_NET_LIST=

2014-10-14 19:16:26: GNS_CONF=false

2014-10-14 19:16:26: GNS_DENY_ITF_LIST=

2014-10-14 19:16:26: GNS_DENY_NET_LIST=

2014-10-14 19:16:26: GNS_DOMAIN_LIST=

2014-10-14 19:16:26: GPNPCONFIGDIR=/u01/app/11.2.0/grid_2

2014-10-14 19:16:26: GPNPGCONFIGDIR=/u01/app/11.2.0/grid_2

2014-10-14 19:16:26: GPNP_PA=

2014-10-14 19:16:26: HOST_NAME_LIST=

2014-10-14 19:16:26: ID=/etc/init.d

2014-10-14 19:16:26: INIT=/sbin/init

2014-10-14 19:16:26: INITCTL=/sbin/initctl

2014-10-14 19:16:26: ISROLLING=true

2014-10-14 19:16:26: IT=/etc/inittab

2014-10-14 19:16:26: JLIBDIR=/u01/app/11.2.0/grid_2/jlib

2014-10-14 19:16:26: JREDIR=/u01/app/11.2.0/grid_2/jdk/jre/

2014-10-14 19:16:26: LANGUAGE_ID=AMERICAN_AMERICA.AL32UTF8

2014-10-14 19:16:26: MSGFILE=/var/adm/messages

2014-10-14 19:16:26: NETWORKS=

2014-10-14 19:16:26: NEW_HOST_NAME_LIST=

2014-10-14 19:16:26: NEW_NODEVIPS=

2014-10-14 19:16:26: NEW_NODE_NAME_LIST=

2014-10-14 19:16:26: NEW_PRIVATE_NAME_LIST=

2014-10-14 19:16:26: NODELIST=

2014-10-14 19:16:26: NODE_NAME_LIST=

2014-10-14 19:16:26: OCFS_CONFIG=

2014-10-14 19:16:26: OCRCONFIG=/etc/oracle/ocr.loc

2014-10-14 19:16:26: OCRCONFIGDIR=/etc/oracle

2014-10-14 19:16:26: OCRID=

2014-10-14 19:16:26: OCRLOC=ocr.loc

2014-10-14 19:16:26: OCR_LOCATIONS=

2014-10-14 19:16:26: OLASTGASPDIR=/etc/oracle/lastgasp

2014-10-14 19:16:26: OLD_CRS_HOME=

2014-10-14 19:16:26: OLRCONFIG=/etc/oracle/olr.loc

2014-10-14 19:16:26: OLRCONFIGDIR=/etc/oracle

2014-10-14 19:16:26: OLRLOC=olr.loc

2014-10-14 19:16:26: OPROCDCHECKDIR=/etc/oracle/oprocd/check

2014-10-14 19:16:26: OPROCDDIR=/etc/oracle/oprocd

2014-10-14 19:16:26: OPROCDFATALDIR=/etc/oracle/oprocd/fatal

2014-10-14 19:16:26: OPROCDSTOPDIR=/etc/oracle/oprocd/stop

2014-10-14 19:16:26: ORACLE_BASE=/u01/app/grid

2014-10-14 19:16:26: ORACLE_HOME=/u01/app/11.2.0/grid_2

2014-10-14 19:16:26: ORACLE_OWNER=grid

2014-10-14 19:16:26: ORA_ASM_GROUP=dba

2014-10-14 19:16:26: ORA_DBA_GROUP=dba

2014-10-14 19:16:26: PRIVATE_NAME_LIST=

2014-10-14 19:16:26: RCALLDIR=/etc/rc.d/rc0.d /etc/rc.d/rc1.d /etc/rc.d/rc2.d /etc/rc.d/rc3.d /etc/rc.d/rc4.d /etc/rc.d/rc5.d /etc/rc.d/rc6.d

2014-10-14 19:16:26: RCKDIR=/etc/rc.d/rc0.d /etc/rc.d/rc1.d /etc/rc.d/rc2.d /etc/rc.d/rc3.d /etc/rc.d/rc4.d /etc/rc.d/rc6.d

2014-10-14 19:16:26: RCSDIR=/etc/rc.d/rc3.d /etc/rc.d/rc5.d

2014-10-14 19:16:26: RC_KILL=K15

2014-10-14 19:16:26: RC_KILL_OLD=K96

2014-10-14 19:16:26: RC_KILL_OLD2=K19

2014-10-14 19:16:26: RC_START=S96

2014-10-14 19:16:26: REUSEDG=false

2014-10-14 19:16:26: SCAN_NAME=

2014-10-14 19:16:26: SCAN_PORT=0

2014-10-14 19:16:26: SCRBASE=/etc/oracle/scls_scr

2014-10-14 19:16:26: SILENT=true

2014-10-14 19:16:26: SO_EXT=so

2014-10-14 19:16:26: SRVCFGLOC=srvConfig.loc

2014-10-14 19:16:26: SRVCONFIG=/var/opt/oracle/srvConfig.loc

2014-10-14 19:16:26: SRVCONFIGDIR=/var/opt/oracle

2014-10-14 19:16:26: TZ=Asia/Shanghai

2014-10-14 19:16:26: UPSTART_INIT_DIR=/etc/init

2014-10-14 19:16:26: USER_IGNORED_PREREQ=true

2014-10-14 19:16:26: VNDR_CLUSTER=false

2014-10-14 19:16:26: VOTING_DISKS=

2014-10-14 19:16:26: ### Printing other configuration values ###

2014-10-14 19:16:26: CLSCFG_EXTRA_PARMS=

2014-10-14 19:16:26: HAS_GROUP=dba

2014-10-14 19:16:26: HAS_USER=root

2014-10-14 19:16:26: HOST=11rac2

2014-10-14 19:16:26: OLR_DIRECTORY=/u01/app/11.2.0/grid_2/cdata

2014-10-14 19:16:26: OLR_LOCATION=/u01/app/11.2.0/grid_2/cdata/11rac2.olr

2014-10-14 19:16:26: ORA_CRS_HOME=/u01/app/11.2.0/grid_2

2014-10-14 19:16:26: SUPERUSER=root

2014-10-14 19:16:26: VF_DISCOVERY_STRING=

2014-10-14 19:16:26: crscfg_trace=1

2014-10-14 19:16:26: crscfg_trace_file=/u01/app/11.2.0/grid_2/cfgtoollogs/opatchauto2014-10-14_19-16-26.log

2014-10-14 19:16:26: hosts=

2014-10-14 19:16:26: osdfile=/u01/app/11.2.0/grid/crs/install/s_crsconfig_defs

2014-10-14 19:16:26: parameters_valid=1

2014-10-14 19:16:26: paramfile=/u01/app/11.2.0/grid_2/crs/install/crsconfig_params

2014-10-14 19:16:26: platform_family=unix

2014-10-14 19:16:26: srvctl_trc_suff=0

2014-10-14 19:16:26: user_is_superuser=1

2014-10-14 19:16:26: ### Printing of configuration values complete ###

2014-10-14 19:16:26: Executing /u01/app/11.2.0/grid/bin/crsctl stop crs -f

2014-10-14 19:16:26: Executing cmd: /u01/app/11.2.0/grid/bin/crsctl stop crs -f

2014-10-14 19:18:28: Command output:

>  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.oc4j’ 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.DATA.dg’ on ’11rac2′

>  CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN1.lsnr’ on ’11rac2′

>  CRS-2673: Attempting to stop ‘ora.LISTENER.lsnr’ on ’11rac2′

>  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.LISTENER.lsnr’ on ’11rac2′ succeeded

>  CRS-2673: Attempting to stop ‘ora.11rac2.vip’ on ’11rac2′

>  CRS-2677: Stop of ‘ora.scan1.vip’ on ’11rac2′ succeeded

>  CRS-2672: Attempting to start ‘ora.scan1.vip’ on ’11rac1′

>  CRS-2677: Stop of ‘ora.11rac2.vip’ on ’11rac2′ succeeded

>  CRS-2672: Attempting to start ‘ora.11rac2.vip’ on ’11rac1′

>  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.11rac2.vip’ on ’11rac1′ succeeded

>  CRS-2676: Start of ‘ora.LISTENER_SCAN1.lsnr’ on ’11rac1′ succeeded

>  CRS-2677: Stop of ‘ora.oc4j’ on ’11rac2′ succeeded

>  CRS-2672: Attempting to start ‘ora.oc4j’ on ’11rac1′

>  CRS-2677: Stop of ‘ora.cvu’ on ’11rac2′ succeeded

>  CRS-2672: Attempting to start ‘ora.cvu’ on ’11rac1′

>  CRS-2676: Start of ‘ora.cvu’ on ’11rac1′ succeeded

>  CRS-2676: Start of ‘ora.oc4j’ 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.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.crf’ 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-2673: Attempting to stop ‘ora.mdnsd’ on ’11rac2′

>  CRS-2677: Stop of ‘ora.crf’ on ’11rac2′ succeeded

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

>End Command output

2014-10-14 19:18:28: /u01/app/11.2.0/grid/bin/crsctl stop crs -f

2014-10-14 19:18:28: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:18:30: Command output:

>  CRS-4639: Could not contact Oracle High Availability Services

>  CRS-4000: Command Check failed, or completed with errors.

>End Command output

2014-10-14 19:18:30: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check has

2014-10-14 19:18:32: Command output:

>  CRS-4639: Could not contact Oracle High Availability Services

>End Command output

2014-10-14 19:18:32: Validating /etc/oracle/olr.loc file for OLR location /u01/app/11.2.0/grid_2/cdata/11rac2.olr

2014-10-14 19:18:32: /etc/oracle/olr.loc already exists. Backing up /etc/oracle/olr.loc to /etc/oracle/olr.loc.orig

2014-10-14 19:18:32: Done setting permissions on file /etc/oracle/olr.loc

2014-10-14 19:18:32: 11.2 CHM upgrade actions are already performed

2014-10-14 19:18:32: Patching Oracle Clusterware

2014-10-14 19:18:32: norestart flag is set to 0

2014-10-14 19:18:32: Checking if OCR is on ASM

2014-10-14 19:18:32: Retrieving OCR main disk location

2014-10-14 19:18:32: Opening file /etc/oracle/ocr.loc

2014-10-14 19:18:32: Value (+CRS) is set for key=ocrconfig_loc

2014-10-14 19:18:32: Retrieving OCR mirror disk location

2014-10-14 19:18:32: Opening file /etc/oracle/ocr.loc

2014-10-14 19:18:32: Value () is set for key=ocrmirrorconfig_loc

2014-10-14 19:18:32: Retrieving OCR loc3 disk location

2014-10-14 19:18:32: Opening file /etc/oracle/ocr.loc

2014-10-14 19:18:32: Value () is set for key=ocrconfig_loc3

2014-10-14 19:18:32: Retrieving OCR loc4 disk location

2014-10-14 19:18:32: Opening file /etc/oracle/ocr.loc

2014-10-14 19:18:32: Value () is set for key=ocrconfig_loc4

2014-10-14 19:18:32: Retrieving OCR loc5 disk location

2014-10-14 19:18:32: Opening file /etc/oracle/ocr.loc

2014-10-14 19:18:32: Value () is set for key=ocrconfig_loc5

2014-10-14 19:18:32: Executing cmd: /u01/app/11.2.0/grid_2/bin/acfsdriverstate supported

2014-10-14 19:18:32: Command output:

>  ACFS-9459: ADVM/ACFS is not supported on this OS version: ‘2.6.32-300.10.1.el5uek’

>  ACFS-9201: Not Supported

>End Command output

2014-10-14 19:18:32: acfs is not supported

2014-10-14 19:18:32: Starting Oracle Clusterware

2014-10-14 19:18:32: Executing /u01/app/11.2.0/grid_2/bin/crsctl start crs

2014-10-14 19:18:32: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl start crs

2014-10-14 19:18:40: Command output:

>  CRS-4123: Oracle High Availability Services has been started.

>End Command output

2014-10-14 19:18:40: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check crs

2014-10-14 19:18:40: Command output:

>  CRS-4638: Oracle High Availability Services is online

>  CRS-4535: Cannot communicate with Cluster Ready Services

>  CRS-4530: Communications failure contacting Cluster Synchronization Services daemon

>  CRS-4534: Cannot communicate with Event Manager

>End Command output

2014-10-14 19:18:40: Running /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:18:40: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:18:40: Checking the status of cluster

2014-10-14 19:18:45: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:18:45: Checking the status of cluster

2014-10-14 19:18:50: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:18:50: Checking the status of cluster

2014-10-14 19:18:55: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:18:55: Checking the status of cluster

2014-10-14 19:19:00: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:19:00: Checking the status of cluster

2014-10-14 19:19:05: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:19:05: Checking the status of cluster

2014-10-14 19:19:10: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:19:10: Checking the status of cluster

2014-10-14 19:19:15: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:19:15: Checking the status of cluster

2014-10-14 19:19:20: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:19:20: Checking the status of cluster

2014-10-14 19:19:25: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:19:25: Checking the status of cluster

2014-10-14 19:19:30: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:19:30: Checking the status of cluster

2014-10-14 19:19:35: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:19:35: Checking the status of cluster

2014-10-14 19:19:40: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:19:41: Checking the status of cluster

2014-10-14 19:19:46: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:19:46: Checking the status of cluster

2014-10-14 19:19:51: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:19:51: Checking the status of cluster

2014-10-14 19:19:56: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:19:56: Checking the status of cluster

2014-10-14 19:20:01: Executing cmd: /u01/app/11.2.0/grid_2/bin/crsctl check cluster -n 11rac2

2014-10-14 19:20:01: Oracle CRS stack installed and running

6 切换DATABASE到新目录

需要修改一下ORACLE_HOME的路径,在一个节点改就可以了

[oracle@11rac1 ~]$ srvctl modify database -d power -o /u01/app/oracle/product/11.2.0/db_2

[oracle@11rac1 ~]$ srvctl config database -d power -a

Database unique name: power

Database name: power

Oracle home: /u01/app/oracle/product/11.2.0/db_2

Oracle user: oracle

Spfile: +DATA/power/spfilepower.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: power

Database instances: power1,power2

Disk Groups: DATA

Mount point paths:

Services: power1,power2,powera,powerb

Type: RAC

Database is enabled

 

Database is administrator managed

修改两个节点的/etc/oratab文件,如下

[grid@11rac1 ~]$ tail -2 /etc/oratab

+ASM1:/u01/app/11.2.0/grid_2:N          # line added by Agent

power:/u01/app/oracle/product/11.2.0/db_2:N             # line added by Agent

 

启动之前停止的资源

[oracle@11rac1 ~]$ srvctl start home -o $ORACLE_HOME -n  11rac1 -s /tmp/11rac1.txt

 

 

[root@11rac1 ~]# su – grid

[grid@11rac1 ~]$ crsctl stat resource -t

——————————————————————————–

NAME           TARGET  STATE        SERVER                   STATE_DETAILS      

——————————————————————————–

Local Resources

——————————————————————————–

ora.CRS.dg

               ONLINE  ONLINE       11rac1                                      

               ONLINE  ONLINE       11rac2                                      

ora.DATA.dg

               ONLINE  ONLINE       11rac1                                      

               ONLINE  ONLINE       11rac2                                      

ora.LISTENER.lsnr

               ONLINE  ONLINE       11rac1                                      

               ONLINE  ONLINE       11rac2                                      

ora.asm

               ONLINE  ONLINE       11rac1                   Started            

               ONLINE  ONLINE       11rac2                   Started            

ora.gsd

               OFFLINE OFFLINE      11rac1                                      

               OFFLINE OFFLINE      11rac2                                      

ora.net1.network

               ONLINE  ONLINE       11rac1                                      

               ONLINE  ONLINE       11rac2                                      

ora.ons

               ONLINE  ONLINE       11rac1                                      

               ONLINE  ONLINE       11rac2                                      

——————————————————————————–

Cluster Resources

——————————————————————————–

ora.11rac1.vip

      1        ONLINE  ONLINE       11rac1                                      

ora.11rac2.vip

      1        ONLINE  ONLINE       11rac2                                      

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       11rac1                                      

ora.cvu

      1        ONLINE  ONLINE       11rac1                                      

ora.oc4j

      1        ONLINE  ONLINE       11rac1                                      

ora.power.db

      1        ONLINE  ONLINE       11rac1                   Open               

      2        ONLINE  ONLINE       11rac2                   Open               

ora.power.power1.svc

      1        ONLINE  ONLINE       11rac1                                      

ora.power.power2.svc

      1        ONLINE  ONLINE       11rac1                                      

ora.power.powera.svc

      1        ONLINE  ONLINE       11rac1                                      

ora.power.powerb.svc

      1        ONLINE  ONLINE       11rac1                                      

ora.scan1.vip

      1        ONLINE  ONLINE       11rac1

 

查看一下版本    

[grid@11rac1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches

18031683;Database Patch Set Update : 11.2.0.3.10 (18031683)

17592127;Grid Infrastructure Patch Set Update : 11.2.0.3.9 (HAS Components)

 

 

[oracle@11rac1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches

18031683;Database Patch Set Update : 11.2.0.3.10 (18031683)

17592127;Grid Infrastructure Patch Set Update : 11.2.0.3.9 (HAS Components)

7,更新数据字典

更新数据字典略,见滚动升级文档

本文固定链接: http://www.htz.pw/2014/10/14/%e6%9c%80%e5%b0%8f%e5%81%9c%e6%9c%ba%e6%97%b6%e9%97%b4%ef%bc%9a%e7%bb%99griddb%e6%89%93psu%e8%a1%a5%e4%b8%81%e6%88%96%e8%80%85update.html | 认真就输

该日志由 huangtingzhong 于2014年10月14日发表在 BACKUP & RESTORE 分类下, 通告目前不可用,你可以至底部留下评论。
原创文章转载请注明: 最小停机时间:给GRID/DB打PSU补丁或者UPDATE | 认真就输
关键字: , , , , ,