RAC增加节点实验

1、Oracle RAC增加一个节点_3节点的实验1、主机名规划：#Public Network - (ethO)192.168.110.11 rac1192.168.110.12 rac2192.168.110.13 rac3#Private Interconnect - (eth1)10.10.10.11 rac1priv10.10.10.12 rac2priv10.10.10.13 rac3priv #Public Virtual IP (VIP) addresses - (eth0)192.168.110.21 rac1vip192.168.110.22 rac2vip192.168.11

2、0.23 rac3vipS SH验证等。2、配置与rac1与rac2 一样的OS环境，包括创建用户，环境变量,3、Install Oracle Clusterware on the new node在第一个节点上操作以下：cd $CRS_HOME/oui/bin./addNode.sh根据提示完成第3个节点的 crs安装，安装完后成，运行以下脚本: /oracle/app/oralnventory/orainstRoot.sh rac3/oracle/app/crs/install/rootaddnode.sh rac1/oracle/app/crs/root.sh rac3详细日志如下:ro

3、otrac3 # /oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory to 770.Changing groupname of /oracle/app/oraInventory to oinstall.The execution of the script. is completerootrac1 # /oracle/app/crs/install/rootaddnode.shclscfg: EXISTING configuration version 3 detecte

4、d.clscfg: version 3 is 10G Release 2.Attempting to add 1 new nodes to the configurationUsing ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : vprivate interconnect name node 3: rac3 rac3priv rac3Creating OCR keys for user root, privgrp root.Operation successful./oracle/app/crs/bin/srvctl

5、add nodeapps -n rac3 -A rac3vip/255.255.255.0/eth0 -o /oracle/app/crsrootrac3 # /oracle/app/crs/root.shWARNING: directory /oracle/app is not owned by rootWARNING: directory /oracle is not owned by rootChecking to see if Oracle CRS stack is already configured/etc/oracle does not exist. Creating it no

6、w.OCR LOCATIONS = /dev/raw/raw1OCR backup directory /oracle/app/crs/cdata/crs does not exist. Creating nowSetting the permissions on OCR backup directorySetting up NS directoriesOracle Cluster Registry configuration upgraded successfullyWARNING: directory /oracle/app is not owned by rootWARNING: dir

7、ectory /oracle is not owned by rootclscfg: EXISTING configuration version 3 detected.clscfg: version 3 is 10G Release 2.Successfully accumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : vprivate interconnect name node 1: racl raclpriv raclnode 2: rac2 rac2

8、priv rac2clscfg: Arguments check out successfully.NO KEYS WERE WRITTEN. Supply -force parameter to override.-force is destructive and will destroy any previous cluster configuration.Oracle Cluster Registry for cluster has already been initializedStartup will be queued to init within 30 seconds.Addin

9、g daemons to inittabExpecting the CRS daemons to be up within 600 seconds.CSS is active on these nodes.rac1rac2rac3CSS is active on all nodes.Waiting for the Oracle CRSD and EVMD to startWaiting for the Oracle CRSD and EVMD to startWaiting for the Oracle CRSD and EVMD to startWaiting for the Oracle

10、CRSD and EVMD to startWaiting for the Oracle CRSD and EVMD to startWaiting for the Oracle CRSD and EVMD to startWaiting for the Oracle CRSD and EVMD to startWaiting for the Oracle CRSD and EVMD to startWaiting for the Oracle CRSD and EVMD to startOracle CRS stack installed and running under init(1M)

11、Running vipca(silent) for configuring nodeappsCreating VIP application resource on (0) nodes.Creating GSD application resource on (0) nodes.Creating ONS application resource on (0) nodes.Starting VIP application resource on (2) nodes.Starting GSD application resource on (2) nodes.Starting ONS applic

12、ation resource on (2) nodes.Done.4、oraclerac1 $ cat $CRS_HOME/opmn/conf/ons.configlocalport=6113remoteport=6200loglevel=3useocr=onoraclerac1 $ $CRS_HOME/bin/racgons add_config rac3:6200oraclerac3 $ olsnodesrac1rac2rac3操作后，状态如下：oraclerac1 $ crs_stat -tNameTypeTarget State Hostora.SM1.asm applicationO

13、FFLINEOFFLINEora.C1 .l snr applicationONLINEONLINErac1ora.rac1.gsdapplicationONLINEONLINErac1ora.rac1.onsapplicationONLINEONLINErac1ora.rac1.vipapplicationONLINEONLINErac1ora.SM2.asm applicationOFFLINEOFFLINEora.C2 .l snr applicationONLI NEONLINErac2ora.rac2.gsdapplicationONLINEONLINErac2ora.rac2.on

14、sapplicationONLINEONLINErac2ora.rac2.vipapplicationONLINEONLINErac2ora.rac3.gsdapplicationONLINEONLINErac3ora.rac3.onsapplicationONLINEONLINErac3ora.rac3.vip applicationONLINEONLINErac3ora.racdb.db applicationOFFLINEOFFLINEora.b1.inst applicationOFFLINEOFFLINEora.b2.inst applicationOFFLINEOFFLINEora

15、.db_s.cs applicationOFFLINEOFFLINEora.db1.srv applicationOFFLINEOFFLINEora.db2.srv applicationOFFLINEOFFLINE5、Install Oracle RDBMS and ASM Home on the new node在第一个节点上操作以下：cd $ORACLE_HOME/oui/bin./addNode.sh完成后，执行：/oracle/app/product/10.2.0/db_1/root.sh rac36、Configure the Listener on the new NodeThe

16、 following steps need to be done on node3:$ORACLE_HOME/bin/netca只选择rac3进行配置6、Create an ASM Instance on the new node.The following steps need to be done on node1:Login as the Oracle user and set the environment to ASM home.$ORACLE_HOME/bin/dbca先配ASM，再建INSTANCE选择 instance managementadd instance创建完成后，状

17、态如下：oraclerac3 admin$ crs_stat -tNameTypeTarget State Hostora.SM1.asm applicationONLINEONLINErac1ora.C1.1 snr applicationONLINEONLINErac1ora.rac1.gsd applicationONLINEONLINErac1ora.rac1.ons applicationONLINEONLINErac1ora.rac1.vip applicationONLINEONLINErac1ora.SM2.asm applicationONLINEONLINErac2ora.

18、C2 .l snr applicationONLI NEONLINErac2ora.rac2.gsd applicationONLINEONLINErac2ora.rac2.ons applicationONLINEONLINErac2ora.rac2.vip applicationONLINEONLINErac2ora.SM3.asm applicationONLINEONLINErac3ora.C3 .l snr applicationONLI NEONLINErac3ora.rac3.gsd applicationONLINEONLINErac3ora.rac3.ons applicationONLINEONLINErac3ora.rac3.vip applicationONLINEONLINErac3ora.racdb.db applicationON