Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Listener status shows 2 instances when only 1 exists

SnydsMar 12 2013 — edited Mar 12 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2013

Added on Mar 12 2013

#11g, #general-database-discussions, #listener

5 comments

3,998 views