Listener shows 2 instances per service?

From: Alexander Skwar <alexander_at_skwar.name>
Date: Fri, 5 Jan 2007 12:04:31 +0100
Message-ID: <1a1hcqggdvago$.dlg@std.dialog.schweiz.digitalprojects.com>

Hello!

I'm trying to understand what "lsnrctl" shows me and have a hard time to grasp it.

When I login as "oracle" OS user, I start the listener control utility by running "lsnrctl". I then start the LISTENER by running "start" and get:

LSNRCTL> start
Starting /opt/apps/oracle/product/9.2.04/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 9.2.0.4.0 - Production System parameter file is /opt/apps/oracle/product/9.2.04/network/admin/listener.ora Log messages written to /opt/apps/oracle/product/9.2.04/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=winds06.win.ch.da.rtr)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=winds06.win.ch.da.rtr)(PORT=1521))) STATUS of the LISTENER

---

Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 9.2.0.4.0 - Production
Start Date                05-JAN-2007 11:50:10
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /opt/apps/oracle/product/9.2.04/network/admin/listener.ora
Listener Log File         /opt/apps/oracle/product/9.2.04/network/log/listener.log

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=winds06.win.ch.da.rtr)(PORT=1521)))
Services Summary...
Service "RACE002" has 1 instance(s).
  Instance "RACE002", status UNKNOWN, has 1 handler(s) for this service... Service "RACEA1" has 1 instance(s).
  Instance "RACEA1", status UNKNOWN, has 1 handler(s) for this service... Service "RACEB1" has 1 instance(s).
  Instance "RACEB1", status UNKNOWN, has 1 handler(s) for this service... Service "RACEP1" has 1 instance(s).
  Instance "RACEP1", status UNKNOWN, has 1 handler(s) for this service... Service "RACEREF1" has 1 instance(s).
  Instance "RACEREF1", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully

So there's just 1 instance per service - fine!

A few seconds later, I ran "status" and got:

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=winds06.win.ch.da.rtr)(PORT=1521))) STATUS of the LISTENER

---

Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 9.2.0.4.0 - Production
Start Date                05-JAN-2007 11:50:10
Uptime                    0 days 0 hr. 0 min. 44 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /opt/apps/oracle/product/9.2.04/network/admin/listener.ora
Listener Log File         /opt/apps/oracle/product/9.2.04/network/log/listener.log

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=winds06.win.ch.da.rtr)(PORT=1521)))
Services Summary...
Service "RACE002" has 2 instance(s).
  Instance "RACE002", status UNKNOWN, has 1 handler(s) for this service...   Instance "RACE002", status READY, has 1 handler(s) for this service... Service "RACEA1" has 2 instance(s).
  Instance "RACEA1", status UNKNOWN, has 1 handler(s) for this service...   Instance "RACEA1", status READY, has 1 handler(s) for this service... Service "RACEB1" has 2 instance(s).
  Instance "RACEB1", status UNKNOWN, has 1 handler(s) for this service...   Instance "RACEB1", status READY, has 1 handler(s) for this service... Service "RACEP1" has 2 instance(s).
  Instance "RACEP1", status UNKNOWN, has 1 handler(s) for this service...   Instance "RACEP1", status READY, has 1 handler(s) for this service... Service "RACEREF1" has 2 instance(s).
  Instance "RACEREF1", status UNKNOWN, has 1 handler(s) for this service...   Instance "RACEREF1", status READY, has 1 handler(s) for this service... The command completed successfully

Hm. Why are there now 2 instances per service?

I haven't set up the server or databases myself and am trying to understand what the former admin did here. In the internal documentation I cannot find anything reg. this and there's also just one database host here.

It would be great if somebody could help me here.

Thanks a lot,

Alexander Skwar Received on Fri Jan 05 2007 - 05:04:31 CST