How to fix the Oracle error PRCD-01157: Failed to convert the configuration of cluster database {0} into its equivalent configuration for RAC One Node database because none of its services have {1} management policy?

In this post, you’ll learn more about the Oracle ErrorPRCD-01157: Failed to convert the configuration of cluster database {0} into its equivalent configuration for RAC One Node database because none of its services have {1} management policy with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRCD-01157: Failed to convert the configuration of cluster database {0} into its equivalent configuration for RAC One Node database because none of its services have {1} management policy

Reason for the Error PRCD-01157: Failed to convert the configuration of cluster database {0} into its equivalent configuration for RAC One Node database because none of its services have {1} management policy

Cause: An attempt to convert a cluster database configuration into its equivalent configuration for RAC One Node database was rejected because all services of the given database have MANUAL management policy.

How to fix the Error PRCD-01157: Failed to convert the configuration of cluster database {0} into its equivalent configuration for RAC One Node database because none of its services have {1} management policy ?

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

Action: Modify the management policy of at least one of these services to AUTOMATIC using ‘srvctl modify service … -y AUTOMATIC’ command and then retry.