How to fix the Oracle error ORA-56718: Timeout occurred while setting resource plan?

In this post, you’ll learn more about the Oracle ErrorORA-56718: Timeout occurred while setting resource plan with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-56718: Timeout occurred while setting resource plan

Reason for the Error ORA-56718: Timeout occurred while setting resource plan

A timeout occurred while waiting for one or more RAC instances to set the resource plan.

How to fix the Error ORA-56718: Timeout occurred while setting resource plan ?

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

Since the resource plan may have actually been set successfully, first check the current resource plan for each instance by querying gv$rsrc_plan. If the resource plan was not successfully set on all instances, then retry the operation.