1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

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

Discussion in 'General' started by Tariq Bashir Malhi, Apr 1, 2011.

  1. Tariq Bashir Malhi

    Tariq Bashir Malhi Forum Advisor

    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    80
    We have two instances in our database(backupdb) (1) EXDB (2) SCBA, both start normally in the morning, but after some time one of instance SCBA stop replying, then i have to restart database again to resolve the issue, after this the problem do not reoccur for the rest of day. I could only find one suspected entry in listener status output where it say Instance "scba", status UNKNOWN, has 1 handler(s) for this service... How to resolve this issue.........

    Code (Text):

    oracle@backupdb:~/11g/network/admin$ lsnrctl status
     
    Code (Text):

    LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 31-MAR-2011 11:55:21
     
    Copyright (c) 1991, 2007, Oracle.  All rights reserved.
     
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=backupdb)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for Linux: Version 11.1.0.6.0 - Production
    Start Date                31-MAR-2011 10:58:21
    Uptime                    0 days 0 hr. 56 min. 59 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   /home/oracle/11g/network/admin/listener.ora
    Listener Log File         /home/oracle/diag/tnslsnr/backupdb/listener/alert/log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=backupdb)(PORT=1521)))
    Services Summary...
    Service "exdb" has 1 instance(s).
      Instance "exdb", status READY, has 1 handler(s) for this service...
    Service "exdbXDB" has 1 instance(s).
      Instance "exdb", status READY, has 1 handler(s) for this service...
    Service "exdb_XPT" has 1 instance(s).
      Instance "exdb", status READY, has 1 handler(s) for this service...
    Service "scba" has 1 instance(s).
      Instance "scba", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
     
    Code (Text):

    less /home/oracle/11g/network/admin/listener.ora
     
    Code (Text):

    # listener.ora Network Configuration File: /home/oracle/11g/network/admin/listener.ora
    # Generated by Oracle configuration tools.
     
    SID_LIST_LISTENER =
      (SID_LIST =
        (SID_DESC =
          (GLOBAL_DBNAME = scba)
          (ORACLE_HOME = /home/oracle/11g)
          (SID_NAME = scba)
        (SID_DESC =
          (GLOBAL_DBNAME = exdb)
          (ORACLE_HOME = /home/oracle/11g)
          (SID_NAME = exdb)
      )
        )
      )
     
    EM_LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = backupdb)(PORT = 1522))
        )
      )
     
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = backupdb)(PORT = 1521))
        )
      )

     
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    The UNKNOWN status is set because the instance is hard-coded into the listener.ora file; there should also be a similar entry for exdb so each database, when running, should have two entries, one with a status of UNKNOWN and one with a status of READY (for the autoregistered instance). Your instance scba is not registering with the listener after restart; execute "alter system register;" while connected as SYS AS SYSDBA and see what lsnrctl status reports. The issue may be a known bug with 11.1.0.6 (you should patch this installation to 11.1.0.7 to address all of the bugs affecting 11.1.0.6).

    Simply having an entry reported by lsnrctl status as UNKNOWN is not a problem; the issue is the fact that you do NOT have a similar entry for exdb as it's also hard-coded into the listener.ora file.