Re: TAF and node failover non RAC oracle 10.2

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

Other related posts: