Add Service

[oracle@rac1 ~]$ srvctl add service -d racdb -s sstaf -r "racdb1,racdb2" -a "racdb3,racdb4" -P BASIC

Check Service Information

[oracle@rac1 ~]$ srvctl config service -d racdb -s sstaf -a

sstaf PREF: racdb1 racdb2 AVAIL: racdb3 racdb4 TAF: BASIC

Setting automatic start service

[oracle@rac1 ~]$ srvctl enable service -d racdb -s sstaf

Start Service

[oracle@rac1 ~]$ srvctl start service -d racdb -s sstaf

[@more@]

SQL> show parameter service

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

service_names string racdb, sstaf

SQL> col method format a10

SQL> col type format a10

SQL> col retries format 9999999

SQL> col goal format a10

SQL> col clb_goal format a10

SQL> col aqhn format a10

SQL> col name format a10

SQL> select name,failover_method method,failover_type type,failover_retries retries,clb_goal goal,aq_ha_notifications aqha from dba_services where name='sstaf';

NAME METHOD TYPE RETRIES GOAL AQH

---------- ---------- ---------- -------- ---------- ---

sstaf LONG NO

SQL> execute dbms_service.modify_service (service_name => 'sstaf' -

> , aq_ha_notifications => true -

> , failover_method => dbms_service.failover_method_basic -

> , failover_type => dbms_service.failover_type_select -

> , failover_retries => 180 -

> , failover_delay => 5 -

> , clb_goal => dbms_service.clb_goal_long);

PL/SQL procedure successfully completed.

SQL> select name,failover_method method,failover_type type,failover_retries retries,clb_goal goal,aq_ha_notifications aqha from dba_services where name='sstaf';

NAME METHOD TYPE RETRIES GOAL AQH

---------- ---------- ---------- -------- ---------- ---

sstaf BASIC SELECT 180 LONG YES

[oracle@rac1 ~]$ lsnrctl services

Service "sstaf" has 2 instance(s).

Instance "racdb1", status READY, has 2 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

REMOTE SERVER

(ADDRESS=(PROTOCOL=TCP)(HOST=rac1)(PORT=1521))

"DEDICATED" established:12 refused:0 state:ready

LOCAL SERVER

Instance "racdb2", status READY, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0 state:ready

REMOTE SERVER

(ADDRESS=(PROTOCOL=TCP)(HOST=rac2)(PORT=1521))

The command completed successfully

Testing

H:>sqlplus sys/uplooking@rac1-vip/sstaf as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 2月 22 15:40:59 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connect to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SYS> select host_name,instance_name from v$instance;

HOST_NAME

-----------------

INSTANCE_NAME

----------------

rac2

racdb2

Shutdown Rac2 database

Check again

SYS>select host_name,instance_name from v$instance;

HOST_NAME

---------------------------------------------------

INSTANCE_NAME

----------------

rac1

racdb1

Shutdown Rac3 database

Check again

SYS>select host_name,instance_name from v$instance;

HOST_NAME

---------------------------------------------------

INSTANCE_NAME

----------------

rac3

racdb3