LOCAL_LISTENER in RAC 11gR2
Hi all,
I would like to verify if it is correct.
In the local_listener of the two nodes RAC database (no rac one node),
is better that it contains the node vip instead off node ip to improve the time to reconnect sessions.
Now:
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=10.*.*.*)(PORT=9120))
After change:
LOCAL_LISTENER
alter system set local_listener='VIP_NODE1:9120' scope=both sid='SID_NODEn';