Re: Does SID always register with the listener?
- From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- To: finn.oracledba@xxxxxxxxx
- Date: Tue, 26 Feb 2008 11:30:25 -0500
Finn,
Did you try to play with db_unique_name parameter on the standby ?
--romas
On 2/26/08, Finn Jorgensen <finn.oracledba@xxxxxxxxx> wrote:
>
> 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:
