Re: TAF and node failover non RAC oracle 10.2

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@xxxxxxxxx> wrote:
>
> On Jan 31, 2008 9:19 AM, Jakub Wartak <vnulllists@xxxxxxxxxxxx> 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@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

Other related posts: