Oracle11gR2RACTAF服務(wù)端配置

Oracle RACFailover 詳解：http://www.51CTO提醒您，請勿濫發(fā)廣告!/bbs/thread-31215-1-1.html

我們提供的服務(wù)有：網(wǎng)站設(shè)計制作、網(wǎng)站設(shè)計、微信公眾號開發(fā)、網(wǎng)站優(yōu)化、網(wǎng)站認(rèn)證、松原ssl等。為上1000家企事業(yè)單位解決了網(wǎng)站和推廣的問題。提供周到的售前咨詢和貼心的售后服務(wù)，是有科學(xué)管理、有技術(shù)的松原網(wǎng)站制作公司

How To Configure Server Side TransparentApplication Failover [ID 460982.1]

1．創(chuàng)建TAFService

[oracle@db1 bin]$ ./srvctl add service -d orcl -s server_taf -r "orcl1,orcl2" -P BASIC

--這里的orcl是database name，orcl1和orcl2 是instance name。

2. 啟動server_taf服務(wù)

[oracle@db1 bin]$ ./srvctl start service -d orcl -s server_taf

3. 檢查service運(yùn)行情況

[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.確認(rèn)serviceID

SQL> select name,service_id from dba_services where name = 'server_taf';

NAMESERVICE_ID

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

server_taf3

5.給service添加參數(shù)：

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. 確認(rèn)參數(shù)修改：

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. 檢查service注冊情況：

[oracle@db1 bin]$ lsnrctl services

LSNRCTL for Linux: Version 11.2.0.3.0 -Production on 15-JUL-2012 13:26:43

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. 客戶端就可以使用Service-SideTAF了：

在客戶端TNS 配置：

orcl =

(DESCRIPTION=

(ADDRESS=(PROTOCOL=tcp)(HOST= orcl.tianlesoftware.com)(PORT=1521))

(CONNECT_DATA=

(SERVER=DEDICATED)

(SERVICE_NAME=orcl)

)

-- orcl.tianlesoftware.com是SCAN IP地址。

9.查看進(jìn)程狀態(tài)

[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

標(biāo)題名稱：Oracle11gR2RACTAF服務(wù)端配置
網(wǎng)頁地址：http://muchs.cn/article4/ghjioe.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供Google、網(wǎng)站設(shè)計、靜態(tài)網(wǎng)站、全網(wǎng)營銷推廣、標(biāo)簽優(yōu)化、外貿(mào)建站

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容