5 Replies Latest reply: Mar 11, 2013 8:20 PM by 922844 RSS

    why scan listener has only 1 instance registered ?

    922844
      hi all ,
      i met this problem these days

      my environment RAC03 has 2 nodes : RAC03A and RAC03B

      using "lsnrctl services" checked the local listener, i found there are too many request established on RAC03A, but RAC03B has quite few request……

      then i checked the scan listener

      RAC03A —————————————————————————————————————
      [grid@F5PRAC03A:/u01/app/11.2.0/grid/network/admin]$ lsnrctl status listener_scan1

      LSNRCTL for HPUX: Version 11.2.0.3.0 - Production on 11-MAR-2013 13:01:35

      Copyright (c) 1991, 2011, Oracle. All rights reserved.

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER_SCAN1
      Version TNSLSNR for HPUX: Version 11.2.0.3.0 - Production
      Start Date 07-MAR-2013 16:14:16
      Uptime 3 days 20 hr. 47 min. 20 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
      Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/F5PRAC03A/listener_scan1/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.27.125.81)(PORT=1521)))
      Services Summary...
      Service "F5PPERF" has 1 instance(s).
      Instance "F5PPERF1", status READY, has 1 handler(s) for this service...
      Service "F5PPERFXDB" has 1 instance(s).
      Instance "F5PPERF1", status READY, has 1 handler(s) for this service...
      The command completed successfully

      RAC03B ———————————————————————————————————————
      [grid@F5PRAC03B:/home/grid]$ lsnrctl status listener_scan1

      LSNRCTL for HPUX: Version 11.2.0.3.0 - Production on 11-MAR-2013 13:25:13

      Copyright (c) 1991, 2011, Oracle. All rights reserved.

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER_SCAN1
      Version TNSLSNR for HPUX: Version 11.2.0.3.0 - Production
      Start Date 05-FEB-2013 10:11:51
      Uptime 34 days 3 hr. 13 min. 22 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
      Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/F5PRAC03B/listener_scan1/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.27.125.81)(PORT=1521)))
      Services Summary...
      Service "F5PPERF" has 1 instance(s).
      Instance "F5PPERF2", status READY, has 1 handler(s) for this service...
      Service "F5PPERFXDB" has 1 instance(s).
      Instance "F5PPERF2", status READY, has 1 handler(s) for this service...
      The command completed successfully

      i thought there's something wrong with the scan listener , because when i checked RAC01, the scan listener is

      RAC01 ——————————————————————————————————————
      [grid@F5PRAC01A:/u01/app/11.2.0/grid/network/admin]$ lsnrctl status listener_scan1

      LSNRCTL for HPUX: Version 11.2.0.3.0 - Production on 11-MAR-2013 13:28:31

      Copyright (c) 1991, 2011, Oracle. All rights reserved.

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER_SCAN1
      Version TNSLSNR for HPUX: Version 11.2.0.3.0 - Production
      Start Date 28-JAN-2013 15:25:19
      Uptime 41 days 22 hr. 3 min. 12 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
      Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/F5PRAC01A/listener_scan1/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.27.125.69)(PORT=1521)))
      Services Summary...
      Service "F5POMU" has 2 instance(s).
      Instance "F5POMU1", status READY, has 1 handler(s) for this service...
      Instance "F5POMU2", status READY, has 1 handler(s) for this service...
      The command completed successfully

      the service has two instance registerd on RAC01, but RAC03 is not.

      i tried " alter system register " in two nodes, but it's no use at all :(

      how could i add the other instance on RAC03 registered in the scan_listener?

      thanks a lot!
        • 1. Re: why scan listener has only 1 instance registered ?
          JohnWatson
          What you are describing does not look possible. You run this
          [grid@F5PRAC03A:/u01/app/11.2.0/grid/network/admin]$ lsnrctl status listener_scan1
          which suggests that listener_scan1 is running on node F5PRAC03A and then you run this
          [grid@F5PRAC03B:/home/grid]$ lsnrctl status listener_scan1 
          which suggests that listener_scan1 is runnign on node F5PRAC03B. Also, the listening address of your listener_scan1 changes from this
          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.27.125.81)(PORT=1521)))
          to this
          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.27.125.69)(PORT=1521)))
          .

          What is going on? On which node and address is listener_scan1 actually running?
          • 2. Re: why scan listener has only 1 instance registered ?
            922844
            hi, john
            thanks for reply

            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.27.125.69)(PORT=1521))) this is RAC01's listener_scan1, RAC01 is fine

            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.27.125.81)(PORT=1521))) this is RAC03's istener_scan1, and i thought it has something wrong

            i check the status of RAC03's scan_listener, the result is
            ————————————————————————————————
            [grid@F5PRAC03B:/home/grid]$ srvctl status scan_listener
            SCAN Listener LISTENER_SCAN1 is enabled
            SCAN listener LISTENER_SCAN1 is running on node f5prac03b

            it's actually running on RAC03B
            • 3. Re: why scan listener has only 1 instance registered ?
              922844
              but i can run
              "lsnrctl status listener_scan1" on each nodes of RAC03 (RAC03B and RAC03B) successfully ...

              check the process...

              [grid@F5PRAC03A:/home/grid]$ ps -ef | grep lsn
              grid 3505 1 0 Feb 5 ? 1329:53 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit
              grid 15951 1 0 Mar 7 ? 0:30 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit
              grid 15089 13694 0 16:40:23 pts/0 0:00 grep lsn

              [grid@F5PRAC03B:/home/grid]$ ps -ef | grep lsn
              grid 25756 1 0 Jan 8 ? 658:11 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit
              grid 3783 26258 0 16:40:38 pts/1 0:00 grep lsn
              grid 3172 1 0 16:39:38 ? 0:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit

              it seems LISTENER_SCAN1 running on both of them ...
              ... strange...

              Edited by: user11923138 on 2013-3-11 上午1:41
              • 4. Re: why scan listener has only 1 instance registered ?
                JohnWatson
                I think you need to make reality match what the clusterware believes. How about this:
                srvctl stop scan_listener -f
                srvctl stop scan -f
                then kill any scan tns processes that are still running anywhere. Then restart the scan and the scan listeners.

                This shouldn't affect any of your connected sessions, and might help the clusterware to get its head together.
                --
                John Watson
                Oracle Certified Master DBA
                http://skillbuilders.com
                • 5. Re: why scan listener has only 1 instance registered ?
                  922844
                  i did what you said

                  1) stop scan_listener and scan
                  2) kill the listener_scan1 process on RAC03A
                  3) start scan and scan_listener

                  then i checked the status of scan_listener
                  at first , the scan_listener on RAC03B still had 1 instance registered (the local instance),

                  so i rebooted the OS(RAC03A)
                  after that , it finally works!

                  now the scan_listener on RAC03B has 2 instances registered(the local one and the remote one)

                  [grid@F5PRAC03B:/home/grid]$ lsnrctl status listener_scan1

                  LSNRCTL for HPUX: Version 11.2.0.3.0 - Production on 12-MAR-2013 09:08:28

                  Copyright (c) 1991, 2011, Oracle. All rights reserved.

                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
                  STATUS of the LISTENER
                  ------------------------
                  Alias LISTENER_SCAN1
                  Version TNSLSNR for HPUX: Version 11.2.0.3.0 - Production
                  Start Date 12-MAR-2013 08:49:02
                  Uptime 0 days 0 hr. 19 min. 26 sec
                  Trace Level off
                  Security ON: Local OS Authentication
                  SNMP OFF
                  Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
                  Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/F5PRAC03B/listener_scan1/alert/log.xml
                  Listening Endpoints Summary...
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.27.125.81)(PORT=1521)))
                  Services Summary...
                  Service "F5PPERF" has 2 instance(s).
                  Instance "F5PPERF1", status READY, has 1 handler(s) for this service...
                  Instance "F5PPERF2", status READY, has 1 handler(s) for this service...
                  Service "F5PPERFXDB" has 2 instance(s).
                  Instance "F5PPERF1", status READY, has 1 handler(s) for this service...
                  Instance "F5PPERF2", status READY, has 1 handler(s) for this service...
                  The command completed successfully

                  thanks very much, john :)