5 Replies Latest reply: Apr 14, 2014 1:47 AM by 1809668 RSS

    primary and standby - scan listener port and DB listener port

    1809668

      Hi,

       

      I have two node RAC(11.2.0.3) on Windows 2008R2 and this is going to serve as primary database. We have defined scan Listener and DB Listener port as 1521. Now we are going to set standby database in two node RAC on Virtual machines. In standby database both scan listener port and DB listener port should be same (1521) as primary or should we give another port number.

        • 1. Re: primary and standby - scan listener port and DB listener port
          Vandana B -Oracle

          Hi,

           

          The port for both scan as well as node listener can be set to the same value.

           

          The end point comprises of the combination of both IP+port, so for the listeners not to conflict with each other, as long as this combination is unique, there is no issue. (conclusion, you can have both scan and node listener running on the same port)

           

          Regards,

          Vandana - Oracle

          • 2. Re: primary and standby - scan listener port and DB listener port
            1809668

            Thanks Vandana for the information. Is it possible to change the IP address for either SCAN Listener or DB Listener.  I am going to set the SCAN listener and DB Listener port as 1521 in Physical standby database as well. As for the information you provided this should also be the acceptable. Please provide your view on this.

            • 3. Re: primary and standby - scan listener port and DB listener port
              846411

              Hi,

              To change your scan_listener port use below command.

               

               

              $ srvctl modify scan_listener -p 1521

               

               

               

              Restart your SCAN

               

               

               

               

               

              You can check the status of SCAN_LISTENER.

               

               

              $ srvctl config scan_listener

               

               

              SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521

              SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521

              SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521

               

               

               

              You will also have to change the remote_listener value if there is one set.

               

               

              $ sqlplus / as sysdba

              SQL> alter system set remote_listener=’scan.xyz.com:1521′ scope=both;

               

               

               

              Change the client tnsnames.ora file

               

              Regards,

              Atif Iqbal.

              • 4. Re: primary and standby - scan listener port and DB listener port
                Vandana B -Oracle

                Hi,

                 

                Is it possible to change the IP address for either SCAN Listener or DB Listener.


                Yes it is possible to change the IP of scan and DB listener.

                 

                For scan all you need to do is to remove the scan resource

                 

                srvctl remove scan_listener

                srvctl remove scan

                 

                Once done make the changes at the OS level (in DNS or hosts file) whichever is being used and add the scan resources 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>]]

                 

                 

                Or if you have a different set of IP's configured then you can do the following without removing and adding the resources back

                 

                srvctl modify scan -n <scan_name>

                srvctl modify scan_listener {-u|-p [TCP:]<port>[/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]}

                 

                And similarly you can also modify the IP details for node listener as follows

                 

                srvctl modify nodeapps {[-n <node_name> -A <new_vip_address>/<netmask>[/if1[|if2|...]]] | [-S <subnet>/<netmask>[/if1[|if2|...]]]} [-u {static|dhcp|mixed}] [-e <em-port>] [ -l <ons-local-port> ] [-r <ons-remote-port> ] [-t <host>[:<port>][,<host>[:<port>]...]] [-v]

                srvctl modify listener [-l <lsnr_name>] [-o <oracle_home>] [-p "[TCP:]<port>[, ...][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]"] [-u <oracle_user>] [-k <net_num>]

                 

                I am going to set the SCAN listener and DB Listener port as 1521 in Physical standby database as well. As for the information you provided this should also be the acceptable. Please provide your view on this.

                 

                Yes, this is acceptable, you can proceed with the same

                 

                 

                I hope the above answers your question.

                 

                Regards,

                Vandana - Oracle

                • 5. Re: primary and standby - scan listener port and DB listener port
                  1809668

                  Thanks Vandana and Atif for the information provided.