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_at_yahoo.com> 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_at_gmail.com>* 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_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
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
>
> *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>.
>
>
>

--
http://www.freelists.org/webpage/oracle-l