I am not clear on number of SCAN IP require for multi node RAC.
Oracle recommends minimum 3 SCAN IP for gird software even if we have 2 node RAC.
say for example if I am having 6 node or 8 node RAC then how many SCAN IP should I configure on my grid environment.
Oracle recommend 3 (no more, no less) regardless of the number of nodes in the cluster.
I agree that 2 would seem logical for a 2 node RAC, but I actually use 3 no matter what the numbers are.
The SCAN does not point you to the node you will use. It is just a cluster alias that allows you to use a single address to contact the cluster. Any connections requests are handed off to the listeners in the normal way, so the SCA listeners are just an entry point into the cluster.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 1 guest