My Oracle Support Banner

sqlplus : ORA-39510 CRS-2800 Diskgroup is in INTERMEDIATE state (Doc ID 2342253.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


sqlplus startup of the database fails due to the below error

ORA-39510: CRS error performing start on instance 'instance_name' on 'DB_name'
CRS-2800: Cannot start resource 'ora.DATAP.dg' as it is already in the INTERMEDIATE state on server 'node'
CRS-0223: Resource 'ora.db_name.db' has placement error.
clsr_start_resource:260 status:223


Recently Grid Infra home was full and checks got failed at the Resource level. 

2017-12-19 09:57:28.298 :CLSDYNAM:8: [ora.REDOW.dg]{0:0:2} [check] clsnUtils::error Exception type=2 string=
CRS-5017: The resource action "ora.REDOW.dg check" encountered the following error:
ORA-09817: Write to audit file failed.
SVR4 Error: 28: No space left on device
Additional information: 9


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.