Re: TAF and node failover non RAC oracle 10.2
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: vnulllists@xxxxxxxxxxxx
- Date: Thu, 31 Jan 2008 14:31:08 +0000
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:
