How to fix the Oracle error PRCD-01230: Failed to modify database {0} to use server pool {1}?

In this post, you’ll learn more about the Oracle ErrorPRCD-01230: Failed to modify database {0} to use server pool {1} with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRCD-01230: Failed to modify database {0} to use server pool {1}

Reason for the Error PRCD-01230: Failed to modify database {0} to use server pool {1}

Cause: An attempt to modify the database to use the given server pool has failed.

How to fix the Error PRCD-01230: Failed to modify database {0} to use server pool {1} ?

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

Action: Review the accompanying error messages for details about the failure. For example, a failure could happen if the database owner does not have execute permissions on the given server pool. In this case, use ‘srvctl config database -d ‘ command to find out the database owner’s username, create a server pool as that user, and then supply that server pool as argument when retrying the command.