This discussion is archived
7 Replies Latest reply: Aug 28, 2011 11:46 AM by 832089 RSS

Why 11gR2 scan have limited maximum to 3 ips

832089 Newbie
Currently Being Moderated
Hi,

I am not able to get the answer that why 11gR2 SCAN has limitation to have min 1 and max 3 virtual IPs. As it's not dependent on number of nodes in ths cluster, any idea what's the logic behind it .

Regards,
Dheeraj Vaish
  • 1. Re: Why 11gR2 scan have limited maximum to 3 ips
    rajeysh Guru
    Currently Being Moderated
    refer the link:- this may help you,
    RAC SCAN confusion.
    Doubts on SCAN IP
  • 2. Re: Why 11gR2 scan have limited maximum to 3 ips
    832089 Newbie
    Currently Being Moderated
    Thanks a lot Rajyesh,

    It's really very helpful answer , but my question is still there that why and on which basis , oracle has limited max scan IP to 3 only.

    Regards,
    Dheeraj vaish
  • 3. Re: Why 11gR2 scan have limited maximum to 3 ips
    rajeysh Guru
    Currently Being Moderated
    Three IP addresses are recommended considering load balancing and high availability requirements regardless of the number of servers in the cluster. The IP addresses must be on the same subnet as your public network in the cluster.

    source:-http://www.oracle.com/technetwork/database/clustering/overview/scan-129069.pdf

    also refer the thread:Re: Are 3 IPs required for a SCAN in 11.2?
    Are 3 IPs required for a SCAN in 11.2?

    Edited by: rajeysh on Aug 24, 2011 12:42 PM
  • 4. Re: Why 11gR2 scan have limited maximum to 3 ips
    832089 Newbie
    Currently Being Moderated
    Hi Rajeysh,

    Thanks for sharing such a valuable link, but still i did not get my answer why scan VIP it limited to max. 3. Why not it 4,5,6 or some other number ? why it is 3 ?
  • 5. Re: Why 11gR2 scan have limited maximum to 3 ips
    Sebastian Solbach (DBA Community) Guru
    Currently Being Moderated
    Hi dheeraj,

    try setting up 4,5 or 6 in your DNS or ask your DNS administrator.
    Then you will know, why there are only 3.

    Regards
    Sebastian
  • 6. Re: Why 11gR2 scan have limited maximum to 3 ips
    Levi-Pereira Guru
    Currently Being Moderated
    Hi,
    dheeraj wrote:
    Hi Rajeysh,

    Thanks for sharing such a valuable link, but still i did not get my answer why scan VIP it limited to max. 3. Why not it 4,5,6 or some other number ? why it is 3 ?
    Why not do the same question differently.
    The Clusterware need more than 3 SCAN IP to provide high availability and load balancing? If you understand the concept and role of SCAN I believe you will know the right answer.

    For all SCAN Listener going down is necessary to fails the three nodes where are registered SCAN Listener at the same time. Even if this happens, the CRS should take less than one minute to register the the SCAN Listener on the nodes that remain active. (SCAN is a small piece of a large system that is already prepared for failures)

    Remember that SCAN IP does not establish connections with Oracle RAC, but manages and redirects connections to the nodes of the cluster. The connections are established using the Virtual IP (VIP). This means that if you stop all SCAN Listener/IP all connections that are already established are not affected, because they are using the VIP.

    Oracle version 11.2 use up to three IP, because the engineering team studied and understood that to ensure high availability and load balance is necessary 3 SCAN IP. (just it)
    It may be that this will change in the future but for now understand that 3 is enough to guarantee Grid Computing.

    We could ask another question, how many DNS servers (cluster / failover) you have in your environment to provide HA. If your answer is up to three nodes, what happens if the three DNS servers fail at the same time as it is a point of failure (SCAN/VIP works with DNS).


    This type of question leads us to Grid Computing.
    One way to think about grid computing is as the virtualization and pooling of IT resources—compute power, storage, network capacity, and so on—into a single set of shared services that can be provisioned or distributed, and then redistributed as needed.
    Just as an electric utility uses a grid to deal with wide variations in power demands without affecting customer service levels, grid computing provides IT resources with levels of control and adaptability that are transparent to end users, but that let IT professionals respond quickly to changing computing workloads.

    The entire infrastructure must be prepared to support failure. If your environment is designed to support multiple types of failures you will see that IP Scan 3 is enough.

    Regards,
    Levi Pereira

    Edited by: Levi Pereira on Aug 27, 2011 1:17 PM
  • 7. Re: Why 11gR2 scan have limited maximum to 3 ips
    832089 Newbie
    Currently Being Moderated
    Thanks a lot !!!

    Now I got the answer !!!

    //Dheeraj

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points