Re: TAF and node failover non RAC oracle 10.2

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 31 Jan 2008 14:31:08 +0000
Message-ID: <7765c8970801310631pf26c6c1pa110b03cce84fb99@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 31 2008 - 08:31:08 CST

Original text of this message