Oracle Error ORA-12815: value for INSTANCES must be greater than 0

Oracle Error Message

ORA-12815: value for INSTANCES must be greater than 0

Reason for the Error

PARALLEL parameter specifying number of instances must be a positive integer or DEFAULT

Solution

specify a positive integer or DEFAULT for INSTANCES if parallelism across instances is desired.