How to fix the Oracle error PRCD-01206: Failed to retrieve preferred instance of service {0} of RAC One Node database {1}?

In this post, you’ll learn more about the Oracle ErrorPRCD-01206: Failed to retrieve preferred instance of service {0} of RAC One Node database {1} with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRCD-01206: Failed to retrieve preferred instance of service {0} of RAC One Node database {1}

Reason for the Error PRCD-01206: Failed to retrieve preferred instance of service {0} of RAC One Node database {1}

Cause: Attempt to retrieve preferred instance of service belonging to RAC One Node database failed because database is either in failed online relocation state or undergoing online relocation.

How to fix the Error PRCD-01206: Failed to retrieve preferred instance of service {0} of RAC One Node database {1} ?

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

Action: Check the status of online relocation via ‘srvctl status database’ command. If online relocation status is reported as active, then retry after online relocation completes. If online relocation status is reported as failed, then repair the configuration via ‘srvctl relocate database … -a’ command and then retry.