RAC SERVICE EXAMPLE

My notes on Oracle RAC Services --Moid

1. To check the status of all services in a RAC Database
10g
srvctl config service -d racdb
11g
srvctl config service -d racdb | grep -IE "Service name|Preferred instances"


2. To check the status of the service called crm
10g
srvctl status service -d racdb -s crm
11g



3a. To add a service
srvctl add service -d racdb -s CLROCM_DataRead_P -r racdb1,racdb2


 srvctl add service -d racdb-s oocert_n1pn2p -r ,oocert2 -P BASIC -e SELECT

x39 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = x39-3001.xyz.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = x39_n1pn2p)
    )
  )

set linesize 200
set pagesize 200
col username format a12
col machine format a20
Select
inst_id,
username,
machine,
failover_type,
failover_method,
failed_over
from
gv$session
where
username='AFSHAN'
order by 1,machine;



3b) Verify service is created.
srvctl status service -d racdb -s CLROCM_DataRead_P


3c) Enable the service
srvctl enable service -d racdb -s CLROCM_DataRead_P


3d) If service is already enabled, then start the service.
10g
srvctl start service -d racdb -s CLROCM_DataRead_P

11g



3e) Verify service is created, enabled and started.
10g
srvctl status service -d racdb -s CLROCM_DataRead_P


11g




4) How to relocated the service?
srvctl relocate service -d AQCLP -s AQSVC3P -i AQCLP1  -t AQCLP2 -f

srvctl relocate service -d AQCLP -s AQSVC6P -i AQCLP1 -t AQCLP2 -f
Note: Contributed by Ahmad Bhutta