Oracle 11.2.0.3的数据库,测试服务器端TAF的问题
Oracle 11.2.0.3的数据库，在测试服务器端的TAF功能时遇到问题，环境是一套Primary DB和一套snapshot dataguard，主库DB_Unique_Name=custodg_sh,备库DB_Unique_Name=custodg_sz,两库的DB_Name都是custodg。
现在遇到的问题是，使用dbms_service包设定服务器端TAF属性，两个库针对Service_Name=custodg设定都是生效的，但对各自的
Service_Name=custodg_sh or Service_Name=custodg_sz设定都无效
设定的语句在SQL*Plus中显示执行都成功，具体的语句如下:
EXEC DBMS_SERVICE.MODIFY_SERVICE(SERVICE_NAME => 'CUSTODG',FAILOVER_METHOD => 'BASIC',FAILOVER_TYPE => 'SELECT',FAILOVER_RETRIES => 180,FAILOVER_DELAY => 5 );
EXEC DBMS_SERVICE.MODIFY_SERVICE(SERVICE_NAME => 'CUSTODG_SH',FAILOVER_METHOD => 'BASIC',FAILOVER_TYPE => 'SELECT',FAILOVER_RETRIES => 20,FAILOVER_DELAY => 15 );
EXEC DBMS_SERVICE.MODIFY_SERVICE(SERVICE_NAME => 'CUSTODG_SZ',FAILOVER_METHOD => 'BASIC',FAILOVER_TYPE => 'SELECT',FAILOVER_RETRIES => 20,FAILOVER_DELAY => 15 );
但各自环境中查询的结果如下：
在Primary DB 中：
SERVICE_ID|STATUS |NAME |NETWORK_NAME |CREATION_DATE |FAILOVER_METHOD|FAILOVER_TYPE |FAILOVER_RETRIES|FAILOVER_DELAY|BLOCKED
===========|==========|====================|====================|==================|===============|===============|================|==============|==========
6|Inactive |CUSTODG |CUSTODG |2014-07-11 02:16 |BASIC |SELECT | 180| 5|
3 |custodg_std |custodg_std |2014-08-03 11:53 | | | | |
7 |custodg_sz |custodg_sz |2014-08-06 17:49 | | | | |
1|Active |SYS$BACKGROUND | |2011-10-30 12:56 | | | | |NO
2 |SYS$USERS | |2011-10-30 12:56 | | | | |NO
5 |CUSTODGXDB |CUSTODGXDB |2014-07-11 02:16 | | | | |NO
4 |custodg_sh |custodg_sh |2014-08-05 01:16 | | | | |NO
已选择7行。
在Snapshot Standby DB中：
SERVICE_ID|STATUS |NAME |NETWORK_NAME |CREATION_DATE |FAILOVER_METHOD|FAILOVER_TYPE |FAILOVER_RETRIES|FAILOVER_DELAY|BLOCKED
===========|==========|====================|====================|==================|===============|===============|================|==============|==========
6|Inactive |CUSTODG |CUSTODG |2014-07-11 02:16 |BASIC |SELECT | 180| 5|
3 |custodg_std |custodg_std |2014-08-03 11:53 | | | | |
4 |custodg_sh |custodg_sh |2014-08-05 01:16 | | | | |
1|Active |SYS$BACKGROUND | |2011-10-30 12:56 | | | | |NO
2 |SYS$USERS | |2011-10-30 12:56 | | | | |NO
5 |CUSTODGXDB |CUSTODGXDB |2014-07-11 02:16 | | | | |NO
7 |custodg_sz |custodg_sz |2014-08-06 17:49 | | | | |NO
已选择7行。
求指点迷津，为什么针对各自Service_Name设置服务器端TAF无效啊？
页:
[1]