And what happens if you set local_listener to DUMMY (say) as mentioned in ML Note:235562.1 I haven't tried this on 10.2.0.3 but it sure used to disable automatic registration in 9i Thanks Fairlie LS Cheng <exriscer@xxxxxxxxx> wrote: No, I dont think there is anyway to turn that off.... Thanks -- LSC On Tue, Feb 26, 2008 at 4:31 AM, Finn Jorgensen <finn.oracledba@xxxxxxxxx> wrote: Yes I see that. My question is if it can be turned off? Finn On Mon, Feb 25, 2008 at 4:52 PM, LS Cheng <exriscer@xxxxxxxxx> wrote: Hi There is always a default service which defaults to SID name Thanks -- LSC On Mon, Feb 25, 2008 at 10:18 PM, Finn Jorgensen <finn.oracledba@xxxxxxxxx> wrote: Does the SID of a database ALWAYS register itself with the listener even if the service_name parameter is set to a different name than the SID? I have this configuration : FINNTEST> show parameter local NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ local_listener string FINNTESTSB FINNTEST> show parameter service NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ service_names string FINNTESTSB.CEG.CORP.NET listener.ora : FINNTESTSB = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = v240-msw-14.ceg.corp.net)(PORT = 1557)) ) ) ) and get this : lsnrctl stat FINNTESTSB LSNRCTL for Solaris: Version 10.2.0.3.0 - Production on 25-FEB-2008 16:04:09 Copyright (c) 1991, 2006, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=v240-msw-14.ceg.corp.net)(PORT=1557))) STATUS of the LISTENER ------------------------ Alias FINNTESTSB Version TNSLSNR for Solaris: Version 10.2.0.3.0 - Production Start Date 25-FEB-2008 15:21:44 Uptime 0 days 0 hr. 42 min. 25 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracle/network/ladmin/listener.ora Listener Log File /oracle/product/10.2.0.3/network/log/finntestsb.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=v240-msw-14.ceg.corp.net)(PORT=1557))) Services Summary... Service "FINNTEST.CEG.CORP.NET" has 1 instance(s). Instance "FINNTEST", status READY, has 1 handler(s) for this service... Service "FINNTESTSB.CEG.CORP.NET" has 1 instance(s). Instance "FINNTEST", status READY, has 1 handler(s) for this service... The command completed successfully Is there a way to get rid of the SID registration? Finn Fairlie Rego Senior Oracle Consultant http://el-caro.blogspot.com/ M: +61 402 792 405 --------------------------------- Get the name you always wanted with the new y7mail email address..