11gR2集群节点删除添加步骤

1、删除instance
    检查OCR备份(grid)

        ocrconfig -showbackup

    
    删除要删除节点的instance(oracle)
    

dbca-->instance management-->delete instance-->显示存在的数据库，输入sysdba权限用户密码-->选择要删除的instance-->finish开始删除实例

    在保留的节点禁用删除节点的log thread(oracle)
        

ALTER DATABASE DISABLE THREAD 1;

    验证OCR配置信息(grid)
      

  srvctl config database -d db_unique_name

2、移除rac
    清除删除节点的监听(grid)

        srvctl disable listener -l listener_name -n name_of_node_to_delete
        srvctl stop listener -l listener_name -n name_of_node_to_delete

    在删除节点，同步oraInventory库，进入$ORACLE_HOME/oui/bin(grid、oracle)

        ./runInstaller -updateNodeList ORACLE_HOME=Oracle_home_location "CLUSTER_NODES={name_of_node_to_delete}" -local

    删除节点删除软件，进入$ORACLE_HOME/deinstall

        ./deinstall -local

    在保留节点，同步oraInventory库，进入$ORACLE_HOME/oui/bin(grid、oracle)

        ./runInstaller -updateNodeList ORACLE_HOME=Oracle_home_location "CLUSTER_NODES={remaining_node_list}"

 

 

 

添加
1、在保留节点，进入Oracle_home/oui/bin 目录(grid用户)
   

 ./addNode.sh -silent "CLUSTER_NEW_NODES={node1}"

示例：

./addNode.sh -silent "CLUSTER_NEW_NODES={rac1}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac1-vip}" "CLUSTER_NEW_PRIVATE_NODE_NAMES={rac1-priv}"

跳过预检查

export IGNORE_PREADDNODE_CHECKS=Y

设置保留节点执行JAVA内存，防止内存溢出错误(PRKC-1025)

cd cd $GRID_HOME/oui/    
grep JRE_MEMORY_OPTIONS oraparam.ini 

#JRE_MEMORY_OPTIONS=" -mx150m"   <<<<<<<默认值是150M
JRE_MEMORY_OPTIONS=" -mx1024m" <<<<<<<<修改值为1024M

 

./addNode.sh -silent "CLUSTER_NEW_NODES={rac11gliku1}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac11gliku1vip}" "CLUSTER_NEW_PRIVATE_NODE_NAMES={rac11gliku1pri}"

2、新添加节点，以root运行root.sh脚本
Instantiating scripts for add node (Thursday, March 9, 2017 11:52:36 AM CST)
.                                                                 1% Done.
Instantiation of add node scripts complete

Copying to remote nodes (Thursday, March 9, 2017 11:52:41 AM CST)
...............................................................................................                                 96% Done.
Home copied to new nodes

Saving inventory on nodes (Thursday, March 9, 2017 12:02:38 PM CST)
.                                                               100% Done.
Save inventory complete
WARNING:
The following configuration scripts need to be executed as the "root" user in each new cluster node. Each script in the list below is followed by a list of nodes.
/u01/11.2.0/grid/root.sh #On nodes rac1
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts in each cluster node

The Cluster Node Addition of /u01/11.2.0/grid was successful.
Please check '/tmp/silentInstall.log' for more details.
[grid@rac2 bin]$

 

3、保留节点切换到oracle用户，为新添节点安装oracle软件
    

su - oracle
    cd $ORACLE_HOME/oui/bin/
    ./addNode.sh -silent "CLUSTER_NEW_NODES={rac1}"

./addNode.sh -silent "CLUSTER_NEW_NODES={rac11gliku1}"

4、在新添加节点运行root.sh脚本
Instantiating scripts for add node (Thursday, March 9, 2017 2:34:54 PM CST)
.                                                                 1% Done.
Instantiation of add node scripts complete

Copying to remote nodes (Thursday, March 9, 2017 2:35:01 PM CST)
...............................................................................................                                 96% Done.
Home copied to new nodes

Saving inventory on nodes (Thursday, March 9, 2017 2:50:01 PM CST)
.                                                               100% Done.
Save inventory complete
WARNING:
The following configuration scripts need to be executed as the "root" user in each new cluster node. Each script in the list below is followed by a list of nodes.
/u01/app/oracle/product/11.2.0/db_1/root.sh #On nodes rac1
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts in each cluster node

The Cluster Node Addition of /u01/app/oracle/product/11.2.0/db_1 was successful.
Please check '/tmp/silentInstall.log' for more details.
[oracle@rac2 bin]$

 

 

5、在保留节点运行dbca，添加新添节点实例