Shulou(Shulou.com)06/01 Report--

This article mainly introduces oracle11g_RAC how to add and delete nodes, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, let the editor take you to understand it.

Delete nod

Delete Node 1 instance

Run dbca as oracle on Node 2 and delete the relevant information according to the wizard

Instance management- > delete an instance- > enter the account and password of the sysdba user-> selected deleted node instance

View database status and execute as grid user in Node 2

Srvctl status database-d nmgsaic

(normally only nmgsdb002 nmgsdb003 is displayed)

Backup OCR, executed as root user in nmgsdb002

/ grid/11.2/grid/bin/ocrconfig-manualbackup

Update oracle Inventory to be executed by oracle users in nmgsdb002

$ORACLE_HOME/oui/bin/runInstaller-updatenodelist ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES= {nmgsdb002,nmgsdb003}"

Delete the node as the root user in nmgsdb002

/ grid/11.2/grid/bin/crsctl delete node-n nmgsdb001

Check node status. Normally, only nmgsdb002 and nmgsdb003 are displayed.

/ grid/11.2/grid/bin/olsnodes-s-t

Update oracle Inventory to be executed by grid users in nmgsdb002

. / runInstaller-updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES= {nmgsdb002,nmgsdb003}" CRS=TRUE

Verify:

/ grid/11.2/grid/bin/cluvfy stage-post nodedel-n nmgsdb001-verbose

/ grid/11.2/grid/bin/crs_stat-t

If the vip of node 1 still exists, execute the following command to delete it with root on node 2

/ grid/11.2/grid/bin/srvctl stop vip-I nmgsdb001_vip (subject to the actual name)

/ grid/11.2/grid/bin/srvctl remove vip-I nmgsdb001_vip

-

Add nod

You need to ensure that the following work is done before you operate:

1. Network configuration

two。 Operating system patches and patch

3. Groups and users have been added and configured .profile

4. The mutual trust relationship between nodes has been configured

Execute as grid user in node 2, check whether the execution result is pass,NTP problem can be ignored

$ORACLE_HOME/oui/bin/runcluvfy.sh stage-pre crsinst-n nmgsdb001-verbose

If any of the conditions are not met, the execution of addNode.sh will fail. Execute the following script to ignore the error and install grid directly.

The following command is too long and can be executed in a script

$ORACLE_HOME/oui/bin/runInstaller-addNode-invPtrLoc / grid/11.2/grid/oraInst.loc ORACLE_HOME=$ORACLE_HOME CLUSTER_NEW_NODES= {nmgsdb001} CLUSTER_NEW_VIRTUAL_HOSTNAMES= {nmgsdb001-vip}

CLUSTER_NODES=nmgsdb001,nmgsdb002,nmgsdb003}

Confirm that there is no problem with the execution of the above script, and follow the instructions to execute the script as the root user

/ grid/oraInventory/orainstRoot.sh.

/ grid/11.2.0/grid/root.sh

Add oracle database software

Execute on Node 2

$ORACLE_HOME/oui/bin/addNode.sh-silent "CLUSTER_NEW_NODES= {nmgsdb001}"

(if the execution is unsuccessful, you can copy $ORACLE_HOME on node 2 to node 2, and then execute $ORACLE_HOME/bin/relink)

Follow the prompts to execute $ORACLE_HOME/root.sh as root user

Add an instance with dbca (similar to deletion above)

Finally, check the cluster status, execute it as grid users on any node, and confirm that all three nodes have instances running.

Crsctl status res-t

Thank you for reading this article carefully. I hope the article "how to add and delete nodes in oracle11g_RAC" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.