On Jun 28, 9:22 pm, Mladen Gogala <mgogala.SPAM_ME...._at_verizon.net>
wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
thx
Received on Sun Jul 01 2007 - 21:25:30 CDT
