以oracle用户登录
点击(此处)折叠或打开
-
srvctl add service -d racdb -s erp -r racdb1 -a racdb2 -P BASIC -y automatic -e SELECT -z 5 -w 180
- srvctl add service -d racdb -s crm -r racdb2 -a racdb1 -P BASIC -y automatic -e SELECT -z 5 -w 180
-r：首选实例
-a：备用实例
-P：BASIC表示只连接首选实例，失败后再选择连接备用实例；另外一个选项是PRECONNECT
-e：SELECT表示查询在Failover发生后继续给出结果；另外一个选项是SESSION，表示不给出结果。
启动service，以grid用户登录
点击(此处)折叠或打开
-
srvctl start service -d racdb -s erp
- srvctl start service -d racdb -s crm
点击(此处)折叠或打开
-
[grid@node1 ~]$ srvctl config service -d racdb -s erp
-
Service name: erp
-
Service is enabled
-
Server pool: racdb_erp
-
Cardinality: 1
-
Disconnect: false
-
Service role: PRIMARY
-
Management policy: AUTOMATIC
-
DTP transaction: false
-
AQ HA notifications: false
-
Failover type: SELECT
-
Failover method: NONE
-
TAF failover retries: 5
-
TAF failover delay: 180
-
Connection Load Balancing Goal: LONG
-
Runtime Load Balancing Goal: NONE
-
TAF policy specification: BASIC
-
Edition:
-
Preferred instances: racdb1
- Available instances: racdb2
未完待续