How to fix the Oracle error PRCD-01043: The service {0} is not a uniform or a singleton service and therefore it cannot be created as policy-managed service. This service can only be created as administrator-managed service using preferred, and optionally available instance lists.?

In this post, you’ll learn more about the Oracle ErrorPRCD-01043: The service {0} is not a uniform or a singleton service and therefore it cannot be created as policy-managed service. This service can only be created as administrator-managed service using preferred, and optionally available instance lists. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRCD-01043: The service {0} is not a uniform or a singleton service and therefore it cannot be created as policy-managed service. This service can only be created as administrator-managed service using preferred, and optionally available instance lists.

Reason for the Error PRCD-01043: The service {0} is not a uniform or a singleton service and therefore it cannot be created as policy-managed service. This service can only be created as administrator-managed service using preferred, and optionally available instance lists.

Cause: The service to be created was an administrator-managed service and the database that the service depended on was a policy-managed database.

How to fix the Error PRCD-01043: The service {0} is not a uniform or a singleton service and therefore it cannot be created as policy-managed service. This service can only be created as administrator-managed service using preferred, and optionally available instance lists. ?

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

Action: Use perferred and available instance lists to create an adminstrator-managed service for an adminstrator-managed database.