Listener Issue in RAC Environment (Services are not registerd in Listener)

If you are facing connection issue in RAC environment then check the both SID and service name is registered in database. Please follow the below steps.

Solution:

Node1 

alter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=<vip of node1>)(PORT=1521))' scope=both SID='TEST1';
alter system register;

(Replace "<vip of node1>" with VIP of node1)

Node2

alter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=<vip of node2>)(PORT=1521))' scope=both SID='TEST2';
alter system register;

(Replace "<vip of node2>" with VIP of node2)


Check the staus from one by one nodes.

Node1

$lsnrctl status LISTENER

Node2

$lsnrctl status LISTENER

**************************************************************************