Database - RAC/Scalability (MOSC)

MOSC Banner

LOCAL_LISTENER in RAC 11gR2

edited Dec 13, 2018 11:33AM in Database - RAC/Scalability (MOSC) 6 commentsAnswered ✓

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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center