My Oracle Support Banner

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

Last updated on SEPTEMBER 16, 2021

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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.<DGNAME1>.dg' as it is already in the INTERMEDIATE state on server '<hostname1>'
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.<DGNAME2>.dg]{0:0:2} [check] clsnUtils::error Exception type=2 string=
CRS-5017: The resource action "ora.<DGNAME2>.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!

In this Document

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