How to fix the Oracle error PRCD-01197: The database {0} is policy-managed and an administrator-managed service {1} cannot be created on it?

In this post, you’ll learn more about the Oracle ErrorPRCD-01197: The database {0} is policy-managed and an administrator-managed service {1} cannot be created on it with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRCD-01197: The database {0} is policy-managed and an administrator-managed service {1} cannot be created on it

Reason for the Error PRCD-01197: The database {0} is policy-managed and an administrator-managed service {1} cannot be created on it

Cause: The specified database does not support administrator-managed services.

How to fix the Error PRCD-01197: The database {0} is policy-managed and an administrator-managed service {1} cannot be created on it ?

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

Action: Provide a database which supports administrator-managed services.