How to fix the Oracle error PRCD-01143: The cardinality of {0} is not valid for RAC One Node database or service {1}?

In this post, you’ll learn more about the Oracle ErrorPRCD-01143: The cardinality of {0} is not valid for RAC One Node database or service {1} with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PRCD-01143: The cardinality of {0} is not valid for RAC One Node database or service {1}

Reason for the Error PRCD-01143: The cardinality of {0} is not valid for RAC One Node database or service {1}

Cause: An invalid cardinality was specified for RAC One Node database or service.

How to fix the Error PRCD-01143: The cardinality of {0} is not valid for RAC One Node database or service {1} ?

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

Action: Specify a SINGLETON cardinality and retry the operation.