[三思笔记]ORACLE 10gR2 RAC环境增加及删除节点

[三思笔记]-Oracle10gR2RAC环境增加及删除节点君三思QQ群：77830934ORACLEORACLEORACLEORACLE10gR210gR210gR210gR2RACRACRACRAC环境增加及删除节点环境增加及删除节点环境增加及删除节点环境增加及删除节点2009-11-10君三思一、初始化第3台节点.............................................................................................................21.1配置hosts文件............................................................................................................21.2配置SSH密钥认证....................................................................................................31.3配置ASM共享盘.......................................................................................................4二、添加clusterware到新节点................................................................................................52.1检查安装环境..............................................................................................................52.2安装clusterware到新节点.........................................................................................7三、复制oracle软件到新节点...............................................................................................14四、配置监听服务到新节点...................................................................................................18五、添加实例到新节点...........................................................................................................25六、移除节点...........................................................................................................................316.1删除DATABASE实例.............................................................................................316.2删除ASM实例.........................................................................................................366.3删除节点....................................................................................................................36附：三思笔记系列文章快速链接：.......................................................................................43[三思笔记]-Oracle10gR2RAC环境增加及删除节点君三思QQ群：77830934RAC是项非常优秀的特性，其前身OPS从oracle6即开始提供，自9i版本更名为RAC后，经过这么多年的完善已经非常的成熟和稳定。使用RAC特性能够有效的提升企业数据库系统的可用性，并有效增强整个系统的负载能力。考虑到数据规模的不断增长，最初设计良好的系统随着业务量的增大可能会逐渐不勘负担，如果是RAC环境的数据库，就可以考虑通过增加节点的方式，来提升该配环境的负载能力。本文将通过示例演示，对现有的RAC数据库环境增加节点的相关操作。这里我们的操作基于一套双节点的RAC环境。在本文正式开始前，俺先假设要添加的节点已安装好操作系统；内核参数已经进行修改；ORACLE用户已初始化；成功并正确的配置和共享存储；相关rpm包均已安装；与当前RAC环境中各节点互联互通等等吧。提示：新节点需要进行的准备工作，可以参考三思笔记系列文章：手把手教你用VMwareVMwareVMwareVMware在linuxlinuxlinuxlinux下安装oracle10goracle10goracle10goracle10gRACRACRACRAC中配置linux环境相关章节内容。一、初始化第一、初始化第一、初始化第一、初始化第3333台节点台节点台节点台节点即使是添加节点，那么首先就需要对新节点进行适当的配置，以使其能够满足成为RAC环境中一员的需要。1.11.11.11.1配置hostshostshostshosts文件执行命令如下：[root@jssdbn2~]#vi/etc/hosts修改hosts文件中的内容，修改完成后，hosts文件中至少包含下列的内容：192.168.10.11jssdbn1192.168.10.12jssdbn2192.168.10.13jssdbn3192.168.10.21jssdbn1-vip192.168.10.22jssdbn2-vip192.168.10.23jssdbn3-vip10.10.10.101jssdbn1-priv10.10.10.102jssdbn2-priv10.10.10.103jssdbn3-priv注意，这里不仅新增加的节点中hosts文件需要修改，同一个RAC环境中所有节点的hosts文件都必须重新修改。[三思笔记]-Oracle10gR2RAC环境增加及删除节点君三思QQ群：778309341.21.21.21.2配置SSHSSHSSHSSH密钥认证RAC环境中各节点间不仅时刻保持通讯，而且还有可能互访文件，因此必须要保证各节点间访问不需输入DBA手动密码即可自动完成，这里我们通过配置SSH来实现这一点。首先是在新增加的节点时操作，即jssdbn3节点(注意执行命令的用户)：[root@jssdbn3~]#susususu----oracleoracleoracleoracle[oracle@jssdbn3~]$mkdirmkdirmkdirmkdir~/.ssh~/.ssh~/.ssh~/.ssh[oracle@jssdbn3~]$chmodchmodchmodchmod700700700700~/.ssh~/.ssh~/.ssh~/.ssh[oracle@jssdbn3~]$ssh-keygenssh-keygenssh-keygenssh-keygen-t-t-t-trsarsarsarsaGeneratingpublic/privatersakeypair.Enterfileinwhichtosavethekey(/home/oracle/.ssh/id_rsa):Enterpassphrase(emptyfornopassphrase):Entersamepassphraseagain:Youridentificationhasbeensavedin/home/oracle/.ssh/id_rsa.Yourpublickeyhasbeensavedin/home/oracle/.ssh/id_rsa.pub.Thekeyfingerprintis:37:89:ec:6a:49:2d:18:5d:9d:c2:7c:66:84:b0:2e:94oracle@jssdbn3[oracle@jssdbn3~]$ssh-keygenssh-keygenssh-keygenssh-keygen-t-t-t-tdsadsadsadsaGeneratingpublic/privatedsakeypair.Enterfileinwhichtosavethekey(/home/oracle/.ssh/id_dsa):Enterpassphrase(emptyfornopassphrase):Entersamepassphraseagain:Youridentificationhasbeensavedin/home/oracle/.ssh/id_dsa.Yourpublickeyhasbeensavedin/home/oracle/.ssh/id_dsa.pub.Thekeyfingerprintis:43:f1:b1:9f:e6:ec:b5:b0:74:72:24:22:22:5c:24:caoracle@jssdbn3然后转至jssdbn1节点执行，也是以oracle身份进行操作(执行过程中，当访问远端节点时可能需要输入目标节点的密码)：[oracle@jssdbn1~]$sshsshsshsshjssdbn3jssdbn3jssdbn3jssdbn3catcatcatcat~/.ssh/id_rsa.pub~/.ssh/id_rsa.pub~/.ssh/id_rsa.pub~/.ssh/id_rsa.pub~/.ssh/authorized_keys~/.ssh/authorized_keys~/.ssh/authorized_keys~/.ssh/authorized_keysTheauthenticityofhost'jssdbn3(192.168.10.13)'can'tbeestablished.RSAkeyfingerprintis95:23:18:7a:5b:a9:5f:48:d7:1e:1a:f9:01:ec:f0:b1.Areyousureyouwanttocontinueconnecting(yes/no)?yesWarning:Permanentlyadded'jssdbn3,192.168.10.13'(RSA)tothelistofknownhosts.oracle@jssdbn3'spassword:[oracle@jssdbn1~]$sshsshsshsshjssdbn3jssdbn3jssdbn3jssdbn3catcatcatcat~/.ssh/id_dsa.pub~/.ssh/id_dsa.pub~/.ssh/id_dsa.pub~/.ssh/id_dsa.pub~/.ssh/authorized_keys~/.ssh/authorized_keys~/.ssh/authorized_keys~/.ssh/authoriz