Re: Issue with SCAN listener relocating

Posted by ErmanArslansOracleBlog on Dec 24, 2019; 9:09am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Issue-with-SCAN-listener-relocating-tp7968p7969.html

1. even Node1 have all 3 SCAN listener registere to the instance but i still see sessions On NOde2, why ?

- ANSWER: That's expected. That's because scan listeners redirect the connections to local listeners.. So the local listeners of both node 1 and node2 are registered with your scan listeners running on node 1 and those scan listeners redirect to connections to the nodes (to the local listeners on nodes) according to the load.

2. sir secondly when i try to relocate one SCAN listener to Node2 so am successfull but recive an error.

-ANSWER: Probably you have a misconfiguration in the hosts file or ip addresses that scan listeners are configured to use. (SCAN VIPs)

*Anything changed recently? Is this a new installation? Does this issue start to appear after a failover or reboot? Anyting changed with the RAC ip configurations?

In order to investigate this, we need the following from both of the nodes->

*crsctl status res -t
*lsnrctl status <SCAN_LISTENER_NAME> (for all the scan listeners)
*crsctl stat res -p |grep ENDPOINTS
*Scan listener logs.
*srvctl config scan
*ifconfig outputs

IMPORTANT NOTE : Don't upload log files and outputs that contain the hostnames or ip addresses the servers of your company. Mask your logs and outputs before sending them to me.
I would like to underline that I accept no responsibility about this. The risk is yours..