Oracle7 Server Messages
12800-12849: Parallel Query/Index Creation
This section lists some of the messages generated during a parallel query or parallel index creation.
ORA-12800 system appears too busy for parallel query execution
Cause: | The load on the system is too high to perform parallel queries. | |
Action: | Re-enter the statements serially or wait until the system load is reduced. | |
ORA-12801 error signaled in parallel query server name
Cause: | A parallel query server encountered an exception as described in the accompanying message(s). | |
Action: | Correct the error described in the accompanying message. | |
ORA-12802 parallel query server lost contact with coordinator
Cause: | A parallel query server was unable to communicate with the server coordinating the parallel query. | |
Action: | Check for operating system or network errors and retry the statement. If this problem persists, contact customer support. | |
ORA-12803 parallel query server lost contact with another server
Cause: | A parallel query server was unable to communicate with another server involved in the parallel query. | |
Action: | Check for operating system or network errors and retry the statement. If this problem persists, contact customer support. | |
ORA-12804 parallel query server appears to have died
Cause: | Process information for a parallel query server thread cannot be found. | |
Action: | Check for operating system errors and retry the statement. If this problem persists, contact customer support. | |
ORA-12805 parallel query server died unexpectedly
Cause: | The PMON process is cleaning up the process because a parallel query server terminated unexpectedly. | |
Action: | Check for operating system errors and retry the statement. If this problem persists, contact customer support. | |
ORA-12806 could not get background process to hold enqueue
Cause: | This is an internal error that is not usually issued. | |
Action: | Contact customer support. | |
ORA-12807 process queue could not receive parallel query message
Cause: | This is an internal error that is not usually issued. | |
Action: | Contact customer support. | |
ORA-12808 cannot set [CACHE | SCAN]_INSTANCES greater than number of
instances num
Cause: | An attempt was made, using the ALTER SYSTEM command, to set CACHE_INSTANCES or SCAN_INSTANCES to a value greater than the number of available instances. | |
Action: | See the accompanying message for the allowable maximum value or set SCAN_INSTANCES or CACHE_INSTANCES to ALL. | |
ORA-12809 cannot set [CACHE | SCAN]_INSTANCES when mounted in
exclusive mode
Cause: | An attempt was made to set CACHE_INSTANCES or SCAN_INSTANCES using the ALTER SYSTEM command while the database was mounted in exclusive mode. | |
Action: | Only set CACHE_INSTANCES or SCAN_INSTANCES when the database is mounted in PARALLEL or SHARED mode. | |
ORA-12810 PARALLEL_MAX_SERVERS must be less than or equal to num
Cause: | An attempt was made to set the PARALLEL_MAX_SERVERS initialization parameter to a value higher than the maximum allowed by the system. | |
Action: | See the accompanying message for the allowable maximum value. | |
ORA-12811 PARALLEL_MIN_SERVERS must be less than or equal to PARALLEL_MAX_SERVERS, num
Cause: | An attempt was made to set the PARALLEL_WIN_SERVERS initialization parameter to a value higher than PARALLEL_MAX_SERVERS. | |
Action: | See the accompanying message for the allowable maximum value. | |
ORA-12812 only one PARALLEL or NOPARALLEL clause may be specified
Cause: | PARALLEL was specified more than once, NOPARALLEL was specified more than once, or both PARALLEL and NOPARALLEL were specified in a CREATE TABLE, CREATE CLUSTER, CREATE INDEX, ALTER TABLE, ALTER CLUSTER statement, or a RECOVER command. | |
Action: | Specify PARALLEL or NOPARALLEL only once. | |
ORA-12813 value for PARALLEL or DEGREE must be greater than 0
Cause: | PARALLEL 0 or DEGREE 0 was specified in a CREATE TABLE, CREATE CLUSTER, CREATE INDEX, ALTER TABLE, ALTER CLUSTER statement, or a RECOVER command. | |
Action: | Specify a value greater than 0 or specify default parallelism using PARALLEL with no degree or using DEGREE DEFAULT within a PARALLEL clause. | |
ORA-12814 only one CACHE or NOCACHE clause may be specified
Cause: | CACHE was specified more than once, NOCACHE was specified more than once, or CACHE and NOCACHE, were specified in a CREATE TABLE, CREATE CLUSTER, CREATE INDEX, ALTER TABLE, ALTER CLUSTER, or a RECOVER command. | |
Action: | Specify CACHE or NOCACHE only once. | |
ORA-12815 value for INSTANCES must be greater than 0
Cause: | PARALLEL parameter specifying number of instances must be a positive integer or DEFAULT. | |
Action: | Specify a positive integer or DEFAULT for INSTANCES if parallelism across instances is desired. | |
ORA-12817 parallel query option must be enabled
Cause: | You tried to attempt an operation that requires the parallel query option. | |
Action: | Enable the parallel query option. | |
ORA-12818 invalid option in PARALLEL clause
Cause: | An unrecognized option was specified with a PARALLEL clause. | |
Action: | Specify any combination of DEGREE {<n> | DEFAULT } and INSTANCE { <n> | DEFAULT } within the PARALLEL clause. | |
ORA-12819 missing options in PARALLEL clause
Cause: | The PARALLEL clause was specified without an option. | |
Action: | Specify any combination of DEGREE { <n> | DEFAULT } and INSTANCE { <n> | DEFAULT } within the PARALLEL clause. | |
ORA-12820 invalid value for DEGREE
Cause: | An invalid value for DEGREE was specified within a PARALLEL clause. | |
Action: | Specify a positive integer or DEFAULT. | |
ORA-12821 invalid value for INSTANCES
Cause: | An invalid value for INSTANCES was specified within a PARALLEL clause. | |
Action: | Specify a positive integer or DEFAULT. | |
ORA-12822 duplicate option in PARALLEL clause
Cause: | DEGREE or INSTANCE was specified more than once within a
PARALLEL clause. | |
Action: | Specify the option only once. | |
ORA-12823 default degree of parallelism may not be specified here
Cause: | Either an ALTER DATABASE RECOVER command was specified with the DEGREE DEFAULT option in a PARALLEL clause or another command was specified with no option in the PARALLEL clause. | |
Action: | Specify an explicit degree of parallelism. | |
ORA-12824 INSTANCES DEFAULT may not be specified here
Cause: | An ALTER DATABASE RECOVER command was specified with the INSTANCES DEFAULT option. | |
Action: | Specify an explicit value for INSTANCES or omit the INSTANCES option if single instance recovery is desired. | |
ORA-12825 explicit degree of parallelism must be specified here
Cause: | An ALTER DATABASE RECOVER command was specified without the DEGREE option. | |
Action: | Specify an explicit degree of parallelism. | |
ORA-12826 hung parallel query server was killed
Cause: | Parallel query server was hung and subsequently killed. | |
Action: | Re-execute query and report suspicious events noted in the trace file to customer support if error persists. | |
ORA-12827 insufficient parallel query slaves available
Cause: | PARALLEL_MIN_PERCENT parameter was specified and fewer than minimum slaves were acquired. | |
Action: | Either re-execute query with lower PARALLEL_MIN_PERCENT or wait until some running queries are completed, thus freeing up slaves. | |