Re: is the result "lsnrctl status" correct ?

On Thu, 28 Jun 2007 11:27:25 +0000, Jacqueline wrote:

> LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production on
> 28-JUN-2007 18:59:52
>
> Copyright (c) 1991, 2005, Oracle. All rights reserved.
>
> Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the
> LISTENER
> ------------------------
> Alias listener_s2 Version TNSLSNR
> for IBM/AIX RISC System/6000: Version 10.2.0.2.0 - Production
> Start Date 11-JUN-2007 19:26:06 Uptime
> 16 days 23 hr. 33 min. 47 sec Trace Level off
> Security ON: Local OS Authentication SNMP
> ON
> Listener Parameter File /oracle/products/10.2/db/network/admin/
> listener.ora
> Listener Log File /oracle/products/10.2/db/network/log/
> listener_s2.log
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.243.213.244)
> (PORT=1521)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.243.213.243)
> (PORT=1521)))
> Services Summary...
> Service "SYS$SYS.KUPC$C_2_20070628021607.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$C_2_20070628021611.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$C_2_20070628021614.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$C_2_20070628021621.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$C_2_20070628021626.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$C_2_20070628021631.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$C_2_20070628021635.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$C_2_20070628021641.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$S_2_20070625205212.DGDB" has 1 instance(s).
> Instance "dgdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$S_2_20070628021607.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$S_2_20070628021611.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$S_2_20070628021614.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$S_2_20070628021621.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$S_2_20070628021623.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$S_2_20070628021626.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$S_2_20070628021630.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$S_2_20070628021631.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$S_2_20070628021635.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "SYS$SYS.KUPC$S_2_20070628021641.SZDB" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "dgdb" has 1 instance(s).
> Instance "dgdb2", status READY, has 1 handler(s) for this service...
> Service "dgdb_XPT" has 1 instance(s).
> Instance "dgdb2", status READY, has 1 handler(s) for this service...
> Service "gzdb" has 1 instance(s).
> Instance "gzdb2", status READY, has 1 handler(s) for this service...
> Service "gzdb_XPT" has 1 instance(s).
> Instance "gzdb2", status READY, has 1 handler(s) for this service...
> Service "szdb" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> Service "szdb_XPT" has 1 instance(s).
> Instance "szdb2", status READY, has 1 handler(s) for this service...
> The command completed successfully
>
>
> is the result correct? what is " SYS$SYS.KUPC* " ?

Jacqueline, this result is undoubtedly correct. The "KUPC" tables are queue tables for Streams. Apparently, you using STREAMS replication for something and the capture process has set up its own service.

-- 
http://www.mladen-gogala.com