Re: Does SID always register with the listener?

Mark, if I do that the instance won't register with any listener at all. I
do want it to register with the FINNTESTSB service name, just not the
FINNTEST service/instance name.

Fairlie, I looked at that note. If I follow that advice I end up in the same
situation Mark's reply puts me in. My instance won't register any service
names with any listeners at all.

LS, thanks for the reply. I'm still hoping there's a parameter somewhere
that can be set that turns off the instance name from registering with the
listener and just use the service name(s) as configured.

FYI, here's the problem I'm trying to solve. My client has a lot of
databases configured with dataguard. They use the instance name as the
service name to connect to the primary and DNS to change which instance/host
(current primary or standby after a failover) to connect to. They want to
reconfigure that setup to use TAF for faster failovers. If I don't make any
changes other than change tnsnames.ora to have multiple addresses (i.e. TAF)
the result is if the first address happens to be the standby (like it would
be after a switchover) then that is the database the TAF config connects to
and the user gets an error (database shutdown or init in progress). To avoid
that I follow metalink # 316740.1 which says to configure the primary with 2
service names and the standby with 1. I can't follow the example 100% since
my client uses the actual instance name as the service name in all their
apps. As a result my (test) primary is configured with service names as
FINNTEST (instance name) and FINNTESTPR (primary) and the standby is
configured with just FINNTESTSB (standby). However, the standby also
registers FINNTEST (instance name) with the listener and as a result I'm
back to square 1. My TAF tnsnames.ora config may send the user to the
current standby first and the user gets an error when trying to log in.

If I can't turn off the instance name registration for the standby while
still maintaining the service name registration, then I'm left with only the
option of changing the apps to connect to a different service name than the
instance name. This is a huge undertaking when we're taking dozens of
databases/apps.

So I'm still hoping for the silver bullet.......

Finn


On 2/26/08, fairlie rego <fairlie_r@xxxxxxxxx> wrote:
>
> 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 <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
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
>
>    *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.<http://au.rd.yahoo.com/mail/taglines/au/y7mail/gmail/*http://au.yahoo.com/y7mail/?p1=ni&p2=general&p3=tagline&p4=gmail>.
>
>
>

Other related posts: