Oracle 11g R2 RAC TAF server-side configuration

Oracle Racfailover: Http://www.51CTO remind you not to spam ads!/bbs/thread-31215-1-1.html

How to Configure Server Side transparentapplication Failover [ID 460982.1]

1. Create Tafservice

[Email protected] bin]$./srvctl add service-d orcl-s server_taf-r "Orcl1,orcl2"-p BASIC

The ORCL here are the database NAME,ORCL1 and Orcl2 are instance name.

2. Start the SERVER_TAF service

[Email protected] bin]$/srvctl start service-d orcl-s server_taf

3. Check service performance

[Email protected] bin]$/srvctl config service-d orcl

Service Name:server_taf

Service is enabled

Server Pool:orcl_server_taf

Cardinality:2

Disconnect:false

Service role:primary

Management policy:automatic

DTP Transaction:false

AQ HA Notifications:false

Failover Type:none

Failover Method:none

TAF Failover retries:0

TAF Failover delay:0

Connection Load Balancing Goal:long

Runtime Load Balancing Goal:none

TAF Policy Specification:basic

Edition:

Preferred Instances:orcl1,orcl2

Available instances:

4. Confirm Serviceid

Sql> Select name,service_id from dba_services where name = ' Server_taf ';

nameservice_id

--------------------------------------------------------------------------

Server_taf3

5. Add parameters to the service:

Sql> Execute dbms_service.modify_service (service_name = ' Server_taf '-

, Aq_ha_notifications = true-

, Failover_method = Dbms_service.failover_method_basic-

, Failover_type = Dbms_service.failover_type_select-

, failover_retries = 180-

, Failover_delay = 5-

, clb_goal = Dbms_service.clb_goal_long);

6. Confirm the parameter modification:

Col name format A15

Col failover_method format A11 heading ' method '

Col failover_type format A10 heading ' type '

Col failover_retries format 9999999 heading ' retries '

Col Goal format A10

Col clb_goal format A8

Col aq_ha_notifications format A5 heading ' Aqnot '

Sql> select Name, Failover_method,failover_type, Failover_retries,goal, clb_goal,aq_ha_notifications from Dba_ Services where service_id = 3;

Namemethodtyperetries Goalclb_goal Aqnot

--------------- ----------- ------------------ ---------- -------- -----

server_tafbasicselect180 Nonelongyes

Sql>

7. Check the service registration status:

[Email protected] bin]$ LSNRCTL Services

Lsnrctl for linux:version 11.2.0.3.0-production on 15-jul-2012 13:26:43

Copyright (c) 1991, Oracle.all rights reserved.

Connecting to (Description= (address= (protocol=tcp) (HOST=DB1) (port=1521)))

Services Summary ...

Service "+asm" has 1 instance (s).

Instance "+asm1", status ready, have 1 handler (s) for thisservice ...

Handler (s):

"Dedicated" established:57 refused:0 State:ready

LOCAL SERVER

Service "ORCL" has 1 instance (s).

Instance "ORCL1", status ready, have 1 handler (s) for thisservice ...

Handler (s):

"Dedicated" Established:11 refused:0 State:ready

LOCAL SERVER

Service "Orclxdb" has 1instance (s).

Instance "ORCL1", status ready, have 1 handler (s) for thisservice ...

Handler (s):

"D000" established:0 refused:0 current:0 max:1022 state:ready

DISPATCHER

(Address= (PROTOCOL=TCP) (host=db1.tianlesoftware.com) (port=38731))

Service "Server_taf" has 1instance (s).

Instance "ORCL1", status ready, have 1 handler (s) for thisservice ...

Handler (s):

"Dedicated" Established:11 refused:0 State:ready

LOCAL SERVER

The command completed successfully

8. The client can use SERVICE-SIDETAF:

On the client TNS configuration:

ORCL =

(description=

(Address= (PROTOCOL=TCP) (host= orcl.tianlesoftware.com) (port=1521))

(Connect_data=

(server=dedicated)

(SERVICE_NAME=ORCL)

)

)

--Orcl.tianlesoftware.com is the scan IP address.

9. View process Status

[Email protected] bin]$./crs_stat-t

Nametypetargetstatehost

------------------------------------------------------------

Ora. Data.dgora....up.type ONLINEONLINEDB1

Ora. Fra.dgora....up.type ONLINEONLINEDB1

Ora .... Er.lsnr Ora....er.type ONLINEONLINEDB1

Ora .... N1.lsnr Ora....er.type ONLINEONLINEDB2

Ora .... N2.lsnr Ora....er.type ONLINEONLINEDB1

Ora .... N3.lsnr Ora....er.type ONLINEONLINEDB1

Ora. Ocr.dgora....up.type ONLINEONLINEDB1

Ora.asmora.asm.typeONLINEONLINEdb1

Ora .... Sm1.asm APPLICATIONONLINEONLINEDB1

Ora .... 01.lsnr APPLICATIONONLINEONLINEDB1

ORA....-01.GSD Applicationofflineoffline

Ora....-01.ons APPLICATIONONLINEONLINEDB1

ORA....-01.VIP Ora....t1.type ONLINEONLINEDB1

Ora .... Sm2.asm APPLICATIONONLINEONLINEDB2

Ora .... 02.lsnr APPLICATIONONLINEONLINEDB2

ORA....-02.GSD Applicationofflineoffline

Ora....-02.ons APPLICATIONONLINEONLINEDB2

ORA....-02.VIP Ora....t1.type ONLINEONLINEDB2

Ora.cvuora.cvu.typeONLINEONLINEdb1

Ora.gsdora.gsd.typeOFFLINEOFFLINE

Ora....network Ora....rk.type ONLINEONLINEDB1

Ora.oc4jora.oc4j.typeONLINEONLINEdb1

Ora.onsora.ons.typeONLINEONLINEdb1

Ora.orcl.dbora....se.type ONLINEONLINEDB1

Ora....taf.svc Ora....ce.type ONLINEONLINEDB1

Ora.scan1.vipora....ip.type ONLINEONLINEDB2

Ora.scan2.vipora....ip.type ONLINEONLINEDB1

Ora.scan3.vipora....ip.type ONLINEONLINEDB1

Oracle 11g R2 RAC TAF server-side configuration