Re: TAF and node failover non RAC oracle 10.2
- From: "Jeremy Schneider" <jeremy.schneider@xxxxxxxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- Date: Thu, 31 Jan 2008 10:51:53 -0500
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:
