oracle rac添加service的过程（11gr2版本）(二)
r(s) for this service...
Service "srv_epm1" has 1 instance(s).
Instance "epmdb1", status READY, has 1 handler(s) for this service...
[grid@dtydb3 ~]$
3，修改服务，如果创建不正常的话
修改服务
---srvctl modify service -d epmdb -s srv_epm1 -r epmdb2 -a epmdb1 -P basic -e select -m basic -z 100 -w 2
--删除服务
srvctl remove service -d epmdb -s srv_epm1 -f
4，TAF测试
tnsname.ora配置
tydb_srv_epm1 =
(DESCRIPTION =
(LOAD_BALANCE = NO)
(ADDRESS = (PROTOCOL = TCP)(HOST = db1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db2_vip)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = srv_epm1)
)
)
关闭实例1
shutdown immediate
sqlplus system/oracle@tydb_srv_epm1
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
epmdb2
www.2cto.com
成功切换到第二个节点
恢复还原
重启实例1 startup
切换service到实例1
su - oracle
srvctl relocate service -d epmdb -s srv_epm1 -i epmdb2 -t epmdb1
作者 hijk139