2 Replies Latest reply: Apr 2, 2013 4:01 AM by Alex Kwok RSS

    Bug fix

    imran khan
      Hi all,

      Is there a fix for the bug 13798847 on oracle 11.2.0.3 .

      Bug 13798847 : ADD MULTILPLE PORTS TO SCAN_LISTENER FAILS


      I have searched but dint find anything.



      Regards,
      Imran Khan
        • 1. Re: Bug fix
          Billy~Verreynne
          imran khan wrote:

          Is there a fix for the bug 13798847 on oracle 11.2.0.3 .
          Bug 13798847 : ADD MULTILPLE PORTS TO SCAN_LISTENER FAILS
          Is it a bug? The command line syntax explicitly states that a single port per protocol.
          [grid@dev1 /home/grid] srvctl add  scan_listener -h
          
          Adds a SCAN listener listening on the given endpoints.
          
          Usage: srvctl add scan_listener [-l <lsnr_name_prefix>] [-s] [-p [TCP:]<port>[/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]] 
              -l <lsnr_prefix>         SCAN listener name prefix
              -s                       Skip the checking of ports
              -p [TCP:]<port>[/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]           SCAN Listener endpoints
              -h                       Print usage
          Now if this listed multiple ports support for the TCP and TCPS protocols, then it would have been a bug as the SCAN Listener does not provide that support.

          So instead of a bug, I would say this is an feature issue. The feature is single port per protocol. And implemented as such.

          If you want to use multiple ports, you can look at configuring NAT using iptables - and masquerade SCAN IP connections on port 1527 to port 1521 on the same IP. Example in {message:id=9660828}.
          • 2. Re: Bug fix
            Alex Kwok
            I have tested the multi port with TCP and TCPS. When I add multi ports on TCP, it fails to add. But I can add multi port on TCPS without problem. It should allow to add the multi ports on the same protocol.


            [grid@rhel63 ~]$ srvctl modify scan_listener -p TCP:1521/TCP:1522/TCPS:1523/TCPS:1524
            PRCS-1035 : Invalid number of TCP ports (2) for SCAN Listener
            [grid@rhel63 ~]$ srvctl modify scan_listener -p TCP:1521/TCPS:1523/TCPS:1524
            [grid@rhel63 ~]$ srvctl stop scan_listener
            [grid@rhel63 ~]$ srvctl start scan_listener
            [grid@rhel63 ~]$ srvctl config scan_listener
            SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521/TCPS:1523,1524
            SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521/TCPS:1523,1524
            SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521/TCPS:1523,1524
            [grid@rhel63 ~]$


            So, how can I add multi ports on TCP on 11.2.0.3? BOTH GI and RDMBS are the same version with the latest patch.