Oracle Error ORA-07460: cannot set the RESOURCE_MANAGER_PLAN parameter

Oracle Error Message

ORA-07460: cannot set the RESOURCE_MANAGER_PLAN parameter

Reason for the Error

An attempt was made to internally set the RESOURCE_MANAGER_PLAN parameter, however, this failed because the current RESOURCE_MANAGER_PLAN has the FORCE prefix.

Solution

Remove the FORCE prefix from the RESOURCE_MANAGER_PLAN parameter.