手机版
你好,游客 登录 注册
背景:
阅读新闻

Oracle 11gR2 硬件导致重新添加节点

[日期:2017-01-09] 来源:CSDN  作者:吴伟龙 [字体: ]

二十、执行addNode.sh将节点一添加至RAC:

  1. [grid@oradb2 bin]$ cd $Oracle_HOME/oui/bin
  2. [grid@oradb2 bin]$ ls
  3. addLangs.sh* attachHome.sh* filesList.bat* filesList.sh* resource/ runInstaller* runSSHSetup.sh*
  4. addNode.sh* detachHome.sh* filesList.properties* lsnodes* runConfig.sh* runInstaller.sh*
  5. [grid@oradb2 bin]$ ./addNode.sh "CLUSTER_NEW_NODES={oradb1}"
  6.  
  7. ./addNode.sh -
  8. silent "CLUSTER_NEW_NODES={oradb1}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={oradb1-vip}" "CLUSTER_NEW_PRIVATE_NODE_NAMES={oradb1-priv}"
  9.  
  10.  
  11. 执行 添加节点 的预检查
  12.  
  13. ERROR:
  14. PRVF-7610 : 无法在现有集群节点上验证等同用户/可访问性
  15. 验证无法继续
  16.  
  17. #在所有节点上预检查 添加节点 失败。
  18. [grid@oradb2 bin]$ export IGNORE_PREADDNODE_CHECKS=Y
  19. [grid@oradb2 bin]$ ./addNode.sh -silent "CLUSTER_NEW_NODES={oradb1}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={oradb1-vip}" "CLUSTER_NEW_PRIVATE_NODE_NAMES={oradb1-priv}"
  20.  
  21.  
  22. ./addNode.sh "CLUSTER_NEW_NODES={oadb1};
  23.  
  24. 2.节点1上grid用户执行
  25. $ORACLE_HOME/oui/bin/addNode.sh "CLUSTER_NEW_NODES={rac2}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac2-vip}


 一些无关紧要的小问题检查不通过,在图形界面安装时是可以忽略的,这里是不能直接忽略的,需要修改一下addNode.sh文件

  1. #!/bin/sh
  2. OHOME=/u01/app/11.2.0/grid
  3. INVPTRLOC=$OHOME/oraInst.loc
  4. EXIT_CODE=0
  5. ADDNODE="$OHOME/oui/bin/runInstaller -addNode -invPtrLoc $INVPTRLOC ORACLE_HOME=$OHOME $*"
  6. if [ "$IGNORE_PREADDNODE_CHECKS" = "Y" -o ! -f "$OHOME/cv/cvutl/check_nodeadd.pl" ]
  7. then
  8.         $ADDNODE
  9.         EXIT_CODE=$?;
  10. else
  11.         CHECK_NODEADD="$OHOME/perl/bin/perl $OHOME/cv/cvutl/check_nodeadd.pl -pre ORACLE_HOME=$OHOME $*"
  12.         $CHECK_NODEADD
  13.         EXIT_CODE=$?;
  14. <span style="color:#ff0000;">EXIT_CODE=0 ##在这里添加一行,用于忽略一些小错误</span>
  15.         if [ $EXIT_CODE -eq 0 ]
  16.         then
  17.                 $ADDNODE
  18.                 EXIT_CODE=$?;
  19.         fi
  20. fi
  21. exit $EXIT_CODE ;

     #重新执行

  1. [grid@oradb2 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=/opt/app/11.2.0/grid "CLUSTER_NODES={oradb2}"
  2. 正在启动 Oracle Universal Installer...
  3.  
  4. 检查交换空间: 必须大于 500 MB。 实际为 3002 MB 通过
  5. The inventory pointer is located at /etc/oraInst.loc
  6. The inventory is located at /opt/app/oraInventory
  7. 'UpdateNodeList' 成功。
  1. [grid@oradb2 bin]$ export IGNORE_PREADDNODE_CHECKS=Y
  2. [grid@oradb2 bin]$ ./addNode.sh -silent "CLUSTER_NEW_NODES={oradb1}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={oradb1-vip}" "CLUSTER_NEW_PRIVATE_NODE_NAMES={oradb1-priv}"
  3. 正在启动 Oracle Universal Installer...
  4.  
  5. 检查交换空间: 必须大于 500 MB。 实际为 3001 MB 通过
  6. Oracle Universal Installer, 版本 11.2.0.3.0 Production
  7. 版权所有 (c) 1999, 2011, Oracle。保留所有权利。
  8.  
  9.  
  10. 执行测试以检查节点 oradb1 是否可用
  11. ............................................................... 100% 已完成。
  12.  
  13. .
  14. -----------------------------------------------------------------------------
  15. 添加集群节点概要
  16. 全局设置
  17.    源: /opt/app/11.2.0/grid
  18.    新节点
  19. 空间要求
  20.    新节点
  21.       oradb1
  22.          /opt: 要求空间 6.06GB: 可用空间 44.68GB
  23. 已安装产品
  24.    产品名
  25.       Oracle Grid Infrastructure 11.2.0.3.0
  26.       Sun JDK 1.5.0.30.03
  27.       Installer SDK Component 11.2.0.3.0
  28.       Oracle One-Off Patch Installer 11.2.0.1.7
  29.       Oracle Universal Installer 11.2.0.3.0
  30.       Oracle USM Deconfiguration 11.2.0.3.0
  31.       Oracle Configuration Manager Deconfiguration 10.3.1.0.0
  32.       Enterprise Manager Common Core Files 10.2.0.4.4
  33.       Oracle DBCA Deconfiguration 11.2.0.3.0
  34.       Oracle RAC Deconfiguration 11.2.0.3.0
  35.       Oracle Quality of Service Management (Server) 11.2.0.3.0
  36.       Installation Plugin Files 11.2.0.3.0
  37.       Universal Storage Manager Files 11.2.0.3.0
  38.       Oracle Text Required Support Files 11.2.0.3.0
  39.       Automatic Storage Management Assistant 11.2.0.3.0
  40.       Oracle Database 11g Multimedia Files 11.2.0.3.0
  41.       Oracle Multimedia Java Advanced Imaging 11.2.0.3.0
  42.       Oracle Globalization Support 11.2.0.3.0
  43.       Oracle Multimedia Locator RDBMS Files 11.2.0.3.0
  44.       Oracle Core Required Support Files 11.2.0.3.0
  45.       Bali Share 1.1.18.0.0
  46.       Oracle Database Deconfiguration 11.2.0.3.0
  47.       Oracle Quality of Service Management (Client) 11.2.0.3.0
  48.       Expat libraries 2.0.1.0.1
  49.       Oracle Containers for Java 11.2.0.3.0
  50.       Perl Modules 5.10.0.0.1
  51.       Secure Socket Layer 11.2.0.3.0
  52.       Oracle JDBC/OCI Instant Client 11.2.0.3.0
  53.       Oracle Multimedia Client Option 11.2.0.3.0
  54.       LDAP Required Support Files 11.2.0.3.0
  55.       Character Set Migration Utility 11.2.0.3.0
  56.       Perl Interpreter 5.10.0.0.2
  57.       PL/SQL Embedded Gateway 11.2.0.3.0
  58.       OLAP SQL Scripts 11.2.0.3.0
  59.       Database SQL Scripts 11.2.0.3.0
  60.       Oracle Extended Windowing Toolkit 3.4.47.0.0
  61.       SSL Required Support Files for InstantClient 11.2.0.3.0
  62.       SQL*Plus Files for Instant Client 11.2.0.3.0
  63.       Oracle Net Required Support Files 11.2.0.3.0
  64.       Oracle Database User Interface 2.2.13.0.0
  65.       RDBMS Required Support Files for Instant Client 11.2.0.3.0
  66.       RDBMS Required Support Files Runtime 11.2.0.3.0
  67.       XML Parser for Java 11.2.0.3.0
  68.       Oracle Security Developer Tools 11.2.0.3.0
  69.       Oracle Wallet Manager 11.2.0.3.0
  70.       Enterprise Manager plugin Common Files 11.2.0.3.0
  71.       Platform Required Support Files 11.2.0.3.0
  72.       Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
  73.       RDBMS Required Support Files 11.2.0.3.0
  74.       Oracle Ice Browser 5.2.3.6.0
  75.       Oracle Help For Java 4.2.9.0.0
  76.       Enterprise Manager Common Files 10.2.0.4.3
  77.       Deinstallation Tool 11.2.0.3.0
  78.       Oracle Java Client 11.2.0.3.0
  79.       Cluster Verification Utility Files 11.2.0.3.0
  80.       Oracle Notification Service (eONS) 11.2.0.3.0
  81.       Oracle LDAP administration 11.2.0.3.0
  82.       Cluster Verification Utility Common Files 11.2.0.3.0
  83.       Oracle Clusterware RDBMS Files 11.2.0.3.0
  84.       Oracle Locale Builder 11.2.0.3.0
  85.       Oracle Globalization Support 11.2.0.3.0
  86.       Buildtools Common Files 11.2.0.3.0
  87.       Oracle RAC Required Support Files-HAS 11.2.0.3.0
  88.       SQL*Plus Required Support Files 11.2.0.3.0
  89.       XDK Required Support Files 11.2.0.3.0
  90.       Agent Required Support Files 10.2.0.4.3
  91.       Parser Generator Required Support Files 11.2.0.3.0
  92.       Precompiler Required Support Files 11.2.0.3.0
  93.       Installation Common Files 11.2.0.3.0
  94.       Required Support Files 11.2.0.3.0
  95.       Oracle JDBC/THIN Interfaces 11.2.0.3.0
  96.       Oracle Multimedia Locator 11.2.0.3.0
  97.       Oracle Multimedia 11.2.0.3.0
  98.       HAS Common Files 11.2.0.3.0
  99.       Assistant Common Files 11.2.0.3.0
  100.       PL/SQL 11.2.0.3.0
  101.       HAS Files for DB 11.2.0.3.0
  102.       Oracle Recovery Manager 11.2.0.3.0
  103.       Oracle Database Utilities 11.2.0.3.0
  104.       Oracle Notification Service 11.2.0.3.0
  105.       SQL*Plus 11.2.0.3.0
  106.       Oracle Netca Client 11.2.0.3.0
  107.       Oracle Net 11.2.0.3.0
  108.       Oracle JVM 11.2.0.3.0
  109.       Oracle Internet Directory Client 11.2.0.3.0
  110.       Oracle Net Listener 11.2.0.3.0
  111.       Cluster Ready Services Files 11.2.0.3.0
  112.       Oracle Database 11g 11.2.0.3.0
  113. -----------------------------------------------------------------------------
  114.  
  115.  
  116. 实例化脚本以添加节点 (2016年12月25日 星期日 上午04时17分04秒 CST)
  117. . 1% 已完成。
  118. 实例化添加节点脚本完成
  119.  
  120. 复制到远程节点 (2016年12月25日 星期日 上午04时17分08秒 CST)
  121. ............................................................................................... 96% 已完成。
  122. 主目录已复制到新节点
  123.  
  124. 在节点上保存产品清单 (2016年12月25日 星期日 上午04时30分51秒 CST)
  125. . 100% 已完成。
  126. 保存产品清单完成
  127. WARNING:
  128. 以下配置脚本需要以各个新集群节点中的 "root" 用户的身份执行。以下列表中的每个脚本后面跟随一个节点列表。
  129. /opt/app/11.2.0/grid/root.sh #On nodes oradb1
  130. 要执行配置脚本, 请执行以下操作:
  131.     1. 打开终端窗口
  132.     2."root" 身份登录
  133.     3. 在每个集群节点中运行脚本
  134.      
  135. /opt/app/11.2.0/grid 的 添加集群节点 已成功。
  136. 请查看 '/tmp/silentInstall.log' 以获取详细资料。

    #在节点一执行root脚本:

  1. [root@oradb1 app]# /opt/app/11.2.0/grid/root.sh
  2. Performing root user operation for Oracle 11g
  3.  
  4. The following environment variables are set as:
  5.     ORACLE_OWNER= grid
  6.     ORACLE_HOME= /opt/app/11.2.0/grid
  7.  
  8. Enter the full pathname of the local bin directory: [/usr/local/bin]:
  9. The contents of "dbhome" have not changed. No need to overwrite.
  10. The contents of "oraenv" have not changed. No need to overwrite.
  11. The contents of "coraenv" have not changed. No need to overwrite.
  12.  
  13. Entries will be added to the /etc/oratab file as needed by
  14. Database Configuration Assistant when a database is created
  15. Finished running generic part of root script.
  16. Now product-specific root actions will be performed.
  17. Using configuration parameter file: /opt/app/11.2.0/grid/crs/install/crsconfig_params
  18. Creating trace directory
  19. OLR initialization - successful
  20. Adding Clusterware entries to inittab
  21. CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node oradb2, number 2, and is terminating
  22. An active cluster was found during exclusive startup, restarting to join the cluster
  23. clscfg: EXISTING configuration version 5 detected.
  24. clscfg: version 5 is 11g Release 2.
  25. Successfully accumulated necessary OCR keys.
  26. Creating OCR keys for user 'root', privgrp 'root'..
  27. Operation successful.
  28. Configure Oracle Grid Infrastructure for a Cluster ... succeeded

 

二十一:检查添加后的集群节点是否正确:

  1. [grid@oradb1 ~]$ crsctl check cluster -all
  2. **************************************************************
  3. oradb1:
  4. CRS-4537: Cluster Ready Services is online
  5. CRS-4529: Cluster Synchronization Services is online
  6. CRS-4533: Event Manager is online
  7. **************************************************************
  8. oradb2:
  9. CRS-4537: Cluster Ready Services is online
  10. CRS-4529: Cluster Synchronization Services is online
  11. CRS-4533: Event Manager is online
  12. **************************************************************
  1. [grid@oradb1 ~]$ crsctl stat res -t
  2. --------------------------------------------------------------------------------
  3. NAME TARGET STATE SERVER STATE_DETAILS
  4. --------------------------------------------------------------------------------
  5. Local Resources
  6. --------------------------------------------------------------------------------
  7. ora.DATACRS.dg
  8.                ONLINE ONLINE oradb1
  9.                ONLINE ONLINE oradb2
  10. ora.DATAVOL1.dg
  11.                ONLINE ONLINE oradb1
  12.                ONLINE ONLINE oradb2
  13. ora.FRAVOL1.dg
  14.                ONLINE ONLINE oradb1
  15.                ONLINE ONLINE oradb2
  16. ora.LISTENER.lsnr
  17.                ONLINE ONLINE oradb1
  18.                ONLINE ONLINE oradb2
  19. ora.asm
  20.                ONLINE ONLINE oradb1 Started
  21.                ONLINE ONLINE oradb2 Started
  22. ora.gsd
  23.                OFFLINE OFFLINE oradb1
  24.                OFFLINE OFFLINE oradb2
  25. ora.net1.network
  26.                ONLINE ONLINE oradb1
  27.                ONLINE ONLINE oradb2
  28. ora.ons
  29.                ONLINE ONLINE oradb1
  30.                ONLINE ONLINE oradb2
  31. ora.registry.acfs
  32.                ONLINE ONLINE oradb1
  33.                ONLINE ONLINE oradb2
  34. --------------------------------------------------------------------------------
  35. Cluster Resources
  36. --------------------------------------------------------------------------------
  37. ora.LISTENER_SCAN1.lsnr
  38.       1 ONLINE ONLINE oradb2
  39. ora.cvu
  40.       1 ONLINE ONLINE oradb2
  41. ora.oc4j
  42.       1 ONLINE ONLINE oradb2
  43. ora.oradb1.vip
  44.       1 ONLINE ONLINE oradb1
  45. ora.oradb2.vip
  46.       1 ONLINE ONLINE oradb2
  47. ora.scan1.vip
  48.       1 ONLINE ONLINE oradb2
  49. ora.tjtvdb.db
  50.       2 ONLINE ONLINE oradb2 Open
  1. [root@oradb1 app]# ps -ef|grep asm|grep -v grep
  2. grid 23133 1 0 04:36 ? 00:00:00 asm_pmon_+ASM1
  3. grid 23135 1 0 04:36 ? 00:00:00 asm_psp0_+ASM1
  4. grid 23137 1 0 04:36 ? 00:00:00 asm_vktm_+ASM1
  5. grid 23141 1 0 04:36 ? 00:00:00 asm_gen0_+ASM1
  6. grid 23143 1 0 04:36 ? 00:00:00 asm_diag_+ASM1
  7. grid 23145 1 0 04:36 ? 00:00:00 asm_ping_+ASM1
  8. grid 23147 1 0 04:36 ? 00:00:00 asm_dia0_+ASM1
  9. grid 23149 1 0 04:36 ? 00:00:00 asm_lmon_+ASM1
  10. grid 23151 1 0 04:36 ? 00:00:00 asm_lmd0_+ASM1
  11. grid 23153 1 0 04:36 ? 00:00:00 asm_lms0_+ASM1
  12. grid 23157 1 0 04:36 ? 00:00:00 asm_lmhb_+ASM1
  13. grid 23159 1 0 04:36 ? 00:00:00 asm_mman_+ASM1
  14. grid 23161 1 0 04:36 ? 00:00:00 asm_dbw0_+ASM1
  15. grid 23163 1 0 04:36 ? 00:00:00 asm_lgwr_+ASM1
  16. grid 23165 1 0 04:36 ? 00:00:00 asm_ckpt_+ASM1
  17. grid 23167 1 0 04:36 ? 00:00:00 asm_smon_+ASM1
  18. grid 23169 1 0 04:36 ? 00:00:00 asm_rbal_+ASM1
  19. grid 23171 1 0 04:36 ? 00:00:00 asm_gmon_+ASM1
  20. grid 23173 1 0 04:36 ? 00:00:00 asm_mmon_+ASM1
  21. grid 23175 1 0 04:36 ? 00:00:00 asm_mmnl_+ASM1
  22. grid 23177 1 0 04:36 ? 00:00:00 asm_lck0_+ASM1
  23. grid 23215 1 0 04:36 ? 00:00:00 asm_asmb_+ASM1
  24. grid 23217 1 0 04:36 ? 00:00:00 oracle+ASM1_asmb_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  25. grid 23219 1 0 04:36 ? 00:00:00 asm_o000_+ASM1
  26. grid 23221 1 0 04:36 ? 00:00:00 oracle+ASM1_o000_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  1. [grid@oradb2 bin]$ crs_stat -t -v -c oradb1
  2. Name Type R/RA F/FT Target State Host
  3. ----------------------------------------------------------------------
  4. ora.DATACRS.dg ora....up.type 0/5 0/ ONLINE ONLINE oradb1
  5. ora....VOL1.dg ora....up.type 0/5 0/ ONLINE ONLINE oradb1
  6. ora.FRAVOL1.dg ora....up.type 0/5 0/ ONLINE ONLINE oradb1
  7. ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE oradb1
  8. ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE oradb1
  9. ora....network ora....rk.type 0/5 0/ ONLINE ONLINE oradb1
  10. ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE oradb1
  11. ora....SM1.asm application 0/5 0/0 ONLINE ONLINE oradb1
  12. ora....B1.lsnr application 0/5 0/0 ONLINE ONLINE oradb1
  13. ora.oradb1.ons application 0/3 0/0 ONLINE ONLINE oradb1
  14. ora.oradb1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE oradb1
  15. ora....ry.acfs ora....fs.type 0/5 0/ ONLINE ONLINE oradb1


二十一、通过addNode.sh添加数据库软件:

  1. [oracle@oradb2 bin]$ cd $ORACLE_HOME/oui/bin
  2. [oracle@oradb2 bin]$ ./addNode.sh "CLUSTER_NEW_NODES={oradb1}"
  3.  
  4. 执行 添加节点 的预检查
  5.  
  6. 正在检查节点的可访问性...
  7. 节点 "oradb2" 的节点可访问性检查已通过
  8.  
  9.  
  10. 正在检查等同用户...
  11. 用户 "oracle" 的等同用户检查已通过
  12.  
  13. WARNING:
  14. 节点 "oradb1" 已显示为集群的一部分
  15.  
  16. 添加节点 的预检查成功。
  17. 正在启动 Oracle Universal Installer...
  18.  
  19. 检查交换空间: 必须大于 500 MB。 实际为 2920 MB 通过
  20. Oracle Universal Installer, 版本 11.2.0.3.0 Production
  21. 版权所有 (c) 1999, 2011, Oracle。保留所有权利。
  22.  
  23.  
  24. 执行测试以检查节点 oradb1,oradb1 是否可用
  25. ............................................................... 100% 已完成。
  26.  
  27. SEVERE:新节点 'oradb1' 已属于集群。

    #执行如下脚本更新节点信息:

  1. [oracle@oradb2 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=/opt/app/oracle/product/11.2.0/dbhome_1 "CLUSTER_NODES={oradb2}"
  2. 正在启动 Oracle Universal Installer...
  3.  
  4. 检查交换空间: 必须大于 500 MB。 实际为 2920 MB 通过
  5. The inventory pointer is located at /etc/oraInst.loc
  6. The inventory is located at /opt/app/oraInventory
  7. 'UpdateNodeList' 成功。

     #继续执行添加节点操作:

  1. [oracle@oradb2 bin]$ ./addNode.sh "CLUSTER_NEW_NODES={oradb1}"
  2.  
  3. 执行 添加节点 的预检查
  4.  
  5. 正在检查节点的可访问性...
  6. 节点 "oradb2" 的节点可访问性检查已通过
  7.  
  8.  
  9. 正在检查等同用户...
  10. 用户 "oracle" 的等同用户检查已通过
  11.  
  12. WARNING:
  13. 节点 "oradb1" 已显示为集群的一部分
  14.  
  15. 添加节点 的预检查成功。
  16. 正在启动 Oracle Universal Installer...
  17.  
  18. 检查交换空间: 必须大于 500 MB。 实际为 2920 MB 通过
  19. Oracle Universal Installer, 版本 11.2.0.3.0 Production
  20. 版权所有 (c) 1999, 2011, Oracle。保留所有权利。
  21.  
  22.  
  23. 执行测试以检查节点 oradb1 是否可用
  24. ............................................................... 100% 已完成。
  25.  
  26. .
  27. -----------------------------------------------------------------------------
  28. 添加集群节点概要
  29. 全局设置
  30.    源: /opt/app/oracle/product/11.2.0/dbhome_1
  31.    新节点
  32. 空间要求
  33.    新节点
  34.       oradb1
  35.          /opt: 要求空间 4.58GB: 可用空间 40.82GB
  36. 已安装产品
  37.    产品名
  38.       Oracle Database 11g 11.2.0.3.0
  39.       Sun JDK 1.5.0.30.03
  40.       Installer SDK Component 11.2.0.3.0
  41.       Oracle One-Off Patch Installer 11.2.0.1.7
  42.       Oracle Universal Installer 11.2.0.3.0
  43.       Oracle USM Deconfiguration 11.2.0.3.0
  44.       Oracle Configuration Manager Deconfiguration 10.3.1.0.0
  45.       Oracle DBCA Deconfiguration 11.2.0.3.0
  46.       Oracle RAC Deconfiguration 11.2.0.3.0
  47.       Oracle Database Deconfiguration 11.2.0.3.0
  48.       Oracle Configuration Manager Client 10.3.2.1.0
  49.       Oracle Configuration Manager 10.3.5.0.1
  50.       Oracle ODBC Driverfor Instant Client 11.2.0.3.0
  51.       LDAP Required Support Files 11.2.0.3.0
  52.       SSL Required Support Files for InstantClient 11.2.0.3.0
  53.       Bali Share 1.1.18.0.0
  54.       Oracle Extended Windowing Toolkit 3.4.47.0.0
  55.       Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
  56.       Oracle Real Application Testing 11.2.0.3.0
  57.       Oracle Database Vault J2EE Application 11.2.0.3.0
  58.       Oracle Label Security 11.2.0.3.0
  59.       Oracle Data Mining RDBMS Files 11.2.0.3.0
  60.       Oracle OLAP RDBMS Files 11.2.0.3.0
  61.       Oracle OLAP API 11.2.0.3.0
  62.       Platform Required Support Files 11.2.0.3.0
  63.       Oracle Database Vault option 11.2.0.3.0
  64.       Oracle RAC Required Support Files-HAS 11.2.0.3.0
  65.       SQL*Plus Required Support Files 11.2.0.3.0
  66.       Oracle Display Fonts 9.0.2.0.0
  67.       Oracle Ice Browser 5.2.3.6.0
  68.       Oracle JDBC Server Support Package 11.2.0.3.0
  69.       Oracle SQL Developer 11.2.0.3.0
  70.       Oracle Application Express 11.2.0.3.0
  71.       XDK Required Support Files 11.2.0.3.0
  72.       RDBMS Required Support Files for Instant Client 11.2.0.3.0
  73.       SQLJ Runtime 11.2.0.3.0
  74.       Database Workspace Manager 11.2.0.3.0
  75.       RDBMS Required Support Files Runtime 11.2.0.3.0
  76.       Oracle Globalization Support 11.2.0.3.0
  77.       Exadata Storage Server 11.2.0.1.0
  78.       Provisioning Advisor Framework 10.2.0.4.3
  79.       Enterprise Manager Database Plugin -- Repository Support 11.2.0.3.0
  80.       Enterprise Manager Repository Core Files 10.2.0.4.4
  81.       Enterprise Manager Database Plugin -- Agent Support 11.2.0.3.0
  82.       Enterprise Manager Grid Control Core Files 10.2.0.4.4
  83.       Enterprise Manager Common Core Files 10.2.0.4.4
  84.       Enterprise Manager Agent Core Files 10.2.0.4.4
  85.       RDBMS Required Support Files 11.2.0.3.0
  86.       regexp 2.1.9.0.0
  87.       Agent Required Support Files 10.2.0.4.3
  88.       Oracle 11g Warehouse Builder Required Files 11.2.0.3.0
  89.       Oracle Notification Service (eONS) 11.2.0.3.0
  90.       Oracle Text Required Support Files 11.2.0.3.0
  91.       Parser Generator Required Support Files 11.2.0.3.0
  92.       Oracle Database 11g Multimedia Files 11.2.0.3.0
  93.       Oracle Multimedia Java Advanced Imaging 11.2.0.3.0
  94.       Oracle Multimedia Annotator 11.2.0.3.0
  95.       Oracle JDBC/OCI Instant Client 11.2.0.3.0
  96.       Oracle Multimedia Locator RDBMS Files 11.2.0.3.0
  97.       Precompiler Required Support Files 11.2.0.3.0
  98.       Oracle Core Required Support Files 11.2.0.3.0
  99.       Sample Schema Data 11.2.0.3.0
  100.       Oracle Starter Database 11.2.0.3.0
  101.       Oracle Message Gateway Common Files 11.2.0.3.0
  102.       Oracle XML Query 11.2.0.3.0
  103.       XML Parser for Oracle JVM 11.2.0.3.0
  104.       Oracle Help For Java 4.2.9.0.0
  105.       Installation Plugin Files 11.2.0.3.0
  106.       Enterprise Manager Common Files 10.2.0.4.3
  107.       Expat libraries 2.0.1.0.1
  108.       Deinstallation Tool 11.2.0.3.0
  109.       Oracle Quality of Service Management (Client) 11.2.0.3.0
  110.       Perl Modules 5.10.0.0.1
  111.       JAccelerator (COMPANION) 11.2.0.3.0
  112.       Oracle Containers for Java 11.2.0.3.0
  113.       Perl Interpreter 5.10.0.0.2
  114.       Oracle Net Required Support Files 11.2.0.3.0
  115.       Secure Socket Layer 11.2.0.3.0
  116.       Oracle Universal Connection Pool 11.2.0.3.0
  117.       Oracle JDBC/THIN Interfaces 11.2.0.3.0
  118.       Oracle Multimedia Client Option 11.2.0.3.0
  119.       Oracle Java Client 11.2.0.3.0
  120.       Character Set Migration Utility 11.2.0.3.0
  121.       Oracle Code Editor 1.2.1.0.0I
  122.       PL/SQL Embedded Gateway 11.2.0.3.0
  123.       OLAP SQL Scripts 11.2.0.3.0
  124.       Database SQL Scripts 11.2.0.3.0
  125.       Oracle Locale Builder 11.2.0.3.0
  126.       Oracle Globalization Support 11.2.0.3.0
  127.       SQL*Plus Files for Instant Client 11.2.0.3.0
  128.       Required Support Files 11.2.0.3.0
  129.       Oracle Database User Interface 2.2.13.0.0
  130.       Oracle ODBC Driver 11.2.0.3.0
  131.       Oracle Notification Service 11.2.0.3.0
  132.       XML Parser for Java 11.2.0.3.0
  133.       Oracle Security Developer Tools 11.2.0.3.0
  134.       Oracle Wallet Manager 11.2.0.3.0
  135.       Cluster Verification Utility Common Files 11.2.0.3.0
  136.       Oracle Clusterware RDBMS Files 11.2.0.3.0
  137.       Oracle UIX 2.2.24.6.0
  138.       Enterprise Manager plugin Common Files 11.2.0.3.0
  139.       HAS Common Files 11.2.0.3.0
  140.       Precompiler Common Files 11.2.0.3.0
  141.       Installation Common Files 11.2.0.3.0
  142.       Oracle Help for the Web 2.0.14.0.0
  143.       Oracle LDAP administration 11.2.0.3.0
  144.       Buildtools Common Files 11.2.0.3.0
  145.       Assistant Common Files 11.2.0.3.0
  146.       Oracle Recovery Manager 11.2.0.3.0
  147.       PL/SQL 11.2.0.3.0
  148.       Generic Connectivity Common Files 11.2.0.3.0
  149.       Oracle Database Gateway for ODBC 11.2.0.3.0
  150.       Oracle Programmer 11.2.0.3.0
  151.       Oracle Database Utilities 11.2.0.3.0
  152.       Enterprise Manager Agent 10.2.0.4.3
  153.       SQL*Plus 11.2.0.3.0
  154.       Oracle Netca Client 11.2.0.3.0
  155.       Oracle Multimedia Locator 11.2.0.3.0
  156.       Oracle Call Interface (OCI) 11.2.0.3.0
  157.       Oracle Multimedia 11.2.0.3.0
  158.       Oracle Net 11.2.0.3.0
  159.       Oracle XML Development Kit 11.2.0.3.0
  160.       Database Configuration and Upgrade Assistants 11.2.0.3.0
  161.       Oracle JVM 11.2.0.3.0
  162.       Oracle Advanced Security 11.2.0.3.0
  163.       Oracle Internet Directory Client 11.2.0.3.0
  164.       Oracle Enterprise Manager Console DB 11.2.0.3.0
  165.       HAS Files for DB 11.2.0.3.0
  166.       Oracle Net Listener 11.2.0.3.0
  167.       Oracle Text 11.2.0.3.0
  168.       Oracle Net Services 11.2.0.3.0
  169.       Oracle Database 11g 11.2.0.3.0
  170.       Oracle OLAP 11.2.0.3.0
  171.       Oracle Spatial 11.2.0.3.0
  172.       Oracle Partitioning 11.2.0.3.0
  173.       Enterprise Edition Options 11.2.0.3.0
  174. -----------------------------------------------------------------------------
  175.  
  176.  
  177. 实例化脚本以添加节点 (2016年12月25日 星期日 上午04时48分52秒 CST)
  178. . 1% 已完成。
  179. 实例化添加节点脚本完成
  180.  
  181. 复制到远程节点 (2016年12月25日 星期日 上午04时48分56秒 CST)
  182. ............................................................................................... 96% 已完成。
  183. 主目录已复制到新节点
  184.  
  185. 在节点上保存产品清单 (2016年12月25日 星期日 上午04时54分03秒 CST)
  186. . 100% 已完成。
  187. 保存产品清单完成
  188. WARNING:
  189. 以下配置脚本需要以各个新集群节点中的 "root" 用户的身份执行。以下列表中的每个脚本后面跟随一个节点列表。
  190. /opt/app/oracle/product/11.2.0/dbhome_1/root.sh #On nodes oradb1
  191. 要执行配置脚本, 请执行以下操作:
  192.     1. 打开终端窗口
  193.     2."root" 身份登录
  194.     3. 在每个集群节点中运行脚本
  195.      
  196. /opt/app/oracle/product/11.2.0/dbhome_1 的 添加集群节点 已成功。
  197. 请查看 '/tmp/silentInstall.log' 以获取详细资料。

     #执行root.sh脚本:

  1. [root@oradb1 app]# /opt/app/oracle/product/11.2.0/dbhome_1/root.sh
  2. Performing root user operation for Oracle 11g
  3.  
  4. The following environment variables are set as:
  5.     ORACLE_OWNER= oracle
  6.     ORACLE_HOME= /opt/app/oracle/product/11.2.0/dbhome_1
  7.  
  8. Enter the full pathname of the local bin directory: [/usr/local/bin]:
  9. The contents of "dbhome" have not changed. No need to overwrite.
  10. The contents of "oraenv" have not changed. No need to overwrite.
  11. The contents of "coraenv" have not changed. No need to overwrite.
  12.  
  13. Entries will be added to the /etc/oratab file as needed by
  14. Database Configuration Assistant when a database is created
  15. Finished running generic part of root script.
  16. Now product-specific root actions will be performed.
  17. Finished product-specific root actions.

二十二:检查数据库添加情况:

  1. [grid@oradb1 ~]$ crsctl status res -t
  2. --------------------------------------------------------------------------------
  3. NAME TARGET STATE SERVER STATE_DETAILS
  4. --------------------------------------------------------------------------------
  5. Local Resources
  6. --------------------------------------------------------------------------------
  7. ora.DATACRS.dg
  8.                ONLINE ONLINE oradb1
  9.                ONLINE ONLINE oradb2
  10. ora.DATAVOL1.dg
  11.                ONLINE ONLINE oradb1
  12.                ONLINE ONLINE oradb2
  13. ora.FRAVOL1.dg
  14.                ONLINE ONLINE oradb1
  15.                ONLINE ONLINE oradb2
  16. ora.LISTENER.lsnr
  17.                ONLINE ONLINE oradb1
  18.                ONLINE ONLINE oradb2
  19. ora.asm
  20.                ONLINE ONLINE oradb1 Started
  21.                ONLINE ONLINE oradb2 Started
  22. ora.gsd
  23.                OFFLINE OFFLINE oradb1
  24.                OFFLINE OFFLINE oradb2
  25. ora.net1.network
  26.                ONLINE ONLINE oradb1
  27.                ONLINE ONLINE oradb2
  28. ora.ons
  29.                ONLINE ONLINE oradb1
  30.                ONLINE ONLINE oradb2
  31. ora.registry.acfs
  32.                ONLINE ONLINE oradb1
  33.                ONLINE ONLINE oradb2
  34. --------------------------------------------------------------------------------
  35. Cluster Resources
  36. --------------------------------------------------------------------------------
  37. ora.LISTENER_SCAN1.lsnr
  38.       1 ONLINE ONLINE oradb2
  39. ora.cvu
  40.       1 ONLINE ONLINE oradb2
  41. ora.oc4j
  42.       1 ONLINE ONLINE oradb2
  43. ora.oradb1.vip
  44.       1 ONLINE ONLINE oradb1
  45. ora.oradb2.vip
  46.       1 ONLINE ONLINE oradb2
  47. ora.scan1.vip
  48.       1 ONLINE ONLINE oradb2
  49. ora.tjtvdb.db
  50.       1 ONLINE ONLINE oradb1 Open
  51.       2 ONLINE ONLINE oradb2 Open

 

二十三、手工执行dbca添加实例:




























二十四、检查实例是否已经成功添加

  1. [grid@oradb1 ~]$ crsctl status res -t
  2. --------------------------------------------------------------------------------
  3. NAME TARGET STATE SERVER STATE_DETAILS
  4. --------------------------------------------------------------------------------
  5. Local Resources
  6. --------------------------------------------------------------------------------
  7. ora.DATACRS.dg
  8.                ONLINE ONLINE oradb1
  9.                ONLINE ONLINE oradb2
  10. ora.DATAVOL1.dg
  11.                ONLINE ONLINE oradb1
  12.                ONLINE ONLINE oradb2
  13. ora.FRAVOL1.dg
  14.                ONLINE ONLINE oradb1
  15.                ONLINE ONLINE oradb2
  16. ora.LISTENER.lsnr
  17.                ONLINE ONLINE oradb1
  18.                ONLINE ONLINE oradb2
  19. ora.asm
  20.                ONLINE ONLINE oradb1 Started
  21.                ONLINE ONLINE oradb2 Started
  22. ora.gsd
  23.                OFFLINE OFFLINE oradb1
  24.                OFFLINE OFFLINE oradb2
  25. ora.net1.network
  26.                ONLINE ONLINE oradb1
  27.                ONLINE ONLINE oradb2
  28. ora.ons
  29.                ONLINE ONLINE oradb1
  30.                ONLINE ONLINE oradb2
  31. ora.registry.acfs
  32.                ONLINE ONLINE oradb1
  33.                ONLINE ONLINE oradb2
  34. --------------------------------------------------------------------------------
  35. Cluster Resources
  36. --------------------------------------------------------------------------------
  37. ora.LISTENER_SCAN1.lsnr
  38.       1 ONLINE ONLINE oradb2
  39. ora.cvu
  40.       1 ONLINE ONLINE oradb2
  41. ora.oc4j
  42.       1 ONLINE ONLINE oradb2
  43. ora.oradb1.vip
  44.       1 ONLINE ONLINE oradb1
  45. ora.oradb2.vip
  46.       1 ONLINE ONLINE oradb2
  47. ora.scan1.vip
  48.       1 ONLINE ONLINE oradb2
  49. ora.tjtvdb.db
  50.       1 ONLINE ONLINE oradb1 Open
  51. 2 ONLINE ONLINE oradb2 Open

二十五、我们可以看到实例已经成功添加,至此整个RAC的节点替换已经完成。

本文永久更新链接地址http://www.linuxidc.com/Linux/2017-01/139396.htm

linux
相关资讯       Oracle 11gR2  11gR2添加节点 
本文评论   查看全部评论 (2)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款
第 2 楼
* 匿名 发表于 2017/1/10 8:15:52
不错,学习了c
第 1 楼
* 匿名 发表于 2017/1/10 8:05:02
图无法显示