Listener services ...XDB and XTP
495848Jan 29 2010 — edited Jan 29 2010My listener show that I have services that look like $SIDXDB and $SID_XPT which listener.ora file doesn't show. From where are these services comming from and what they are for?
*[oracle@ora-db admin]$ lsnrctl status*
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 29-JAN-2010 16:12:47
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora-db.domain.org)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 28-JAN-2010 17:24:39
Uptime 0 days 22 hr. 48 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora-db.domain.org)(PORT=1521)))
Services Summary...
Service "PROD" has 2 instance(s).
Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PRODXDB" has 1 instance(s).
Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully