Creating a Services In Oracle RAC
To check the configuration:
srvctl config database -d RUMPROD
To create a new service:
srvctl add service -d RUMPROD -s QSHO -r RUMPROD1,RUMPROD2
To start a service on one node:
srvctl start service -d RUMPROD -s QRUM -n test02 -o open
To start a service on all nodes:
srvctl start service -d RUMPROD -s QSHO -o open
To stop service in one node/ instance:
srvctl stop service -d RUMPROD -s QSHO -n test01
To stop service in all nodes/ instances:
srvctl stop service -d RUMPROD -s QSHO
To remove a service:
Oracle Best practices is to frirst stop the service, then drop it.
srvctl stop service -d RUMPROD -s QSHO
srvctl remove service -d RUMPROD -s QSHO
To check status of database and list services:
srvctl status database -d db_unique_name -v
Or using View :
SQL> select * from gv$active_services;
No comments:
Post a Comment