One or two services failed to start up, while the rest services are all good to be started up or shutdown.
$ srvctl start service -d TESTDB -s reports
PRCD-1084 : Failed to start service REPORTS
PRCR-1079 : Failed to start resource ora.testdb.reports.svc
CRS-5017: The resource action "ora.testdb.reports.svc start"
encountered the following error:
ORA-01013: user requested cancel of current operation
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/
racnode1/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.testdb.reports.svc' on 'racnode1' failed
CRS-2632: There are no more servers to try to place resource
'ora.testdb.reports.svc' on that would satisfy its placement policy
It seems the information about this database or service is inconsistent in OCR. We can try the following steps one after another until the it is successful.
1)Remove database from OCR, and add it back again.
$srvctl remove database.... $srvctl add database .... $ srvctl add instance .... $ srvctl start service -d TESTDB -s reports
2) if not working in previous step, then restart all clusterware.
#crsctl stop crs #ctsct start crs $srvctl start service -d TESTDB -s reports
3) For some reason database outage is unavailable, service can be started up manually.
Start up service on instance 1. Users or applications can connect to database through this service, but srvctl still shows service not running
SQL> exec DBMS_SERVICE.START_SERVICE('REPORTS','TESTDB1');
$ srvctl status service -d testdb -s reports
Service REPORTS is not running.
Make DBA Life Easy 