How to fix the Oracle error PRCD-01149: AUTOMATIC management policy cannot be used for the service {0} when the database {1} is not AUTOMATIC?

In this post, you’ll learn more about the Oracle ErrorPRCD-01149: AUTOMATIC management policy cannot be used for the service {0} when the database {1} is not AUTOMATIC with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRCD-01149: AUTOMATIC management policy cannot be used for the service {0} when the database {1} is not AUTOMATIC

Reason for the Error PRCD-01149: AUTOMATIC management policy cannot be used for the service {0} when the database {1} is not AUTOMATIC

Cause: An attempt to create/modify a service failed because the management policy specified for the service is AUTOMATIC but the database’s management policy is not AUTOMATIC.

How to fix the Error PRCD-01149: AUTOMATIC management policy cannot be used for the service {0} when the database {1} is not AUTOMATIC ?

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

Action: Make sure that the provided service’s management policy is MANUAL or NORESTART when running ‘srvctl add service’ or ‘srvctl modify service’ command.