日期:2014-05-16  浏览次数:29442 次

oracle rac添加service的过程(11gr2版本)

1,手工添加service

su - oracle

[oracle@dtydb3 ~]$ srvctl add service -d epmdb -s srv_epm1 -r epmdb1 -a epmdb2 -P basic -e select -m basic -z 180 -w 5


2,查看service状态和属性

sys@EPMDB1(10.4.124.233)> select name, failover_method, failover_type, goal, clb_goal from dba_services;

NAME                 FAILOVER_M FAILOVER_TYPE                                                    GOAL         CLB_G
-------------------- ---------- ---------------------------- ------------ -----
SYS$BACKGROUND                                                                                   NONE         SHORT
SYS$USERS                                                                                        NONE         SHORT
epmdb                                                                                                         LONG
srv_epm1             BASIC      SELECT                                                           NONE         LONG

[grid@dtydb3 ~]$ crsctl status resource ora.epmdb.srv_epm1.svc -t
--------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------
Cluster Resources
--------------------------------------------
ora.epmdb.srv_epm1.svc
      1        ONLINE  ONLINE    &