Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.