Oracle RAC Service资源管理

创建数据库会默认创建与数据库同名的service，默认的service实现所有实例的负载均衡，可以认为数据库的所有实例是默认创建的service的首选节点。

手工创建的service资源区分首选节点与备用节点，客户端无论通过哪个节点请求连接都会固定连接到service资源的首选节点，只有当首选节点故障才会连接到备用节点。

创建service资源

[[email?protected] ~]$ srvctl add service -d king -s sale -r king1 -a king2 -P basic -e session -m basic -w 5 -z 3

-d：数据库名称

-s：新创建的service名称

-r：首选节点列表

-a：备用节点列表

-P：TAF策略

-y：是否自动启动

-e：TAF类型

-z：在failover之前重新尝试连接的次数

-w：在failover之前两次尝试连接的时间间隔

查询service资源属性

[[email?protected] ~]$ srvctl config service -d king -s sale

Service name: sale

Service is enabled

Server pool: king_sale

Cardinality: 1

Disconnect: false

Service role: PRIMARY

Management policy: AUTOMATIC

DTP transaction: false

AQ HA notifications: false

Failover type: SESSION

Failover method: BASIC

TAF failover retries: 3

TAF failover delay: 5

Connection Load Balancing Goal: LONG

Runtime Load Balancing Goal: NONE

TAF policy specification: BASIC

Edition:?

Preferred instances: king1

Available instances: king2

查询service资源状态

[[email?protected] ~]$ srvctl status service -d king

Service sale is not running.

启动service资源

[[email?protected] ~]$ srvctl start service -d king -s sale

[[email?protected] ~]$ srvctl status service -d king

Service sale is running on instance(s) king1

col?username?for?a20
col?failed_over?for?a15
SQL>?select?inst_id,username,failover_type,failover_method,failed_over?from?gv$session?where?username?=?'TPCC';
???INST_ID?USERNAME?????????????FAILOVER_TYPE???????????????????????????FAILOVER_METHOD????????????????FAILED_OVER
----------?--------------------?---------------------------------------?------------------------------?---------------
?????????1?TPCC??????????????????SESSION?????????????????????????????????BASIC??????????????????????????NO
SQL>?select?inst_id,failed_over?from?gv$session?where?username?=?'TPCC';
???INST_ID?USERNAME?????????????FAILOVER_TYPE???????????????????????????FAILOVER_METHOD????????????????FAILED_OVER
----------?--------------------?---------------------------------------?------------------------------?---------------
?????????2?TPCC??????????????????SESSION?????????????????????????????????BASIC??????????????????????????YES

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!