How to fix the Oracle error CRS-02800: Cannot start resource ‘string’ as it is already in the INTERMEDIATE state on server ‘string’?

In this post, you’ll learn more about the Oracle ErrorCRS-02800: Cannot start resource ‘string’ as it is already in the INTERMEDIATE state on server ‘string’ with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

CRS-02800: Cannot start resource ‘string’ as it is already in the INTERMEDIATE state on server ‘string’

Reason for the Error CRS-02800: Cannot start resource ‘string’ as it is already in the INTERMEDIATE state on server ‘string’

Cause: An attempt was made to start a resource that is already in the INTERMEDIATE state.

How to fix the Error CRS-02800: Cannot start resource ‘string’ as it is already in the INTERMEDIATE state on server ‘string’ ?

You can fix this error in Oracle by following the below steps

Action: Determine why the resource is in the INTERMEDIATE state based on the value of the STATE_DETAILS attribute. If it is due to a check timeout, no action is needed. Otherwise, manual intervention is required to bring the resource out of the INTERMEDIATE state.