Re: Does SID always register with the listener?

From: LS Cheng <exriscer_at_gmail.com>
Date: Tue, 26 Feb 2008 08:40:45 +0100
Message-ID: <6e9345580802252340s10025d7cve0984d84326da92b@mail.gmail.com>


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_at_gmail.com>
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_at_gmail.com> 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_at_gmail.com> 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 <http://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 <http://finntest.ceg.corp.net/>" has 1
> > > instance(s).
> > > Instance "FINNTEST", status READY, has 1 handler(s) for this
> > > service...
> > > Service "FINNTESTSB.CEG.CORP.NET <http://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
> > >
> > >
> > >
> >
> >
>
-- http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 26 2008 - 01:40:45 CST

Original text of this message