Add or remove a service with SRVCTL Command in RAC
Add a service with SRVCTL command
--Syntax for adding Service
srvctl add servicec -d {DB_NAME} -s {SERVICE_NAME} -r {"preferred_list"} -a {"available_list"} [-P {BASIC | NONE | PRECONNECT}]
Example:
srvctl add service -d PRODB -s PRODB_SRV -r "PRODB1,PRODB2" -a "PRODB2" -P BASIC
Remove a service with SRVCTL
--Syntax for remove
srvctl remove service -d {DB_NAME} -s {SERVICE_NAME}
Example:
srvctl remove service -d PREDB -s PRDB_SRV