Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what is the method of deleting and adding 11G RAC nodes". In daily operation, I believe that many people have doubts about the method of deleting and adding 11G RAC nodes. I have consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts of "what is the method of deleting and adding 11G RAC nodes?" Next, please follow the editor to study!

RAC deletes nodes and adds nodes

Oracle users update Inventory

$ORACLE_HOME/oui/bin/runInstaller-updateNodelist ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES=zycdbtst3"-local

Remove the db software

$ORACLE_HOME/deinstall/deinstall-local

Then update Inventory on other host oracle users

$ORACLE_HOME/oui/bin/runInstaller-updateNodelist ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES= {zycdbtst1,zycdbtst2}"-local

$ORACLE_HOME/oui/bin/runInstaller-updateNodelist ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES= {zycdbtst1,zycdbtst2}"-local

Delete nod

Update the inventory of GI

Update grid user Inventory

$ORACLE_HOME/oui/bin/runInstaller-updateNodelist ORACLE_HOME "CLUSTER_NODES= {zycdbtst3}" CRS=TRUE-silent-local

(the name of the node to be deleted is entered in cluster_nodes)

Uninstall GI

$ORACLE_HOME/deinstall/deinstall-local

Then update the Inventory information on the normal node.

$ORACLE_HOME/oui/bin/runInstaller-updateNodelist ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES= {zycdbtst1,zycdbtst2}" CRS=TRUE-silent-local

$ORACLE_HOME/oui/bin/runInstaller-updateNodelist ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES= {zycdbtst1,zycdbtst2}" CRS=TRUE-silent-local

Delete the node to be culled on the reserved node

Crsctl delete node-n zycdbtst3

Instance deletion (not operated)

Query status

Olsnodes-s

The above is the delete operation

=

Add nod

Run the following script on an existing node

$ORACLE_HOME/oui/bin/addNode.sh-silent "CLUSTER_NEW_NODES= {zdata-db03,zdata-db04}"CLUSTER_NEW_VIRTUAL_HOSTNAMES= {zdata-db03-vip,zdata-db04-vip}"

NTP errors can be ignored after checking; ORACLE_HOME cannot share: directly rebuild or check permissions on the new node (reconstruction is more convenient)

If there are only NTP errors. Export IGNORE_PREADDNODE_CHECKS=Y, and then run

$ORACLE_HOME/oui/bin/addNode.sh-silent "CLUSTER_NEW_NODES= {zdata-db03,zdata-db04}"CLUSTER_NEW_VIRTUAL_HOSTNAMES= {zdata-db03-vip,zdata-db04-vip}"

The process of copy files is slow. The problems that may occur here are mainly caused by errors in the Inventory.xml file, which can be found through cat / etc/oraInst.loc

After successful, run two scripts with root on the add node

OrainstRoot.sh 、 root.sh

The first script will run very smoothly, and the second script may encounter various problems. Here are the holes encountered in this installation.

Using configuration parameter file: / crs11g/grid/11.2.0.3/crs/install/crsconfig_params

User ignored Prerequisites during installation

Failed to write the checkpoint:'' with status:FAIL.Error code is 256

Undefined subroutine & crsconfig_lib::dieformat called at / crs11g/grid/11.2.0.3/crs/install/crsconfig_lib.pm line 6146.

/ crs11g/grid/11.2.0.3/perl/bin/perl-I/crs11g/grid/11.2.0.3/perl/lib-I/crs11g/grid/11.2.0.3/crs/install / crs11g/grid/11.2.0.3/crs/install/rootcrs.pl execution failed

When we execute the statement again. Prompt that the related file cannot be found

Here we upgraded the yum source. Then make a soft link in the relevant file, and then you can continue to execute.

After the root.sh is executed, you can continue to install the DB software.

When you install the DB software, you should execute the relevant commands on the node where you already have the DB software:

Export IGNORE_PREADDNODE_CHECKS=Y

$ORACLE_HOME/oui/bin//addNode.sh-silent "CLUSTER_NEW_NODES= {zycdbtst3}"CLUSTER_NEW_NODES_VIP= {zycdbtst3-vip}"

If the command cannot copy the DB software to the target node. You can manually cp the existing cluster DB software to the target file:

The steps are as follows

1. Compress database software from other hosts

Compress with root users:

Tar cvf Oracle.tar / oracle/product/db11gr2 ($ORACLE_HOME)

two。 Using the root user tar database package Oracle .tar

Extract tar-xvf Oracle .tar

Configuration / etc/oraInst.loc file

Oracle@Ttest55:/oracle/admin/audit/bdump/cat / etc/oraInst.loc

Inventory_loc=/home/oracle/oraInventory

Inst_group=oinstall

3.relink command:

$cd $ORACLE_HOME/oui/bin/

$. / runInstaller-invPtrLoc / etc/oraInst.loc-silent-clone ORACLE_BASE='/oracle/product' ORACLE_HOME='/oracle/product/db11gr2' ORACLE_HOME_NAME='oracle_home1'

ORACLE_HOME is written according to the actual $ORACLE_HOME, and ORACLE_HOME_NAME can be named as you like.

After relink, you need to use root users to execute the script (depending on the specific path)

# sh / oracle/product/10205/root.sh

If you install DB software manually, you need to go to each node and update the inventory.xml file under ORACLE_HOME manually. As follows:

$ORACLE_HOME/oui/bin/runInstaller-updateNodelist ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES= {zycdbtst1,zycdbtst2,zycdbtst3}"-local

Then switch or start the instance to verify that the installation is complete

At this point, the study on "what is the method of deleting and adding 11G RAC nodes" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.