2 Replies Latest reply: Apr 17, 2014 1:21 PM by BPeaslandDBA RSS

    Is it possible to reduce the number of scan ip addresses  in 11.2

    user11329369

      Hello,

       

      I would like to reduce the number of san ip addresses from 3 to 2, or from 3 to 1. This is on a 2 node Windows RAC.  It this possible?  If so how is it done?  I've searched and could not find a clear cut answer.

       

      Thanks

        • 1. Re: Is it possible to reduce the number of scan ip addresses  in 11.2
          Vandana B -Oracle

          Hi,

           

          Yes, it can be done however, the same is not recommended

           

          If you are using DNS then all you need to do is make the changes at the DNS level. And then at the cluster level just remove and add the scan resources back.

           

          srvctl remove scan_listener

          srvctl remove scan

           

          And then add the same back

           

          srvctl add scan -n <scan_name> [-k <network_number>] [-S <subnet>/<netmask>[/if1[|if2|...]]]

          srvctl add scan_listener [-l <lsnr_name_prefix>] [-s] [-p [TCP:]<port>[/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]]

           

          Also refer to the following

           

          Ref: How to update the IP address of the SCAN VIP resources (ora.scan<n>.vip) (Doc ID 952903.1)

          Ref: 11gR2 Grid Infrastructure Single Client Access Name (SCAN) Explained (Doc ID 887522.1)

           

          Regards,

          Vandana - Oracle

          • 2. Re: Is it possible to reduce the number of scan ip addresses  in 11.2
            BPeaslandDBA

            Well you definitely don't want to go down to 1 SCAN Listener. What happens if the one and only SCAN Listener crashes? Your end users won't be able to contact that single point of failure to be able to connect to an instance. One of the reasons for implementing RAC is for high availability. Intentionally introducing a single point of failure would be counter-intuitive here.

             

            Why do you want do to this anyway? Even if you have a 2-node cluster, having 3 SCAN listeners is not a resource problem. What is the reason you desire to make this change?

             

             

            Cheers,
            Brian