How to fix the Oracle error PRCD-01225: An attempt to remove service {0} of database {1} was rejected because this is the last service with {2} management policy. A RAC One Node database must have at least one service with {2} management policy.?

In this post, you’ll learn more about the Oracle ErrorPRCD-01225: An attempt to remove service {0} of database {1} was rejected because this is the last service with {2} management policy. A RAC One Node database must have at least one service with {2} management policy. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRCD-01225: An attempt to remove service {0} of database {1} was rejected because this is the last service with {2} management policy. A RAC One Node database must have at least one service with {2} management policy.

Reason for the Error PRCD-01225: An attempt to remove service {0} of database {1} was rejected because this is the last service with {2} management policy. A RAC One Node database must have at least one service with {2} management policy.

Cause: An attempt was made to remove the last service of a RAC One Node database having AUTOMATIC management policy.

How to fix the Error PRCD-01225: An attempt to remove service {0} of database {1} was rejected because this is the last service with {2} management policy. A RAC One Node database must have at least one service with {2} management policy. ?

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

Action: Add another service with AUTOMATIC management policy, for example by using ‘srvctl add service … -y AUTOMATIC’ command, or modify the management policy of an existing service to AUTOMATIC, using ‘srvctl modify service’ command, before removing the given service.