11.2g RAC 添加节点

  oracle 添加节点：                   

                                            ---- --参考《构建最高可用oracle数据库系统》，《oracle 官档》

1，系统安装：操作系统要求和现有的集群节点系统一致，不可以跨版本，但是系统的版本可以不同，但是最好一致。

２，网络配置　（　ｉｐ，ｖｉｐ，ｐｒｉｖ－ｉｐ）　与现有的环境最好一致，并同时添加集群中去。

３，存储配置（　各节点可以共享访问）

４，安装　ｃｕｖｄｉｓｋ　包

５，ｓｓｈ　等效性验证。

６，ｎｔｐ　时间同步。

７，　通过ＣＶＵ验证添加节点是否满足系统集群逻辑配置要求：

８，　在现有的任一节点上，通过ｇｒｉｄ　登陆： 在$ORACLE_HOME/oui/bin(/u01/app/11.2/grid/oui/bin) 路径下执行：

    [grid@lmocm189 ~]$ cd $ORACLE_HOME

    [grid@lmocm189 grid]$ cd oui/bin/

    [grid@lmocm189 bin]$ pwd

     /u01/app/11.2/grid/oui/bin

    [grid@lmocm189 bin]$  cluvfy stage -pre nodeadd -n lmocm191 -verbose  (lmocm191 为要添加的节点）

 ---根据检测的结果，看 failed 的选项（主要是，swap,rpm包，ntp等）

 

 9，没问题之后，在grid 用户下，安装clusterware(GRID)软件。在$ORACLE_HOME/oui/bin(/u01/app/11.2/grid/oui/bin) 路径下执行。

     [grid@lmocm189 bin]$ ./addNode.sh CLUSTER_NEW_NODES={lmocm191} CLUSTER_NEW_VIRTUAL_HOSTNAMES={vip191}

   （ -silent 表示静默模式，运行addNode.sh 命令，在silent后追加所需参数，11gR2开始，不在支持图形界面）

   --执行成功后，在新节点以root用户执行$GRID_HOME/root.sh脚本。

10 ，添加新节点RAC database 软件： 

   在现有的任一集群节点oracle用户路径  cd /u01/app/oracle/product/11.2/dbhome_1/oui/bin/下执行：

   [oracle@lmocm189 bin]$ ./addNode.sh CLUSTER_NEW_NODES={lmocm191}

  --完成之后，在新增加节点root下，执行$ORACLE_HOME/root.sh脚本。

---以上9,10 步确保都是以success 结尾。

11， 完成以后，通过DBCA 建库，这里，可以使用silent，或者图形界面：

   在现有的集群的任一节点 oracle用户下执行：

  --silent: dbca -silent -addInstance -nodeList lmocm191 -gdbName lmocm -instanceName lomocm3 - sysDBAUserName sys -sysDBAPassword oracle

 【node: 要添加或删除的节点名称，对应hosts文件中的配置。

 【gdbname:全局数据库名称。

 【instance:实例名称。

 【sysdba:拥有SYSDBA权限的oracle用户名称。

 【password:sysdba 用户的密码。

 --图形界面：

1. Ensure that your existing nodes have the $ORACLE_HOME environment variable set correctly.

2. Start DBCA by entering dbca at the system prompt from the Oracle_home/bin directory.

   DBCA performs certain CVU checks while running. However, you can also run CVU from the command line to verify that the Oracle ASM instance is ready for addition to a node, as follows:

   cluvfy stage -pre storadd –s path [-t asm] [-verbose]
   

   Replace path with the directory path by which Oracle ASM is identified within the system.

3. Select Oracle Real Application Clusters database, click Next, and DBCA displays the Operations page.

4. If your database is administrator-managed, select Instance Management, click Next, and DBCA displays the Instance Management page.

   If your database is policy-managed, then the Instance Management option is not available. To increase the number of database instances, add more nodes to the server pool.

5. Select Add Instance and click Next. DBCA displays the List of Cluster Databases page that shows the databases and their current status, such as ACTIVE, or INACTIVE.

6. From the List of Cluster Databases page, select the active Oracle RAC database to which you want to add an instance. Enter user name and password for the database user that has SYSDBAprivileges. Click Next and DBCA displays the List of Cluster Database Instances page showing the names of the existing instances for the Oracle RAC database that you selected.

7. Click Next to add a new instance and DBCA displays the Adding an Instance page.

8. On the Adding an Instance page, enter the instance name in the field at the top of this page if the instance name that DBCA provides does not match your existing instance naming scheme. Then select the target node name from the list, click Next, and DBCA displays the Services Page.

9. Enter the services information for the target node's instance, click Next, and DBCA displays the Instance Storage page.

10. If you are using raw devices or raw partitions, then on the Instance Storage page select the Tablespaces folder and expand it. Select the undo tablespace storage object and a dialog appears on the right-hand side. Change the default data file name to the raw device name for the tablespace.

11. If you are using raw devices or raw partitions or if you want to change the default redo log group file name, then on the Instance Storage page select and expand the Redo Log Groups folder. For each redo log group number that you select, DBCA displays another dialog box.

12. If you are using a cluster file system, then click Finish on the Instance Storage page. If you are using raw devices, then repeat step 11 for all of the other redo log groups, click Finish, and DBCA displays a Summary dialog.

13. Review the information on the Summary dialog and click OK or click Cancel to end the instance addition operation. DBCA displays a progress dialog showing DBCA performing the instance addition operation. When DBCA completes the instance addition operation, DBCA displays a dialog asking whether you want to perform another operation.

14. After you terminate your DBCA session, run the following command to verify the administrative privileges on the target node and obtain detailed information about these privileges wherenodelist consists of the target nodes:

    cluvfy comp admprv -o db_config -d oracle_home -n nodelist [-verbose]
    

15. Perform any needed service configuration procedures, as described in Chapter 4, "Introduction to Automatic Workload Management".

  

  完成之后，通过以下命令检测： 各节点，及新增加的节点

 crsctl check cluster -all

 crs_stat -t

 srvctl status database -d lmocm

-----rac 下的各节点 共享spfile 参数文件。