• 快速升级Oracle 11.2.0.2 RAC到11.2.0.3


    11.2.0.3 补丁集在美国时间9月23日发布了,关于11.2.0.3 发布的更多信息可以参考<Oracle 11gR2发布11.2.0.3 Patchset补丁集-又一重量级更新>一文。 这里我们来快速浏览由11.2.0.2 RAC升级到11.2.0.3的过程: 在正式升级GI/CRS之前需要先打上"Patch 12539000: 11203:ASM UPGRADE FAILED ON FIRST NODE WITH ORA-03113" 我们仅需要针对GI/CRS打上补丁,无需在RDBMS/DB上实施。该Patch可以滚动升级Rolling upgrade, 简易的实施流程如下:  
    1. 在所有节点上安装最新的opatch工具,该步骤不需要停止任何服务
    
    [root@vrh1 ~]# su - grid
    [grid@vrh1 ~]$ cd $CRS_HOME
    [grid@vrh1 grid]$ mv OPatch OPatch_old
    
    [grid@vrh1 grid]$ unzip /tmp/p6880880_112000_Linux-x86-64.zip -d $CRS_HOME
    
    [grid@vrh1 grid]$ opatch
    Invoking OPatch 11.2.0.1.3
    
    Oracle Interim Patch Installer version 11.2.0.1.3
    Copyright (c) 2010, Oracle Corporation.  All rights reserved.
    
    2. 解压之前下载的 p12539000_112020_Linux-x86-64.zip 的补丁包,!!注意不要解压在/tmp目录下!!
    
    [grid@vrh1 ~]$ mkdir /g01/patch
    
    [grid@vrh1 ~]$ cd /g01/patch
    
    [grid@vrh1 patch]$ unzip /tmp/p12539000_112020_Linux-x86-64.zip
    
    Archive:  /tmp/p12539000_112020_Linux-x86-64.zip
       creating: 12539000/
       creating: 12539000/files/
       creating: 12539000/files/lib/
       creating: 12539000/files/lib/libserver11.a/
      inflating: 12539000/files/lib/libserver11.a/ksxp.o  
       creating: 12539000/etc/
       creating: 12539000/etc/config/
      inflating: 12539000/etc/config/inventory.xml  
      inflating: 12539000/etc/config/actions.xml  
      inflating: 12539000/etc/config/deploy.xml  
       creating: 12539000/etc/xml/
      inflating: 12539000/etc/xml/GenericActions.xml  
      inflating: 12539000/etc/xml/ShiphomeDirectoryStructure.xml 
    
    3. 以root用户执行# opatch auto <UNZIPPED_PATCH_LOCATION> 命令
    
    [root@vrh1 ~]# /g01/11.2.0/grid/OPatch/opatch auto /g01/patch -oh $CRS_HOME
    
    Executing /usr/bin/perl /g01/11.2.0/grid/OPatch/crs/patch112.pl -patchdir /g01 -patchn patch -oh
    /g01/11.2.0/grid -paramfile /g01/11.2.0/grid/crs/install/crsconfig_params
    2011-09-24 22:34:41: Parsing the host name
    2011-09-24 22:34:41: Checking for super user privileges
    2011-09-24 22:34:41: User has super user privileges
    Using configuration parameter file: /g01/11.2.0/grid/crs/install/crsconfig_params
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'vrh1'
    CRS-2673: Attempting to stop 'ora.crsd' on 'vrh1'
    CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'vrh1'
    CRS-2673: Attempting to stop 'ora.FRA.dg' on 'vrh1'
    ................................
    Backing up files affected by the patch 'NApply' for restore. This might take a while...
    
    Applying patch 12539000...
    
    ApplySession applying interim patch '12539000' to OH '/g01/11.2.0/grid'
    Backing up files affected by the patch '12539000' for rollback. This might take a while...
    
    Patching component oracle.rdbms, 11.2.0.2.0...
    Updating archive file "/g01/11.2.0/grid/lib/libserver11.a"  with "lib/libserver11.a/ksxp.o"
    ApplySession adding interim patch '12539000' to inventory
    
    Verifying the update...
    Inventory check OK: Patch ID 12539000 is registered in Oracle Home inventory with proper meta-data.
    Files check OK: Files from Patch ID 12539000 are present in Oracle Home.
    Running make for target ioracle
    
    The local system has been patched and can be restarted.
    
    UtilSession: N-Apply done.
    
    OPatch succeeded.
    CRS-4123: Oracle High Availability Services has been started.
    
    4. 在所有节点上重复以上步骤,并确认补丁状态
    
    [root@vrh1 ~]# su - grid
    
    [grid@vrh1 ~]$ opatch lsinventory
    Interim patches (1) :
    
    Patch  12539000     : applied on Sat Sep 24 22:36:35 CST 2011
    Unique Patch ID:  13976979
       Created on 28 Jul 2011, 12:37:42 hrs PST8PDT
       Bugs fixed:
         12539000
      如果没有安装以上12539000补丁,在使用OUI升级GI/CRS时会出现以下 Warning:   11.2.0.3_12539000_bug   升级11.2.0.2 GI/CRS到11.2.0.3 1.解压软件包,第三个zip包为grid软件 [grid@vrh1 tmp]$ unzip p10404530_112030_Linux-x86-64_3of7.zip 2. 以GI拥有者用户启动GI/CRS的OUI安装界面,并选择Out of Place的安装目录 (grid)$ unset ORACLE_HOME ORACLE_BASE ORACLE_SID (grid)$ export DISPLAY=:0 (grid)$ cd  /tmp/grid (grid)$ ./runInstaller Starting Oracle Universal Installer… upgrade_11.2.0.3_GI_1   upgrade_11.2.0.3_GI_2   upgrade_11.2.0.3_GI_3   upgrade_11.2.0.3_GI_4   upgrade_11.2.0.3_GI_5   upgrade_11.2.0.3_GI_6   upgrade_11.2.0.3_GI_8   upgrade_11.2.0.3_GI_9   upgrade_11.2.0.3_GI_10   upgrade_11.2.0.3_GI_11   3. 依次在所有节点上以root用户运行rootupgrade.sh升级脚本  
    su - root 
    
    First Node [root@vrh1 ~]# /g01/11.2.0.3/grid/rootupgrade.sh
    
    Performing root user operation for Oracle 11g 
    
    The following environment variables are set as:
        ORACLE_OWNER= grid
        ORACLE_HOME=  /g01/11.2.0.3/grid
    
    Enter the full pathname of the local bin directory: [/usr/local/bin]:
    The contents of "dbhome" have not changed. No need to overwrite.
    The contents of "oraenv" have not changed. No need to overwrite.
    The contents of "coraenv" have not changed. No need to overwrite.
    
    Entries will be added to the /etc/oratab file as needed by
    Database Configuration Assistant when a database is created
    Finished running generic part of root script.
    Now product-specific root actions will be performed.
    Using configuration parameter file: /g01/11.2.0.3/grid/crs/install/crsconfig_params
    Creating trace directory
    User ignored Prerequisites during installation
    
    ASM upgrade has started on first node.
    
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'vrh1'
    CRS-2673: Attempting to stop 'ora.crsd' on 'vrh1'
    CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'vrh1'
    CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'vrh1'
    CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'vrh1'
    CRS-2673: Attempting to stop 'ora.oc4j' on 'vrh1'
    CRS-2673: Attempting to stop 'ora.FRA.dg' on 'vrh1'
    CRS-2673: Attempting to stop 'ora.MACLEAN.dg' on 'vrh1'
    CRS-2673: Attempting to stop 'ora.registry.acfs' on 'vrh1'
    CRS-2673: Attempting to stop 'ora.SYSTEMDG.dg' on 'vrh1'
    CRS-2673: Attempting to stop 'ora.cvu' on 'vrh1'
    CRS-2677: Stop of 'ora.cvu' on 'vrh1' succeeded
    CRS-2672: Attempting to start 'ora.cvu' on 'vrh2'
    CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'vrh1' succeeded
    CRS-2673: Attempting to stop 'ora.scan1.vip' on 'vrh1'
    CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'vrh1' succeeded
    CRS-2673: Attempting to stop 'ora.vrh1.vip' on 'vrh1'
    CRS-2677: Stop of 'ora.scan1.vip' on 'vrh1' succeeded
    CRS-2672: Attempting to start 'ora.scan1.vip' on 'vrh2'
    CRS-2677: Stop of 'ora.vrh1.vip' on 'vrh1' succeeded
    CRS-2672: Attempting to start 'ora.vrh1.vip' on 'vrh2'
    CRS-2677: Stop of 'ora.registry.acfs' on 'vrh1' succeeded
    CRS-2676: Start of 'ora.scan1.vip' on 'vrh2' succeeded
    CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'vrh2'
    CRS-2676: Start of 'ora.cvu' on 'vrh2' succeeded
    CRS-2676: Start of 'ora.vrh1.vip' on 'vrh2' succeeded
    CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'vrh2' succeeded
    CRS-2677: Stop of 'ora.MACLEAN.dg' on 'vrh1' succeeded
    CRS-2677: Stop of 'ora.FRA.dg' on 'vrh1' succeeded
    CRS-2677: Stop of 'ora.oc4j' on 'vrh1' succeeded
    CRS-2672: Attempting to start 'ora.oc4j' on 'vrh2'
    CRS-2676: Start of 'ora.oc4j' on 'vrh2' succeeded
    CRS-2677: Stop of 'ora.SYSTEMDG.dg' on 'vrh1' succeeded
    CRS-2673: Attempting to stop 'ora.asm' on 'vrh1'
    CRS-2677: Stop of 'ora.asm' on 'vrh1' succeeded
    CRS-2673: Attempting to stop 'ora.ons' on 'vrh1'
    CRS-2677: Stop of 'ora.ons' on 'vrh1' succeeded
    CRS-2673: Attempting to stop 'ora.net1.network' on 'vrh1'
    CRS-2677: Stop of 'ora.net1.network' on 'vrh1' succeeded
    CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'vrh1' has completed
    CRS-2677: Stop of 'ora.crsd' on 'vrh1' succeeded
    CRS-2673: Attempting to stop 'ora.ctssd' on 'vrh1'
    CRS-2673: Attempting to stop 'ora.evmd' on 'vrh1'
    CRS-2673: Attempting to stop 'ora.asm' on 'vrh1'
    CRS-2673: Attempting to stop 'ora.mdnsd' on 'vrh1'
    CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'vrh1'
    CRS-2677: Stop of 'ora.asm' on 'vrh1' succeeded
    CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'vrh1'
    CRS-2677: Stop of 'ora.evmd' on 'vrh1' succeeded
    CRS-2677: Stop of 'ora.mdnsd' on 'vrh1' succeeded
    CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'vrh1' succeeded
    CRS-2677: Stop of 'ora.ctssd' on 'vrh1' succeeded
    CRS-2673: Attempting to stop 'ora.cssd' on 'vrh1'
    CRS-2677: Stop of 'ora.cssd' on 'vrh1' succeeded
    CRS-2673: Attempting to stop 'ora.diskmon' on 'vrh1'
    CRS-2673: Attempting to stop 'ora.gipcd' on 'vrh1'
    CRS-2677: Stop of 'ora.gipcd' on 'vrh1' succeeded
    CRS-2673: Attempting to stop 'ora.gpnpd' on 'vrh1'
    CRS-2677: Stop of 'ora.gpnpd' on 'vrh1' succeeded
    CRS-2677: Stop of 'ora.drivers.acfs' on 'vrh1' succeeded
    CRS-2677: Stop of 'ora.diskmon' on 'vrh1' succeeded
    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'vrh1' has completed
    CRS-4133: Oracle High Availability Services has been stopped.
    OLR initialization - successful
    Replacing Clusterware entries in 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
    
    Last Node 
    
    [root@vrh2 ~]# /g01/11.2.0.3/grid/rootupgrade.sh
    
    Performing root user operation for Oracle 11g 
    
    The following environment variables are set as:
        ORACLE_OWNER= grid
        ORACLE_HOME=  /g01/11.2.0.3/grid
    
    Enter the full pathname of the local bin directory: [/usr/local/bin]:
    The contents of "dbhome" have not changed. No need to overwrite.
    The contents of "oraenv" have not changed. No need to overwrite.
    The contents of "coraenv" have not changed. No need to overwrite.
    
    Entries will be added to the /etc/oratab file as needed by
    Database Configuration Assistant when a database is created
    Finished running generic part of root script.
    Now product-specific root actions will be performed.
    Using configuration parameter file: /g01/11.2.0.3/grid/crs/install/crsconfig_params
    Creating trace directory
    User ignored Prerequisites during installation
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'vrh2'
    CRS-2673: Attempting to stop 'ora.crsd' on 'vrh2'
    CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'vrh2'
    CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'vrh2'
    CRS-2673: Attempting to stop 'ora.registry.acfs' on 'vrh2'
    CRS-2673: Attempting to stop 'ora.SYSTEMDG.dg' on 'vrh2'
    CRS-2673: Attempting to stop 'ora.oc4j' on 'vrh2'
    CRS-2673: Attempting to stop 'ora.cvu' on 'vrh2'
    CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'vrh2'
    CRS-2677: Stop of 'ora.cvu' on 'vrh2' succeeded
    CRS-2672: Attempting to start 'ora.cvu' on 'vrh1'
    CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'vrh2' succeeded
    CRS-2673: Attempting to stop 'ora.vrh2.vip' on 'vrh2'
    CRS-2677: Stop of 'ora.vrh2.vip' on 'vrh2' succeeded
    CRS-2672: Attempting to start 'ora.vrh2.vip' on 'vrh1'
    CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'vrh2' succeeded
    CRS-2673: Attempting to stop 'ora.scan1.vip' on 'vrh2'
    CRS-2677: Stop of 'ora.scan1.vip' on 'vrh2' succeeded
    CRS-2672: Attempting to start 'ora.scan1.vip' on 'vrh1'
    CRS-2676: Start of 'ora.cvu' on 'vrh1' succeeded
    CRS-2677: Stop of 'ora.registry.acfs' on 'vrh2' succeeded
    CRS-2676: Start of 'ora.vrh2.vip' on 'vrh1' succeeded
    CRS-2676: Start of 'ora.scan1.vip' on 'vrh1' succeeded
    CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'vrh1'
    CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'vrh1' succeeded
    CRS-2677: Stop of 'ora.oc4j' on 'vrh2' succeeded
    CRS-2672: Attempting to start 'ora.oc4j' on 'vrh1'
    CRS-2676: Start of 'ora.oc4j' on 'vrh1' succeeded
    CRS-2677: Stop of 'ora.SYSTEMDG.dg' on 'vrh2' succeeded
    CRS-2673: Attempting to stop 'ora.asm' on 'vrh2'
    CRS-2677: Stop of 'ora.asm' on 'vrh2' succeeded
    CRS-2673: Attempting to stop 'ora.ons' on 'vrh2'
    CRS-2677: Stop of 'ora.ons' on 'vrh2' succeeded
    CRS-2673: Attempting to stop 'ora.net1.network' on 'vrh2'
    CRS-2677: Stop of 'ora.net1.network' on 'vrh2' succeeded
    CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'vrh2' has completed
    CRS-2677: Stop of 'ora.crsd' on 'vrh2' succeeded
    CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'vrh2'
    CRS-2673: Attempting to stop 'ora.ctssd' on 'vrh2'
    CRS-2673: Attempting to stop 'ora.evmd' on 'vrh2'
    CRS-2673: Attempting to stop 'ora.asm' on 'vrh2'
    CRS-2673: Attempting to stop 'ora.mdnsd' on 'vrh2'
    CRS-2677: Stop of 'ora.asm' on 'vrh2' succeeded
    CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'vrh2'
    CRS-2677: Stop of 'ora.evmd' on 'vrh2' succeeded
    CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'vrh2' succeeded
    CRS-2677: Stop of 'ora.mdnsd' on 'vrh2' succeeded
    CRS-2677: Stop of 'ora.ctssd' on 'vrh2' succeeded
    CRS-2673: Attempting to stop 'ora.cssd' on 'vrh2'
    CRS-2677: Stop of 'ora.cssd' on 'vrh2' succeeded
    CRS-2673: Attempting to stop 'ora.diskmon' on 'vrh2'
    CRS-2673: Attempting to stop 'ora.gipcd' on 'vrh2'
    CRS-2677: Stop of 'ora.gipcd' on 'vrh2' succeeded
    CRS-2673: Attempting to stop 'ora.gpnpd' on 'vrh2'
    CRS-2677: Stop of 'ora.diskmon' on 'vrh2' succeeded
    CRS-2677: Stop of 'ora.drivers.acfs' on 'vrh2' succeeded
    CRS-2677: Stop of 'ora.gpnpd' on 'vrh2' succeeded
    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'vrh2' has completed
    CRS-4133: Oracle High Availability Services has been stopped.
    OLR initialization - successful
    Replacing Clusterware entries in 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.
    Started to upgrade the CSS.
    Started to upgrade the CRS.
    The CRS was successfully upgraded.
    Oracle Clusterware operating version was successfully set to 11.2.0.3.0
    
    ASM upgrade has finished on last node.
    
    PRKO-2116 : OC4J is already enabled
    Configure Oracle Grid Infrastructure for a Cluster ... succeeded
      4. 确认GI/CRS成功升级到11.2.0.3 :  
    [grid@vrh2 ~]$ crsctl query crs activeversion
    Oracle Clusterware active version on the cluster is [11.2.0.3.0]
        升级11.2.0.2 RDBMS/DB到 11.2.0.3   1. 解压RDBMS/DB 相关的第1-2个 zip包:  
    [root@vrh1 ~]# su - oracle
    [oracle@vrh1 tmp]$ mkdir /s01/patch
    [oracle@vrh1 tmp]$ cd /s01/patch
    
    [oracle@vrh1 patch]$ unzip /tmp/p10404530_112030_Linux-x86-64_1of7.zip
    [oracle@vrh1 patch]$ unzip /tmp/p10404530_112030_Linux-x86-64_2of7.zip
      2. 因为11.2.0.2的Patchset以后都是out of place的,所以我们可以不用像在11gr2以前那样必须在原有安装低版本软件的基础上才能升级软件,而可以选择在别的位置完全新安装。 注意该步骤不需要停止数据库实例,可以在前期工作中完成。 以DB/RDBMS数据库软件的拥有者身份(oracle用户)启动方才解压目录下的oui安装界面: su - oracle (oracle)$ unset ORACLE_HOME ORACLE_BASE ORACLE_SID (oracle)$ export DISPLAY=:0 (oracle)$ cd $PATCHHOME (oracle)$ ./runInstaller   upgrade_11.2.0.3_DB_1   upgrade_11.2.0.3_DB_2   upgrade_11.2.0.3_DB_3   upgrade_11.2.0.3_DB_4   upgrade_11.2.0.3_DB_5   upgrade_11.2.0.3_DB_6   upgrade_11.2.0.3_DB_7   upgrade_11.2.0.3_DB_8   依次在所有节点上执行root.sh脚本 /s01/orabase/product/11.2.0/dbhome_3/root.sh   3. 使用DBUA静默模式升级RAC数据库的数据字典  
    su - oracle
    [oracle@vrh1 ~]$ export ORACLE_HOME=/s01/orabase/product/11.2.0/dbhome_3
    
    /*  这里的SID指定数据库名 */
    
    [oracle@vrh1 ~]$ $ORACLE_HOME/bin/dbua -silent -sid VPROD
    
    Log files for the upgrade operation are located at: /s01/orabase/cfgtoollogs/dbua/VPROD/upgrade2
    Performing Pre Upgrade
    1% complete
    7% complete
    Upgrading Oracle Server
    9% complete
    10% complete
    12% complete
    13% complete
    15% complete
    16% complete
    18% complete
    20% complete
    21% complete
    23% complete
    24% complete
    26% complete
    27% complete
    29% complete
    30% complete
    32% complete
    33% complete
    35% complete
    36% complete
    Upgrading Real Application Clusters
    38% complete
    Upgrading Oracle Workspace Manager
    40% complete
    41% complete
    43% complete
    44% complete
    Performing Post Upgrade
    46% complete
    84% complete
    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 "/s01/orabase/cfgtoollogs/dbua/logs/silent1.log" for upgrade details.
    4.更新所有节点上.bash_profile 中的ORACLE_HOME等变量   5.执行过DBUA升级工具的节点上的orapw$SID密码文件已被更新,将该文件传播到其他节点上   6.确认数据字典升级成功,并重启所有实例
    SQL> col comp_name for a40
    SQL> col version for a20
    SQL> set linesize 140 pagesize 1200
    SQL> select comp_name,version from dba_server_registry;
    
    COMP_NAME                                VERSION
    ---------------------------------------- --------------------
    Oracle Workspace Manager                 11.2.0.3.0
    Oracle Database Catalog Views            11.2.0.3.0
    Oracle Database Packages and Types       11.2.0.3.0
    Oracle Real Application Clusters         11.2.0.3.0
    
    SQL> 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
    
    SQL> select * from global_name;
    
    GLOBAL_NAME
    --------------------------------------------------
    www.oracledatabase12g.com & www.askmaclean.com
    
    [oracle@vrh1 dbs]$ opatch lsinventory
    Invoking OPatch 11.2.0.1.7
    
    Oracle Interim Patch Installer version 11.2.0.1.7
    Copyright (c) 2011, Oracle Corporation.  All rights reserved.
    
    Oracle Home       : /s01/orabase/product/11.2.0/dbhome_3
    Central Inventory : /g01/oraInventory
       from           : /etc/oraInst.loc
    OPatch version    : 11.2.0.1.7
    OUI version       : 11.2.0.3.0
    Log file location : /s01/orabase/product/11.2.0/dbhome_3/cfgtoollogs/opatch/opatch2011-09-25_00-18-57AM.log
    
    Lsinventory Output file location : /s01/orabase/product/11.2.0/dbhome_3/cfgtoollogs/opatch
    /lsinv/lsinventory2011-09-25_00-18-57AM.txt
    
    --------------------------------------------------------------------------------
    Installed Top-level Products (1): 
    
    Oracle Database 11g                                                  11.2.0.3.0
    There are 1 products installed in this Oracle Home.
    
    There are no Interim patches installed in this Oracle Home.
    
    Rac system comprising of multiple nodes
      Local node = vrh1
      Remote node = vrh2
    
    [oracle@vrh1 dbs]$ sqlplus  / as sysdba
    
    SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 25 00:19:14 2011
    
    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> shutdown immediate;
    
    SQL> startup ;
    ORACLE instance started.
    
    Total System Global Area 1252663296 bytes
    Fixed Size                  2227944 bytes
    Variable Size             402653464 bytes
    Database Buffers          838860800 bytes
    Redo Buffers                8921088 bytes
    Database mounted.
    Database opened.
      11.2.0.3上optimizer_features_enable造成的一些变化   我们知道几乎每个Patchset都会引入Oracle Optimizer优化器的一些微妙变化,升级到11.2.0.3后默认的optimizer_features_enable(OFE)为11.2.0.3,我们来了解一下这与11.2.0.2时有哪些区别:
    SQL> col PARAMETER for a30
    SQL> col "11.2.0.3" for a20
    SQL> col  "11.2.0.2" for a20
    SQL> col DESCRIB for a50
    SQL> set linesize 200 
    
    SQL> select V11203.NAME    Parameter,
      2         V11203.VALUE   "11.2.0.3",
      3         V11202.VALUE   "11.2.0.2",
      4         V11203.describ
      5    from ofe_11203 V11203, ofe_11202 V11202
      6   where V11203.NAME = V11202.NAME
      7     and V11203.VALUE != V11202.VALUE;
    
    PARAMETER                      11.2.0.3             11.2.0.2             DESCRIB
    ------------------------------ -------------------- -------------------- --------------------------------------------------
    _fastpin_enable                241174785            404585473            enable reference count based fast pins
    _db_flash_cache_keep_limit     241098320            404509008            Flash cache keep buffer upper limit in percentage
    optimizer_features_enable      11.2.0.3             11.2.0.2             optimizer plan compatibility parameter
    _optimizer_undo_cost_change    11.2.0.3             11.2.0.2             optimizer undo cost change
  • 相关阅读:
    hive分区学习
    pyspark的学习
    往hive表中插入数据以及导出数据
    【Pytest学习3】setup和teardown简单用法,fixture里面的scope等于setup,用yield等于teardown
    【Pytest学习2】 pytest用例设计规则,terminal中使用常见命令行参数,pycharm中使用常见的命令行参数
    Jmeter响应内容显示乱码问题的解决办法
    Jmeter(三)测试计划和线程组
    Jmeter(二)Jmeter目录介绍 & 元件介绍
    JMeter之Ramp-up Period(in seconds)说明
    badboy云盘下载链接
  • 原文地址:https://www.cnblogs.com/macleanoracle/p/2968015.html
Copyright © 2020-2023  润新知