加入收藏 | 设为首页 | 会员中心 | 我要投稿 财气旺网 - 财气网 (https://www.caiqiwang.com/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长百科 > 正文

更改oracle RAC public ip,vip,scan ip和private ip

发布时间:2021-01-23 23:05:58 所属栏目:站长百科 来源:网络整理
导读:更改oracle RAC public ip,vip,scan ip和private ip oifcfg - Oracle?接口配置工具 ? 用法:? oifcfg iflist [-p [-n]] ??????? oifcfg setif {-node?| -global} {/:}... ??????? oifcfg getif [-node?| -global] [ -if?[/] [-type?] ] ??????? oifcfg delif

?? ??? ?2.3.6修改SCAN VIP
?? ??? ??? ??? ?1.srvctl config scan 查看当前vip设置
?? ??? ??? ??? ??? ?config scan SCAN name: 192.168.128.100,Network: 1/192.168.128.0/255.255.255.0/en0 SCAN VIP name: scan1,IP: /scan-vip/192.168.128.100
?? ??? ??? ??? ?2.用root用户停止scan_listener 和sacn vip
?? ??? ??? ??? ??? ?$GRID_HOME/bin/srvctl stop scan_listener?
??????????????????? $GRID_HOME/bin/srvctl stop scan?
??????????????????? $GRID_HOME/bin/srvctl status scan
?? ??? ??? ??? ??? ?SCAN VIP scan1 is enabled SCAN VIP scan1 is not running
?? ??? ??? ??? ??? ?$GRID_HOME/bin/srvctl status scan_listener SCAN Listener LISTENER_SCAN1 is enabled SCAN listener LISTENER_SCAN1 is not running
?? ??? ??? ??? ?3.用root用户修改scan vip
?? ??? ??? ??? ??? ?$GRID_HOME/bin/srvctl modify scan -n10.76.31.111
?? ??? ??? ??? ?4.检查是否修改成功
?? ??? ??? ??? ??? ?config scan SCAN name: 10.76.31.111,Network: 1/10.76.31.0/255.255.255.0/en0 SCAN VIP name: scan1,IP: /scan-vip/10.76.31.111
?? ??? ??? ??? ?5.启动scan和scan_listener
?? ??? ??? ??? ??? ?$GRID_HOME/bin/srvctl start scan?
??????????????????? $GRID_HOME/bin/srvctl start scan_listener

?? ?3 修改 private ip?? ??? ?3.1 确保crs集群是打开的?? ??? ??? ??? ?可以用olsnodes –s 检查集群的状态?? ??? ??? ??? ?./olsnodes -s?? ??? ??? ??? ?P570a Active?? ??? ??? ??? ?P570b Active?? ??? ?3.2 用oifcfg getif 检查和oifcfg setif修改当前private 设置?? ??? ??? ?修改前设置?? ??? ??? ??? ?./oifcfg getif?? ??? ??? ??? ?en0 10.76.31.0 global public?? ??? ??? ??? ?en2 172.168.128.0 global cluster_interconnect?? ??? ??? ?修改private ip,新网络端口号为en8,如果没有修改端口号,则设置的值还是为en2?? ??? ??? ??? ?./oifcfg setif -global en8/192.76.31.0:cluster_interconnect?? ??? ??? ??? ?./oifcfg delif -global en2?? ??? ??? ?修改后设置?? ??? ??? ??? ?./oifcfg getif?? ??? ??? ??? ?en0 10.76.31.0 global public?? ??? ??? ??? ?en8 192.76.31.0 global cluster_interconnect?? ??? ?3.3 两边节点停止database和crs?? ??? ??? ??? ?./srvctl stop database -d gdcdc -o immedate?? ??? ??? ??? ?./crsctl stop crs?? ??? ??? ??? ?检查是否关闭?? ??? ??? ??? ?ps -ef|grep grid?? ??? ??? ??? ?ps -ef|grep oracle?? ??? ?3.4 修改两边节点/etc/hosts表?? ??? ??? ??? ?172.168.128.10 p570a-priv?? ??? ??? ??? ?172.168.128.11 p570b-priv?? ??? ??? ??? ?修改为?? ??? ??? ??? ?192.76.31.113 p570a-priv?? ??? ??? ??? ?192.76.31.115 p570b-priv?? ??? ?3.5 修改p570a节点 private ip?? ??? ??? ??? ?用smitty命令修改物理私网ip?? ??? ??? ??? ?smitty tcpip?? ??? ??? ??? ?选择en8?? ??? ??? ??? ?修改ip为 192.76.31.113 掩码为 255.255.255.0?? ??? ?3.6 修改P570b节点 private ip?? ??? ??? ??? ?用smitty命令修改物理私网ip?? ??? ??? ??? ?smitty tcpip?? ??? ??? ??? ?选择en8?? ??? ??? ??? ?修改ip为 192.76.31.115 掩码为 255.255.255.0?? ??? ?3.7 两边节点启动crs?? ??? ??? ??? ?crsctl start crs?? ??? ??? ??? ?检查资源组状态?? ??? ??? ??? ?crsctl status resource –t?? ??? ??? ??? ?如果都online,则没问题。?? ?4 实施总结?? ??? ??? ??? ?1. 在修改public ip时注意修改对应的正确网关,如果不修改,有可能导致vip服务起不来。?? ??? ??? ??? ?2. 注意检查修改hosts文件,因为改ip后,hosts文件会增加记录。?? ??? ??? ??? ??? ??? ?public ip对应的掩码也要修改正确,?? ??? ??? ??? ?3. 主机名在安装crs时要规划好,一旦装好后,就不能修改,否则要重新安装crs。?? ??? ??? ??? ?4. 11GR2 srvctl 新增 config vip命令?? ??? ??? ??? ?5. 修改private ip的顺序刚好和10gR2相反,10gR2是先关闭crs,然后修改hosts表和物理ip,再启动crs,用oifcfg 设置新私网ip,这点要注意,否则按10gR2修改私网的方法,会导致CRS集群起不来,所以做之前先做好备份。?? ??? ??? ??? ?6. 如果两边节点local_listener参数没修改的话,会导致客户端连接不到数据库报ERROR:ORA-12516: TNS: 监听程序找不到符合协议堆栈要求的可用处理程序,这是因为scan_listener 认到的还是修改前的vip原文:https://blog.csdn.net/weixin_34389926/article/details/85139489

(编辑:财气旺网 - 财气网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!