Re: TAF and node failover non RAC oracle 10.2
Date: Thu, 31 Jan 2008 10:51:53 -0500
Message-ID: <611ad3510801310751j68eea5fdkbfea9fd4a2a1b0d7@mail.gmail.com>
Yes - for non-RAC databases you can just set the SERVICE_NAMES parameter.
In RAC you should never set this parameter.
However each time you add a new service with SERVICE_NAMES, Oracle adds a new entry into the data dictionary (visible in ALL_SERVICES) -- and removing the service from the init param only "disables" it but doesn't remove it from the DD. You have to use DBMS_SERVICE to "delete" a service. There's a finite amount of space for these - after about 100 services Oracle runs out of space and stops tracking new services -- you won't see them in the AWR.
Also, FYI, in 10.2.0.1 it was a bit buggy to use DBMS_SERVICE to start and stop services.
(Page 4 - http://www.ardentperf.com/pub/services-schneider07.pdf )
-Jeremy
On 1/31/08, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
>
> On Jan 31, 2008 9:19 AM, Jakub Wartak <vnulllists_at_pcnet.com.pl> wrote:
>
> >
> >
> > Yes it can. I have done it for (own, non-commercial) educational
> > purposes with
> > DataGuard (with Fast-Start Failover). The trick is to have additional
> > SERVICE_NAME registered to listener using DBMS_SERVICE.START_SERVICE
> > from
> > AFTER DATABASE STARTUP trigger.
> >
>
> Isn't this just a question of setting the service_names parameter rather
> than an after startup trigger
>
> SYS @ db11g >show parameter service_names
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> service_names string db11g.lambeth.gov.uk
>
> SYS @ db11g >alter system set service_names='db11g.lambeth.gov.uk
> ,my_service.lambeth.gov.uk';
> System altered.
> SYS @ db11g >startup force;
> ORACLE instance started.
> Total System Global Area 1071333376 bytes
> Fixed Size 1337972 bytes
> Variable Size 717227404 bytes
> Database Buffers 348127232 bytes
> Redo Buffers 4640768 bytes
> Database mounted.
> Database opened.
> SYS @ db11g >host lsnrctl services
> LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 31-JAN-2008
> 14:25:47
> Copyright (c) 1991, 2007, Oracle. All rights reserved.
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
> Services Summary...
> Service "db11g.lambeth.gov.uk" has 1 instance(s).
> Instance "db11g", status READY, has 1 handler(s) for this service...
> Handler(s):
> "DEDICATED" established:0 refused:0 state:ready
> LOCAL SERVER
> Service "db11gXDB.lambeth.gov.uk" has 1 instance(s).
> Instance "db11g", status READY, has 1 handler(s) for this service...
> Handler(s):
> "D000" established:0 refused:0 current:0 max:1022 state:ready
> DISPATCHER <machine: BTGG42J, pid: 5912>
> (ADDRESS=(PROTOCOL=tcp)(HOST=BTGG42J.lambeth.gov.uk)(PORT=3667))
> Service "db11g_XPT.lambeth.gov.uk" has 1 instance(s).
> Instance "db11g", status READY, has 1 handler(s) for this service...
> Handler(s):
> "DEDICATED" established:0 refused:0 state:ready
> LOCAL SERVER
> Service "my_service.lambeth.gov.uk" has 1 instance(s).
> Instance "db11g", status READY, has 1 handler(s) for this service...
> Handler(s):
> "DEDICATED" established:0 refused:0 state:ready
> LOCAL SERVER
> The command completed successfully
>
> SYS @ db11g >conn niall_at_my_service
> Enter password:
> Connected.
> Session altered.
> NIALL @ my_service >
>
>
>
>
> >
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > http://www.orawin.info
>
>
-- Jeremy Schneider Chicago, IL http://www.ardentperf.com/category/technical -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 31 2008 - 09:51:53 CST