How to fix the Oracle error PRCD-01165: An online relocation request for RAC One Node database {0} has failed?

In this post, you’ll learn more about the Oracle ErrorPRCD-01165: An online relocation request for RAC One Node database {0} has failed with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRCD-01165: An online relocation request for RAC One Node database {0} has failed

Reason for the Error PRCD-01165: An online relocation request for RAC One Node database {0} has failed

Cause: An online relocation request for the database has failed and the supplied target node was not the same as that in the failed request.

How to fix the Error PRCD-01165: An online relocation request for RAC One Node database {0} has failed ?

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

Action: Use ‘srvctl status database’ command to query the target node of the failed online relocation request. Either run ‘srvctl relocate database -a’ command to abort the failed request or ‘srvctl relocate database -n’ command with with the correct target node.