Re: Does SID always register with the listener?

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