服务端配置scan ip
节点1确认当前监听状态
SQL> show parameter listener;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=
192.168.0.118)(PORT=1521))
remote_listener string
节点2 确认当前监听状态
SQL> show parameter listener;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=
192.168.0.119)(PORT=1521))
remote_listener string
节点1、节点2 只有本地监听。本地监听的地址 都是 VIP
节点1 修改 remote_listener 为 scan 地址
SQL> alter system set remote_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.120)(PORT=1521))';
System altered.
SQL> alter system register;
System altered.
确认以上操作
SQL> show parameter listener;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=
192.168.0.118)(PORT=1521))
remote_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=1
92.168.0.120)(PORT=1521))
节点2 修改 remote_listener 为 scan 地址
SQL> alter system set remote_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.120)(PORT=1521))';
System altered.
SQL> alter system register;
System altered.
确认以上操作
SQL> show parameter listener;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=
192.168.0.119)(PORT=1521))
remote_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=1
92.168.0.120)(PORT=1521))
客户端 连接 SCAN_IP
