Tuesday, November 24, 2020

CRS-2674 CRS-2632 ORA-01013 CRS-5017 PRCR-1079 PRCD-1084

CRS-2674 CRS-2632 ORA-01013 CRS-5017 PRCR-1079 PRCD-1084  service not coming up

Services are not coming up after srvctl start service -d <DB NAME>

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) 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.

No comments: