Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

After executing DBMS_SERVICE.START_SERVICE, the service resource remains in an OFFLINE status when I display the cluster resource status. Is that expected behaviour ?

April 26, 2017cluster dbms_service.start_service display executing offline remains Resource service Status

0

Posted

After executing DBMS_SERVICE.START_SERVICE, the service resource remains in an OFFLINE status when I display the cluster resource status. Is that expected behaviour ?

1 Answer

0

Posted

YES this is expected behaviour. Unfortunately, the DBMS_SERVICE.START_SERVICE does not update the clusterware until 11g Release 2. You should use srvctl start service -d dbname then you should see it come online. Note: With Oracle RAC 11g Release 2, the cluster resource for a Service, contains the values for all the attributes of a service. Oracle Clusterware will update the database with its values when it starts a service. In order to save modifications across restarts, all service modifications should be made with srvctl (or Oracle Enterprise Manager).