Oracle7 Server Messages

Contents Index Home Previous Next

12800-12849: Parallel Query/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.


Contents Index Home Previous Next