How to fix the Oracle error PRCD-01190: Cannot update server pool to {0} for single instance database service {1}?

In this post, you’ll learn more about the Oracle ErrorPRCD-01190: Cannot update server pool to {0} for single instance database service {1} with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRCD-01190: Cannot update server pool to {0} for single instance database service {1}

Reason for the Error PRCD-01190: Cannot update server pool to {0} for single instance database service {1}

Cause: Attempt to update server pool of a single instance (non-RAC) database service was rejected because placement of this service is controlled by the server pool hosting the underlying database.

How to fix the Error PRCD-01190: Cannot update server pool to {0} for single instance database service {1} ?

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

Action: Try updating the server pool controlling the placement of the database via ‘srvctl modify database’ command or its equivalent.