oracle RAC 11G R2 delete add node

sudo su - oracle
dbca
delete instance

–dbca 删除失败 无法删除inactive instance B node

sudo su - grid
olsnodes -s -t

–root
–crsctl unpin css -n（节点主机名）

######B node######
sudo su -

yum install perl-Env

cd /opt/apps/grid/product/11g2/grid_home
cd crs/install/

./rootcrs.pl -deconfig -deinstall -force

su - grid
cd $ORACLE_HOME/deinstall
./deinstall -local
– -local 必须
Run ‘rm -rf /etc/oraInst.loc’ as root on node(s) ‘shdcvscldo2185b’ at the end of the session.
Run ‘rm -rf /opt/ORCLfmap’ as root on node(s) ‘shdcvscldo2185b’ at the end of the session.
Run ‘rm -rf /etc/oratab’ as root on node(s) ‘shdcvscldo2185b’ at the end of the session.
Oracle deinstall tool successfully cleaned up temporary directories.

######A node####
sudo su -
crsctl stat res -t

srvctl stop vip -i shdcvscldo2185b
srvctl remove vip -i shdcvscldo2185b
Please confirm that you intend to remove the VIPs shdcvscldo2185b (y/[n]) y

srvctl stop vip -i shdcvscldo2185b -f
srvctl remove vip -i shdcvscldo2185b -f

/opt/apps/grid/product/11g2/grid_home/bin/crsctl delete node -n shdcvscldo2185b

########B node#########
sudo su - grid
cd /opt/apps/grid/product/11g2/grid_home
cd oui/bin

./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME “CLUSTER_NODES={shdcvscldo2185b}” CRS=TRUE -silent -local

########A node #####

su - grid

cat /opt/apps/oracle/oraInventory/ContentsXML/inventory.xml

cd $ORACL{E}_{H}OME/oui/bin./runInstaller-updateNodeListORACL{E}_{H}OME=$ORACLE_HOME “CLUSTER_NODES=shdcvscldo2185a” CRS=TRUE -silent
./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME “CLUSTER_NODES=shdcvscldo2185a”

./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME “CLUSTER_NODES={shdcvscldo2185a}” LOCAL_NODE=shdcvscldo2185a

su - oracle
./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME “CLUSTER_NODES={shdcvscldo2185a}” -local

cat /opt/apps/oracle/oraInventory/ContentsXML/inventory.xml

su - grid
cluvfy stage -post nodedel -n shdcvscldo2185b -verbose

crsctl stat res -t
节点删除工作完成。
#####################################

#######B node#####
rpm -ivh cvuqdisk-1.0.9-1.rpm

####a 节点操作####

su - grid

cluvfy stage -pre nodeadd -n shdcvscldo2185b -fixup -verbose

rpm -ivh pdksh-5.2.14-37.el5_8.1.x86_64.rpm

cluvfy stage -pre nodeadd -n shdcvscldo2185b -fixup -verbose

–export IGNORE_PREADDNODE_CHECKS=Y

cd /opt/apps/grid/product/11g2/grid_home/oui/bin

./addnode.sh -silent “CLUSTER_NEW_NODES={shdcvscldo2185b}” “CLUSTER_NEW_VIRTUAL_HOSTNAMES={shdcvscldo2185b-vip}”
./addNode.sh -silent “CLUSTER_NEW_NODES={shdcvscldo2185b}” “CLUSTER_NEW_VIRTUAL_HOSTNAMES={shdcvscldo2185b-vip}” “CLUSTER_NEW_PRIVATE_NODE_NAMES={shdcvscldo2185b-priv}” > /home/grid/add_node2.log 2>&1

./addNode.sh -ignorePrereqFailure -silent “CLUSTER_NEW_NODES={shdcvscldo2185b}” “CLUSTER_NEW_VIRTUAL_HOSTNAMES={shdcvscldo2185b-vip}” “CLUSTER_NEW_PRIVATE_NODE_NAMES={shdcvscldo2185b-priv}” > /home/grid/add_node2.log 2>&1
(doing grid binary copy and install in B)

OutOfMemoryError: GC overhead

vi grid_home/oui/oraparam.ini

JRE_MEMORY_OPTIONS=" -mx512m"

./addNode.sh “CLUSTER_NEW_NODES={shdcvscldo2185b}” “CLUSTER_NEW_VIRTUAL_HOSTNAMES={shdcvscldo2185b-vip}”

#####shdcvscldo2185b ###
/opt/apps/oracle/oraInventory/orainstRoot.sh #On nodes shdcvscldo2185b
/opt/apps/grid/product/11g2/grid_home/root.sh #On nodes shdcvscldo2185b

–会重启A节点

if root.sh get fail, You can execute the following script,and re-run root.sh
/opt/apps/grid/product/11g2/grid_home/crs/install/rootcrs.pl -deconfig -force

############

cemutlo -n
cluster name:xstoredb-qa

srvctl config scan
SCAN name: xstoredb-qa-scan, Network: 1/10.132.122.0/255.255.255.0/ens192
SCAN VIP name: scan1, IP: /xstoredb-qa-scan/10.132.122.62
SCAN VIP name: scan2, IP: /xstoredb-qa-scan/10.132.122.61
SCAN VIP name: scan3, IP: /xstoredb-qa-scan/10.132.122.60

########Oracle home add node #######
sudo su - oracle
cd /opt/apps/oracle/product/11g2/db_home/oui/bin
./addNode.sh “CLUSTER_NEW_NODES={shdcvscldo2185b}”

– 正常情况 自动更新inventory.xml 不用再跑runInstaller -updateNodeList

到 shdcvscldo2185b节点执行：
/opt/apps/oracle/product/11g2/db_home/root.sh

cat /opt/apps/oracle/oraInventory/ContentsXML/inventory.xml

su - grid
crsctl stat res -t

DBCA add instance

su - oracle
cd $ORACLE_HOME/oui/bin
./runInstaller -updateNodeList ORACLE_HOME=/opt/apps/oracle/product/11g2/db_home “CLUSTER_NODES={shdcvscldo2185a,shdcvscldo2185b}”

cat /opt/apps/oracle/oraInventory/ContentsXML/inventory.xml
su - grid

cat /opt/apps/oracle/oraInventory/ContentsXML/inventory.xml

cd $ORACLE_HOME/oui/bin

./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME “CLUSTER_NODES={shdcvscldo2185a,shdcvscldo2185b}”

节点添加完成，启停测试
root
crsctl stop crs
crsctl start crs
crsctl stat res -t

检查service信息
srvctl status database -d xstoreq_dg
srvctl status instance -d xstoreq_dg -i xstoreq1
srvctl status instance -d xstoreq_dg -i xstoreq2
srvctl status service -d xstoreq_dg
srvctl add service -d xstoreq_dg -s xstoreqsvc -r "xstoreq1,xstoreq2 "
可选配置 srvctl add service -d xstoreq_dg -s xstoreqsvc -r “xstoreq1” -a “xstoreq2”