Re: TAF and node failover non RAC oracle 10.2
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 bytesDatabase 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-lReceived on Thu Jan 31 2008 - 08:31:08 CST