Oracle 11g R2 RAC TAF server configuration
Oracle RACFailover details: http://www.51CTO reminds you, do not spam ads! / bbs/thread-31215-1-1.html
How To Configure Server Side TransparentApplication Failover [ID 460982.1]
1. Create a TAFService
[oracle@db1 bin] $. / srvctl add service-d orcl-s server_taf-r "orcl1,orcl2"-P BASIC
Orcl here is database name,orcl1 and orcl2 is instance name.
two。 Start the server_taf service
[oracle@db1 bin] $. / srvctl start service-d orcl-s server_taf
3. Check the operation of service
[oracle@db1 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 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 service registration:
[oracle@db1 bin] $lsnrctl services
LSNRCTL for Linux: Version 11.2.0.3.0-Production on 15-JUL-2012 13:26:43
Copyright (c) 1991, 2011, 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, has 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, has 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, has 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, has 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 side 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
[oracle@db1 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
