5 Replies Latest reply: Mar 12, 2013 10:51 AM by Uwehesse-Oracle RSS

    Listener status shows 2 instances when only 1 exists

    Snyds
      Greetings All,

      I just moved a database to a new server/host and was troubleshooting a problem I had with Enterprise Manager, and ran the command “lsnrctl status”. See results below.
      C:\Users\xxxxx>lsnrctl
      
      LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 12-MAR-2013 09:23:09
      
      Copyright (c) 1991, 2010, Oracle.  All rights reserved.
      
      Welcome to LSNRCTL, type "help" for information.
      
      LSNRCTL> status
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
      STATUS of the LISTENER
      ------------------------
      Alias                     LISTENER
      Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
      Start Date                11-MAR-2013 15:54:43
      Uptime                    0 days 17 hr. 28 min. 32 sec
      Trace Level               off
      Security                  ON: Local OS Authentication
      SNMP                      OFF
      Listener Parameter File   C:\Oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
      Listener Log File         c:\oracle\diag\tnslsnr\473247-db1\listener\alert\log.xml
      Listening Endpoints Summary...
        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=473247-db1.sr.net)(PORT=1521)))
      Services Summary...
      Service "CLRExtProc" has 1 instance(s).
        Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "prod01.sr.net" has 2 instance(s).
        Instance "prod01", status UNKNOWN, has 1 handler(s) for this service...    <<<<<<<<<<<<<<<<<<<  ????
        Instance "prod01", status READY, has 1 handler(s) for this service...
      Service "prod01XDB.sr.net" has 1 instance(s).
        Instance "prod01", status READY, has 1 handler(s) for this service...
      The command completed successfully
      LSNRCTL> exit
      Why does the service "prod01.sr.net" have/show 2 instances? There is only 1 instance running on this machine/host/box?


      During my troubleshooting the EM problem, I had added the following code to the listener.ora SID_LIST_LISTENER section, and re-started the LISTENER service. I was thinking that my EM problem had to do with the database not registering itself with the listener:
          (SID_DESC =
            (GLOBAL_DBNAME = prod01.sr.net)
            (ORACLE_HOME = C:\Oracle\product\11.2.0\dbhome_1)
            (SID_NAME = prod01)
          )
      How can I correct this?

      I think I should somehow remove the instance with a status of UNKNOWN (see <<<<<<<<<<<<<< ???? above).

      Any recommendations please?

      Thanks,
      Bob