4 Replies Latest reply: Mar 20, 2014 8:12 AM by ElMasry RSS

    Lsnrctl status not showing all instances

    ElMasry

      Hi all

       

      I have 7 node in my RAC , when i run lsnrctl status from any nodes i get different result

      i.e :

       

      Node 1 result


      LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 19-MAR-2014 15:17:59

       

       

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

       

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.195)(PORT=1521)))

      STATUS of the LISTENER

      ------------------------

      Alias                     LISTENER

      Version                   TNSLSNR for Linux: Version 10.2.0.5.0 - Production

      Start Date                18-MAR-2014 22:58:21

      Uptime                    0 days 16 hr. 19 min. 38 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora

      Listener Log File         /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.162.195)(PORT=1521)))

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.162.191)(PORT=1521)))

      Services Summary...

      Service "CLUSTER" has 3 instance(s).

        Instance "ORACLE1", status READY, has 2 handler(s) for this service...

        Instance "ORACLE6", status READY, has 1 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "FEEDBA" has 1 instance(s).

        Instance "ORACLE1", status READY, has 2 handler(s) for this service...

      Service "FEEDBA2" has 2 instance(s).

        Instance "ORACLE1", status READY, has 2 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "ORACLE" has 3 instance(s).

        Instance "ORACLE1", status READY, has 2 handler(s) for this service...

        Instance "ORACLE6", status READY, has 1 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "ORACLEXDB" has 3 instance(s).

        Instance "ORACLE1", status READY, has 1 handler(s) for this service...

        Instance "ORACLE6", status READY, has 1 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "ORACLE_XPT" has 3 instance(s).

        Instance "ORACLE1", status READY, has 2 handler(s) for this service...

        Instance "ORACLE6", status READY, has 1 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "PLSExtProc" has 1 instance(s).

        Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

      Service "WEB" has 3 instance(s).

        Instance "ORACLE1", status READY, has 2 handler(s) for this service...

        Instance "ORACLE6", status READY, has 1 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "fix_srv" has 1 instance(s).

        Instance "ORACLE6", status READY, has 1 handler(s) for this service...

      The command completed successfully

       

      Node 2 result :


      LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 19-MAR-2014 15:22:46

       

       

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

       

       

      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

      STATUS of the LISTENER

      ------------------------

      Alias                     LISTENER

      Version                   TNSLSNR for Linux: Version 10.2.0.5.0 - Production

      Start Date                19-MAR-2014 12:25:08

      Uptime                    0 days 2 hr. 57 min. 38 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora

      Listener Log File         /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbn2)(PORT=1521)))

      Services Summary...

      Service "CLUSTER" has 7 instance(s).

        Instance "ORACLE1", status READY, has 1 handler(s) for this service...

        Instance "ORACLE2", status READY, has 2 handler(s) for this service...

        Instance "ORACLE3", status READY, has 1 handler(s) for this service...

        Instance "ORACLE4", status READY, has 1 handler(s) for this service...

        Instance "ORACLE6", status READY, has 1 handler(s) for this service...

        Instance "ORACLE7", status READY, has 1 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "FEED" has 1 instance(s).

        Instance "ORACLE2", status READY, has 2 handler(s) for this service...

      Service "FEEDBA" has 3 instance(s).

        Instance "ORACLE1", status READY, has 1 handler(s) for this service...

        Instance "ORACLE3", status READY, has 1 handler(s) for this service...

        Instance "ORACLE4", status READY, has 1 handler(s) for this service...

      Service "FEEDBA2" has 4 instance(s).

        Instance "ORACLE1", status READY, has 1 handler(s) for this service...

        Instance "ORACLE3", status READY, has 1 handler(s) for this service...

        Instance "ORACLE4", status READY, has 1 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "METASTOCK" has 2 instance(s).

        Instance "ORACLE3", status READY, has 1 handler(s) for this service...

        Instance "ORACLE4", status READY, has 1 handler(s) for this service...

      Service "ORACLE" has 7 instance(s).

        Instance "ORACLE1", status READY, has 1 handler(s) for this service...

        Instance "ORACLE2", status READY, has 2 handler(s) for this service...

        Instance "ORACLE3", status READY, has 1 handler(s) for this service...

        Instance "ORACLE4", status READY, has 1 handler(s) for this service...

        Instance "ORACLE6", status READY, has 1 handler(s) for this service...

        Instance "ORACLE7", status READY, has 1 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "ORACLEXDB" has 7 instance(s).

        Instance "ORACLE1", status READY, has 1 handler(s) for this service...

        Instance "ORACLE2", status READY, has 1 handler(s) for this service...

        Instance "ORACLE3", status READY, has 1 handler(s) for this service...

        Instance "ORACLE4", status READY, has 1 handler(s) for this service...

        Instance "ORACLE6", status READY, has 1 handler(s) for this service...

        Instance "ORACLE7", status READY, has 1 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "ORACLE_XPT" has 7 instance(s).

        Instance "ORACLE1", status READY, has 1 handler(s) for this service...

        Instance "ORACLE2", status READY, has 2 handler(s) for this service...

        Instance "ORACLE3", status READY, has 1 handler(s) for this service...

        Instance "ORACLE4", status READY, has 1 handler(s) for this service...

        Instance "ORACLE6", status READY, has 1 handler(s) for this service...

        Instance "ORACLE7", status READY, has 1 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "WEB" has 6 instance(s).

        Instance "ORACLE1", status READY, has 1 handler(s) for this service...

        Instance "ORACLE3", status READY, has 1 handler(s) for this service...

        Instance "ORACLE4", status READY, has 1 handler(s) for this service...

        Instance "ORACLE6", status READY, has 1 handler(s) for this service...

        Instance "ORACLE7", status READY, has 1 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "fix_srv" has 2 instance(s).

        Instance "ORACLE2", status READY, has 2 handler(s) for this service...

        Instance "ORACLE6", status READY, has 1 handler(s) for this service...

      The command completed successfully

       

      Node 6 result :

      LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 19-MAR-2014 15:14:02

       

       

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

       

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.189)(PORT=1521)))

      STATUS of the LISTENER

      ------------------------

      Alias                     LISTENER

      Version                   TNSLSNR for Linux: Version 10.2.0.5.0 - Production

      Start Date                19-MAR-2014 15:06:44

      Uptime                    0 days 0 hr. 7 min. 18 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      ON

      Listener Parameter File   /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora

      Listener Log File         /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.162.189)(PORT=1521)))

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.162.185)(PORT=1521)))

      Services Summary...

      Service "CLUSTER" has 2 instance(s).

        Instance "ORACLE6", status READY, has 2 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "FEEDBA2" has 1 instance(s).

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "ORACLE" has 2 instance(s).

        Instance "ORACLE6", status READY, has 2 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "ORACLEXDB" has 2 instance(s).

        Instance "ORACLE6", status READY, has 1 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "ORACLE_XPT" has 2 instance(s).

        Instance "ORACLE6", status READY, has 2 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "PLSExtProc" has 1 instance(s).

        Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

      Service "WEB" has 2 instance(s).

        Instance "ORACLE6", status READY, has 2 handler(s) for this service...

        Instance "ORACLE8", status READY, has 1 handler(s) for this service...

      Service "fix_srv" has 1 instance(s).

        Instance "ORACLE6", status READY, has 2 handler(s) for this service...

      The command completed successfully

       

      ---------------------------------------------------------------------------------

       

      Any advice about above please

      Thanks in advance

        • 1. Re: Lsnrctl status not showing all instances
          Tom321

          Hi,

           

          check the parameter remote_listener in the instances. On 10g this could be e.g. for your "CLUSTER"-DB: LISTENERS_CLUSTER

          This entry should be resolved in your tnsnames.ora on each node and you should find an address list pointing to all 6 remote nodes. Check if you have all 6 nodes correctly specified on each node.

           

          Regards

          Thomas

          • 2. Re: Lsnrctl status not showing all instances
            ElMasry

            Thanks TOM321

             

            When i checked this parameter i found the same result in all nodes like :

             

            Name               Type               Value

            --------               ---------               ----------

            remote_listener           string               ORACLE

             

            ------------------------------------------------------

            And below an example of my tnsname.ora at all nodes :

             

            # tnsnames.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

            # Generated by Oracle configuration tools.

             

             

            ORACLE =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn1-v)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn2-v)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn3-v)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn4-v)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn5-v)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn6-v)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn7-v)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn8-v)(PORT = 1521))

                  (LOAD_BALANCE = yes)

                )

                (CONNECT_DATA =

                  (SERVER = DEDICATED)

                  (SERVICE_NAME = ORACLE)

                )

              )

             

             

            ORACLE8 =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn8-v)(PORT = 1521))

                )

                (CONNECT_DATA =

                  (SERVICE_NAME = ORACLE)

                )

              )

             

             

            ORACLE7 =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn7-v)(PORT = 1521))

                )

                (CONNECT_DATA =

                  (SERVER = DEDICATED)

                  (SERVICE_NAME = ORACLE)

                  (INSTANCE_NAME = ORACLE7)

                )

              )

             

             

            ORACLE6 =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn6-v)(PORT = 1521))

                )

                (CONNECT_DATA =

                  (SERVER = DEDICATED)

                  (SERVICE_NAME = ORACLE)

                  (INSTANCE_NAME = ORACLE6)

                )

              )

             

             

            ORACLE5 =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn5-v)(PORT = 1521))

                )

                (CONNECT_DATA =

                  (SERVER = DEDICATED)

                  (SERVICE_NAME = ORACLE)

                  (INSTANCE_NAME = ORACLE5)

                )

              )

             

             

            ORACLE4 =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn4-v)(PORT = 1521))

                )

                (CONNECT_DATA =

                  (SERVER = DEDICATED)

                  (SERVICE_NAME = ORACLE)

                  (INSTANCE_NAME = ORACLE4)

                )

              )

             

             

            ORACLE3 =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn3-v)(PORT = 1521))

                )

                (CONNECT_DATA =

                  (SERVER = DEDICATED)

                  (SERVICE_NAME = ORACLE)

                  (INSTANCE_NAME = ORACLE3)

                )

              )

             

             

            ORACLE2 =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn2-v)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn2-v)(PORT = 1522))

                )

                (CONNECT_DATA =

                  (SERVER = DEDICATED)

                  (SERVICE_NAME = ORACLE)

                  (INSTANCE_NAME = ORACLE2)

                )

              )

             

             

            ORACLE1 =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn1-v)(PORT = 1521))

                )

                (CONNECT_DATA =

                  (SERVER = DEDICATED)

                  (SERVICE_NAME = ORACLE)

                  (INSTANCE_NAME = ORACLE1)

                )

              )

             

             

            LCL_LSNR =

              (ADDRESS_LIST =

                (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.196)(PORT = 1521))

              )

             

             

            ORACLEDRS =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = drs-dbn1)(PORT = 1521))

                )

                (CONNECT_DATA =

                  (SERVICE_NAME = ORACLEDRS)

                )

              )

             

             

            DELL6300 =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.195)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.196)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.197)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.198)(PORT = 1521))

                )

                (CONNECT_DATA =

                  (SERVICE_NAME = oracle)

                )

              )

             

             

            ORA2 =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.192)(PORT = 1545))

                )

                (CONNECT_DATA =

                  (SERVICE_NAME = ORACLE)

                )

              )

             

             

            CLUS2NODES =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.241)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.242)(PORT = 1521))

                )

                (CONNECT_DATA =

                  (SERVICE_NAME = ORACLE)

                )

              )

             

             

            LISTENERS_ORACLE =

              (ADDRESS_LIST =

                (ADDRESS = (PROTOCOL = TCP)(HOST = dbn1-v)(PORT = 1521))

                (ADDRESS = (PROTOCOL = TCP)(HOST = dbn2-v)(PORT = 1521))

                (ADDRESS = (PROTOCOL = TCP)(HOST = dbn3-v)(PORT = 1521))

                (ADDRESS = (PROTOCOL = TCP)(HOST = dbn4-v)(PORT = 1521))

                (ADDRESS = (PROTOCOL = TCP)(HOST = dbn5-v)(PORT = 1521))

                (ADDRESS = (PROTOCOL = TCP)(HOST = dbn6-v)(PORT = 1521))

              )

             

             

            EXTPROC_CONNECTION_DATA =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

                )

                (CONNECT_DATA =

                  (SID = PLSExtProc)

                  (PRESENTATION = RO)

                )

              )

             

             

            STREAM =

              (DESCRIPTION =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.195)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.196)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.197)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.198)(PORT = 1521))

                )

                (CONNECT_DATA =

                  (SERVICE_NAME = ORACLE)

                )

              )

             

             

            ----------------------------------------------------------------------------------------------------

             

            Thanks again

            • 3. Re: Lsnrctl status not showing all instances
              Tom321

              Hi,

               

              use this entry for your remote_listener parameter:

              LISTENERS_ORACLE =

                (ADDRESS_LIST =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn1-v)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn2-v)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn3-v)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn4-v)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn5-v)(PORT = 1521))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dbn6-v)(PORT = 1521))

                )

               

              alter system set remote_listener='LISTENERS_ORACLE'

              alter system register

               

              Then you should have all instances on all listener.

              Your ORACLE entry is good for the clients connecting to the DBs, but not for the remote listener registration. With the LOAD_BALANCE set, your dbs choose one random remote node to register. That could be 7x the same node and will be random each time the instance registers. With your config you should find each instance registered one time at an random node, but not one time at each node.

               

              Regards

              Thomas

              • 4. Re: Lsnrctl status not showing all instances
                ElMasry

                Thanks Tom321

                 

                Working fine now.