DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, April 24, 2018

CRS-2800: Cannot start resource 'ora.ORA_DATA.dg' as it is already in the INTERMEDIATE state on server 

ISSUE:-

SQL> startup;

ORA-39510: CRS error performing start on instance

CRS-2800: Cannot start resource 'ora.TESTDB.dg' as it is already in the INTERMEDIATE state on server


]$ srvctl start database -d TESTDB

PRCR-1079 : Failed to start resource ora.TESTDB.db

CRS-2800: Cannot start resource ‘ora.TESTDB.dg’ as it is already in the INTERMEDIATE state on server 'Doyen25'

CRS-2632: There are no more servers to try to place resource ‘ora.TESTDB.db’ on that would satisfy its placement policy

oracle@Doyen25]$ crsctl stat res -t ora.TESTDB.db
ONLINE INTERMEDIATE TESTDB01 CHECK TIMED OUT
ONLINE ONLINE TESTDB02

Root Cause:


This may be an intermediate connectivity disturbance



Solution:



1) If you have root access you can re-check the resources.

[oracle@Doyen25]$ crsctl check resource ora.TESTDB.db
crsctl status resource ora.TESTDB.db
NAME=ora.TESTDB.db
TYPE=ora.database.type
TARGET=INTERMEDIATE TESTDB01 CHECK TIMED OUT
STATE=OFFLINE


]#crsctl start resource ora.TESTDB.db
CRS-2672: Attempting to start 'ora.TESTDB.db' on 'TESTDB01'
CRS-2676: Start of 'ora.TESTDB.db' on 'TESTDB01' succeeded


[oracle@Doyen25]$ crsctl stat res -t

ora.TESTDB.db

ONLINE ONLINE TESTDB01

ONLINE ONLINE TESTDB02



[oracle@Doyen25] # srvctl status database -d TESTDB

Instance TESTDB01 is running on node Doyen25

Instance TESTDB02 is running on node Doyen26



                                                          (OR)

2)

[oracle@Doyen25] $ srvctl remove database -d TESTDB
               
SQL> Startup;

[oracle@Doyen25] $ srvctl add database -d TESTDB -o <ORACLE_HOME>
               
[oracle@Doyen25] $ srvctl status database -d TESTDB




No comments: