前半生
<Oracle优化新常态>第一章
<Oracle优化新常态>第二章强拆(1)
<Oracle优化新常态>第二章强拆(2)
<Oracle优化新常态>第三章 三大配置
<Oracle优化新常态>第四章 分库分表
<Oracle优化新常态> 第五章 急诊法
<Oracle优化新常态> 第六章 SQL优化大法
<Oracle优化新常态> 第七章 五大禁止
<Oracle优化新常态> 第八章 WHO-IT方法简介
<Oracle优化新常态> 第九章 7X24两面人
进入主题,开始增配scan ip
1、修改rac所有节点的/etc/hosts信息
[grid@db1 ~]$ vi /etc/hosts
127.0.0.1 localhost
10.138.129.101 db1
10.138.129.102 db2
10.138.129.103 db1-vip
10.138.129.104 db2-vip
192.168.20.1 db1-priv
192.168.20.2 db2-priv
10.138.129.105 scan-ip
10.138.129.106 scan-ip ---------新增的scanIP
10.138.129.107 scan-ip ---------新增的scanIP
2、停止scan 监听,注意先听监听才能停scan
[grid@db1 ~]$ srvctl stop scan_listener
[grid@db1 ~]$ srvctl stop scan
[grid@db1 ~]$srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running
3、配置scan,注意需要用root权限执行
[root@db1 bin]# pwd
/u01/app/11.2.0/grid/bin
[root@db1 bin]# ./srvctl modify scan -n scan-ip
-----修改scan信息,-n 后面接 hosts中的san ip 网络名
[root@db1 bin]# ./srvctl modify scan_listener -u
------添加scanIP的监听,若不执行该命令,将只有一个listener_scan1监听,执行后将根据scan ip数自动增加listener_scan2,listener_scan3.
4、启动scan
[grid@db1 ~]$ srvctl start scan
[grid@db1 ~]$ srvctl start scan_listener
[grid@db1 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node db1
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node db2
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node db1
[grid@db1 ~]$ srvctl config scan
SCAN name: scan-ip, Network: 1/10.138.129.0/255.255.255.0/eth2
SCAN VIP name: scan1, IP: /scan-ip/10.138.129.105
SCAN VIP name: scan2, IP: /scan-ip/10.138.129.106
SCAN VIP name: scan3, IP: /scan-ip/10.138.129.107
[grid@db1 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node db1
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node db2
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node db1