{"id":1861,"date":"2016-04-08T13:18:39","date_gmt":"2016-04-08T10:18:39","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1861"},"modified":"2016-10-24T13:20:15","modified_gmt":"2016-10-24T10:20:15","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-12700-to-ora-12900","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-12700-to-ora-12900\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-12700 to ORA-12900"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-12700 to ORA-12900<\/strong><\/p>\n

\n
ORA-12700: invalid NLS parameter value (string)<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid or unknown NLS configuration parameter was specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12701: CREATE DATABASE character set is not known<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The character set specified when creating the database is unknown.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12702: invalid NLS parameter string used in SQL function<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An unknown parameter name or invalid value is specified in a NLS parameter string.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12703: this character set conversion is not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The requested conversion between two character sets in the CONVERT function is not implemented<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12704: character set mismatch<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0One of the following:<\/span><\/span><\/span><\/dd>\n
– The string operands(other than an nlsparams argument) to an operator or built-in function do not have the same character set.<\/span><\/span><\/span><\/dd>\n
– An nlsparams operand is not in the database character set.<\/span><\/span><\/span><\/dd>\n
– String data with character set other than the database character set is passed to a built-in function not expecting it.<\/span><\/span><\/span><\/dd>\n
– The second argument to CHR() or CSCONVERT() is not CHAR_CS or NCHAR_CS.<\/span><\/span><\/span><\/dd>\n
– A string expression in the VALUES clause of an INSERT statement, or the SET clause of an UPDATE statement, does not have the same character set as the column into which the value would be inserted.<\/span><\/span><\/span><\/dd>\n
– A value provided in a DEFAULT clause when creating a table does not have the same character set as declared for the column.<\/span><\/span><\/span><\/dd>\n
– An argument to a PL\/SQL function does not conform to the character set requirements of the corresponding parameter.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12705: Cannot access NLS data files or invalid environment specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Either an attempt was made to issue an ALTER SESSION command with an invalid NLS parameter or value; or the environment variable(s) NLS_LANG, ORA_NLSxx, or ORACLE_HOME was incorrectly specified, therefore the NLS data files cannot be located.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify the correct directory path\/values in the environment variables.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12706: this CREATE DATABASE character set is not allowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0It is not allowed to create a database on a native ASCII-based machine using an EBCDIC-based character set, and vice versa.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12707: error while getting create database NLS parameter\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal error<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12708: error while loading create database NLS parameter\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal error<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12709: error while loading create database character set<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal error<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12710: CREATE CONTROLFILE character set is not known<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The character set specified when creating the control file is unknown.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-12711: this CREATE CONTROLFILE character set is not allowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0It is not allowed to create a control file on a native ASCII-based machine using an EBCDIC-based character set, and vice versa.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12712: new character set must be a superset of old character set<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When you ALTER DATABASE … CHARACTER SET, the new character set must be a superset of the old character set. For example, WE8ISO8859P1 is not a superset of the WE8DEC.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a superset character set.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12713: Character data loss in NCHAR\/CHAR conversion<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When character set conversion happens between CHAR and NCHAR either implicitly or explicitly, some characters are lost due to no mapping characters in the destination character set.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure all the characters can be mapped to destination character set or set NLS_NCHAR_CONV_EXCP to be FALSE.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12714: invalid national character set specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Only UTF8 and AL16UTF16 are allowed to be used as the national character set<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the specified national character set is valid<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12715: invalid character set specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The character set specified is not allowed for this operation or is invalid<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the specified character set is valid<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12716: Cannot ALTER DATABASE CHARACTER SET when CLOB data exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0CLOB data changes representation to Unicode when converting to a multibyte character set and must be migrated<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove CLOB data as listed in the alert file. CLOB data can be migrated by methods such as import\/export<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12717: Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR or NVARCHAR2 data exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0NCLOB, NCHAR or NVARCHAR2 data changed the representation to Unicode when converting to a multibyte character set and must be migrated.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove NCLOB, NCHAR or NVARCHAR2 data as listed in the alert file. The above type data can be migrated by methods such as import\/export.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12718: operation requires connection as SYS<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This command can only be run when connecting as SYS<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Connect as SYS to run this command<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12719: operation requires database is in RESTRICTED mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This command can only be run when the database is in RESTRICTED mode<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the system is in RESTRICTED mode<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12720: operation requires database is in EXCLUSIVE mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This command can only be run when the database is in EXCLUSIVE mode<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the system is in EXCLUSIVE mode<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12721: operation cannot execute when other sessions are active<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This command can only be run when there are no other sessions active<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure there are no other connections to the database<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12722: regular expression internal error<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A regular expression internal error occurred.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error. Contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12723: regular expression too complex<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The regular expression was too complex and could not be parsed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error. Contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12724: regular expression corrupt<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The regular expression contained an incorrect sequence of metacharacters.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure the metacharacters are correctly positioned.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12725: unmatched parentheses in regular expression<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The regular expression did not have balanced parentheses.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure the parentheses are correctly balanced.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12726: unmatched bracket in regular expression<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The regular expression did not have balanced brackets.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure the brackets are correctly balanced.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12727: invalid back reference in regular expression<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A back references was found before a sub-expression.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure a valid sub-expression is being referenced.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12728: invalid range in regular expression<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid range was found in the regular expression.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure a valid range is being used.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12729: invalid character class in regular expression<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An unknown character class was found in the regular expression.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure a valid characters class is being used.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12730: invalid equivalence class in regular expression<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An unknown equivalence class was found in the regular expression.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure a valid equivalence class is being used.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12731: invalid collation class in regular expression<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An unknown collation class was found in the regular expression.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure a valid collation class is being used.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12732: invalid interval value in regular expression<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid interval value was found in the regular expression.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure a valid interval value is being used.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12733: regular expression too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The operation failed because the regular expression it used exceeds the maximum supported size.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a shorter regular expression.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12734: Instant Client Light: unsupported client national character set\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Only UTF8 and AL16UTF16 are allowed to be used as the national character set. Instant Client Light has only minimal character sets.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use Instant Client Light for this character set<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12735: Instant Client Light: unsupported client character set\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The character set specified is not allowed for this operation or is invalid. Instant Client Light has only minimal character sets.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use Instant Client Light for this character set<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12736: Instant Client Light: unsupported server national character set\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Only UTF8 and AL16UTF16 are allowed to be used as the national character set. Instant Client Light has only minimal character sets.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use Instant Client Light for this character set<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12737: Instant Client Light: unsupported server character set\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The character set specified is not allowed for this operation or is invalid. Instant Client Light has only minimal character sets.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use Instant Client Light for this character set<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12738: Express Instant Client: unsupported client national character set\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Only UTF8 and AL16UTF16 are allowed to be used as the national character set. Instant Client has only minimal character sets.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use Express Instant Client for this character set<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12739: Express Instant Client: unsupported client character set\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The character set specified is not allowed for this operation or is invalid. Express Instant Client has only minimal character sets.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use Express Instant Client for this character set<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12740: Express Instant Client: unsupported server national character set\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Only UTF8 and AL16UTF16 are allowed to be used as the national character set. Instant Client has only minimal character sets.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use Express Instant Client for this character set<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12741: Express Instant Client: unsupported server character set\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The character set specified is not allowed for this operation or is invalid. Express Instant Client has only minimal character sets.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use Express Instant Light for this character set<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12800: system appears too busy for parallel query execution<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0load on system is too high to perform parallel queries.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0re-execute serially or wait until system load is reduced.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12801: error signaled in parallel query server\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A parallel query server reached an exception condition.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the following error message for the cause, and consult your error manual for the appropriate action.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12802: parallel query server lost contact with coordinator<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A parallel query server lost contact with the foreground (coordinator) process\/thread.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check your system for anomalies and reissue the statement. If this error persists, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12803: parallel query server lost contact with another server<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A parallel query server lost contact with another server.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check your system for anomalies and reissue the statement. If this error persists, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12804: parallel query server appears to have died<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Cannot find process information for a parallel query server thread.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check your system for anomalies and reissue the statement. If this error persists, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12805: parallel query server died unexpectedly<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A parallel query server died unexpectedly, PMON cleaning up the process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check your system for anomalies and reissue the statement. If this error persists, contact Oracle Support Services. See trace file for more details.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12806: could not get background process to hold enqueue<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This error should not normally occur. If it persists, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12807: process queue could not receive parallel query message<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This error should not normally occur. If it persists, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12808: cannot set\u00a0string<\/i>_INSTANCES greater than number of instances\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to set SCAN_INSTANCES or CACHE_INSTANCES using the ALTER SYSTEM command to a value larger than the number of available instances.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0See the accompanying message for the current allowable maximum value, or set SCAN_INSTANCES \/ CACHE_INSTANCES to ALL.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12809: cannot set\u00a0string<\/i>_INSTANCES when mounted in exclusive mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to set SCAN_INSTANCES or CACHE_INSTANCES using the ALTER SYSTEM command while the database was mounted in exclusive mode.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0SCAN_INSTANCES \/ CACHE_INSTANCES may not be set unless running Oracle Real Application Clusters mounted in CLUSTER_DATABASE mode.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12810: PARALLEL_MAX_SERVERS must be less than or equal to\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to set the PARALLEL_MAX_SERVERS parameter to a value higher than the maximum allowed by the system.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Set PARALLEL_MAX_SERVERS to a value less than or equal to the maximum specified in the accompanying message and retry.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12811: PARALLEL_MIN_SERVERS must be less than or equal to PARALLEL_MAX_SERVERS,\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to set the PARALLEL_MIN_SERVERS parameter to a value higher than PARALLEL_MAX_SERVERS.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Set PARALLEL_MIN_SERVERS to a value less than or equal to PARALLEL_MAX_SERVERS (indicated in the accompanying message) and retry.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12812: only one PARALLEL or NOPARALLEL clause may be specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0PARALLEL was specified more than once, NOPARALLEL was specified more than once, or both PARALLEL and NOPARALLEL were specified in a CREATE TABLE, CLUSTER, or INDEX or in an ALTER TABLE or CLUSTER statement, or in a RECOVER command.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove all but one of the PARALLEL or NOPARALLEL clauses and reissue the statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12813: value for PARALLEL or DEGREE must be greater than 0<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0PARALLEL 0 or DEGREE 0 was specified in a CREATE TABLE, CLUSTER, or INDEX or in an ALTER TABLE or CLUSTER statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a degree of parallelism greater than 0 or specify default parallelism using PARALLEL with no degree or using DEGREE DEFAULT within a PARALLEL clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12814: only one CACHE or NOCACHE clause may be specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0CACHE was specified more than once, NOCACHE was specified more than once, or both CACHE and NOCACHE were specified in a CREATE TABLE or CLUSTER, or in an ALTER TABLE or CLUSTER statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove all but one of the CACHE or NOCACHE clauses and reissue the statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12815: value for INSTANCES must be greater than 0<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0PARALLEL parameter specifying number of instances must be a positive integer or DEFAULT<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify a positive integer or DEFAULT for INSTANCES if parallelism across instances is desired.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12817: parallel query option must be enabled<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A parallel query option feature has been invoked but this option has not been enabled.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enable the parallel query option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12818: invalid option in PARALLEL clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0an unrecognized option was used within a PARALLEL clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify any combination of DEGREE { <n> | DEFAULT } and INSTANCES { <n> | DEFAULT } within the PARALLEL clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12819: missing options in PARALLEL clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0PARALLEL clause cannot be empty.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify any combination of DEGREE { <n> | DEFAULT } and INSTANCES { <n> | DEFAULT } within the PARALLEL clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12820: invalid value for DEGREE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0invalid value for DEGREE was specified within a PARALLEL clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify a positive integer or DEFAULT for the DEGREE option within a PARALLEL clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12821: invalid value for INSTANCES<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0invalid value for INSTANCES was specified within a PARALLEL clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify a positive integer or DEFAULT for the INSTANCES option within a PARALLEL clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12822: duplicate option in PARALLEL clause<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0DEGREE or INSTANCES was specified more than once within a PARALLEL clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify each desired PARALLEL clause option only once.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12823: default degree of parallelism may not be specified here<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the PARALLEL keyword was used alone or DEGREE DEFAULT was specified in the PARALLEL clause of an ALTER DATABASE RECOVER command.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0respecify with an explicit degree of parallelism.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12824: INSTANCES DEFAULT may not be specified here<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0INSTANCES DEFAULT was specified in the PARALLEL clause of an ALTER DATABASE RECOVER command<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0respecify with an explicit value for INSTANCES or omit the INSTANCES option if single instance recovery is desired.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12825: explicit degree of parallelism must be specified here<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the DEGREE option was omitted from an ALTER DATABASE RECOVER command.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0respecify with an explicit degree of parallelism.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12826: hung parallel query server was killed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0parallel query server was hung and subsequently killed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0re-execute query and report suspicious events in trace file to Oracle Support Services if error persists.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12827: insufficient parallel query slaves (requested\u00a0string<\/i>, available\u00a0string<\/i>, parallel_min_percent\u00a0string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0PARALLEL_MIN_PERCENT parameter was specified and fewer than the minimum number of slaves were acquired<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either reexecute the query with a lower PARALLEL_MIN_PERCENT or wait until some running queries are completed, thus freeing up slaves<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12828: Can’t start parallel transaction at a remote site<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0PDML transaction cannot be started because we are not in the coordinator site of the distributed transaction.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use PDML at remote sites.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12829: Deadlock – itls occupied by siblings at block\u00a0string<\/i>\u00a0of file\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0parallel statement failed because all itls in the current block are occupied by siblings of the same transaction.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0increase MAXTRANS of the block or reduce the degree of parallelism for the statement. Reexecute the statement. Report suspicious events in trace file to Oracle Support Services if error persists.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12830: Must COMMIT or ROLLBACK after executing parallel INSERT\/UPDATE\/DELETE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0After executing a parallel INSERT\/UPDATE\/DELETE statement, a command other than COMMIT or ROLLBACK was issued.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Execute COMMIT or ROLLBACK before issuing another SQL command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12831: Must COMMIT or ROLLBACK after executing INSERT with APPEND hint<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0After executing an INSERT statement with an APPEND hint, a command other than COMMIT or ROLLBACK was issued.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Execute COMMIT or ROLLBACK before issuing another SQL command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12832: Could not allocate slaves on all specified instances<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0After executing a query on a global v$ fixed view, one or more instances failed to allocate a slave to process query<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0To allow results to be returned by sucessfully allocated slaves, execute ALTER SESSION SET ALLOW_PARTIAL_SN_RESULTS=TRUE statement, or check parameters of instances<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12833: Coordinator’s instance not a member of parallel_instance_group<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The coordinator’s instance must be a member of the parallel_instance_group in which this operation will be run.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either add the coordinator’s instance to the current parallel_instance_group or change parallel_instance_group.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12834: Instance group name, ‘string<\/i>‘, too long, must be less than\u00a0string<\/i>\u00a0characters<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The instance group name is too long.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either shorten the name or get rid of the instance group.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12835: No instances are active in the GLOBAL_VIEW_ADMIN_GROUP<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There must be at least one instance in the GLOBAL_VIEW_ADMIN_GROUP in order to execute a query on global views<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the value of GLOBAL_VIEW_ADMIN_GROUP<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12838: cannot read\/modify an object after modifying it in parallel<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Within the same transaction, an attempt was made to add read or modification statements on a table after it had been modified in parallel or with direct load. This is not permitted.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Rewrite the transaction, or break it up into two transactions: one containing the initial modification and the second containing the parallel modification operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12839: cannot modify an object in parallel after modifying it<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Within the same transaction, an attempt was made to perform parallel modification operations on a table after it had been modified. This is not permitted.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Rewrite the transaction or break it up into two transactions: one containing the parallel modification and the second containing the initial modification operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12840: cannot access a remote table after parallel\/insert direct load txn<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Within a transaction, an attempt was made to perform distributed access after a PDML or insert direct statement had been issued.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Commit\/rollback the PDML transaction first, and then perform the distributed access, or perform the distributed access before the first PDML statement in the transaction.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12841: Cannot alter the session parallel DML state within a transaction<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Transaction in progress<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Commit or rollback transaction and then re-execute<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12842: Cursor invalidated during parallel execution<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The cursor was invalidated during the parse phase of deferred parallel processing, e.g. when set operands are parallelized.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Depends on why the cursor was invalidated. Possible causes include DDL on a schema object and shared pool being flushed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12843: pdml lock not held properly on the table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The coodinator crashed or released the lock on the partition which the slave is trying to aquire currently.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check if the coordinator or some of the other slaves died. Also check that the lock has not been corrupted. Issue the pdml again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12844: cluster reconfiguration in progress<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Internal error<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0THIS IS NOT A USER ERROR NUMBER\/MESSAGE. THIS DOES NOT NEED TO BE TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL ERROR.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12845: failed to receive interinstance parallel execution message<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0OS or interconnect problem receiving interinstance message<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check OS specific diagnostics<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12850: Could not allocate slaves on all specified instances:\u00a0string<\/i>\u00a0needed,\u00a0string<\/i>\u00a0allocated<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When executing a query on a gv$ fixed view, one or more instances failed to allocate a slave to process query.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check trace output for instances on which slaves failed to start. GV$ query can only proceed if slaves can be allocated on all instances.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12851: PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS,\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to set the PARALLEL_MAX_SERVERS parameter to a value less than PARALLEL_MIN_SERVERS.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Set PARALLEL_MAX_SERVERS to a value greater than or equal to PARALLEL_MIN_SERVERS value specified in the accompanying message and retry.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12852: PARALLEL_MIN_SERVERS must be less than PROCESSES,\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to set the PARALLEL_MIN_SERVERS parameter to a value higher than PROCESSES.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Set PARALLEL_MIN_SERVERS to a value less than PROCESSES value specified in the accompanying message and retry.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12853: insufficient memory for PX buffers: current\u00a0string<\/i>K, max needed\u00a0string<\/i>K<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Insufficient SGA memory for PX buffers<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reconfigure sga to include at least (max – current) bytes of additional memory<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12854: Parallel query is not supported on temporary LOBs<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The parallel query statement produced a temporary LOB.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Turn off parallelism for the query or underlying table<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12855: cannot run parallel or insert direct load in a loopback<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A loopback was created in the transaction before this operation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use loopback when using pdml or insert direct load.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12856: cannot run parallel query on a loopback connection<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A table or index in a parallel query is referenced via a loopback connection.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use loopback connection when running a query in parallel.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12872: First slave parse gave different plan<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0First hard parse on slave given QC-supplied environment and parameters gave different plan from QC. Try again with outline.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0No external action. Internally used for outline-based reparse.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12899: value too large for column\u00a0string<\/i>\u00a0(actual:\u00a0string<\/i>, maximum:\u00a0string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to insert or update a column with a value which is too wide for the width of the destination column. The name of the column is given, along with the actual width of the value, and the maximum allowed width of the column. Note that widths are reported in characters if character length semantics are in effect for the column, otherwise widths are reported in bytes.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Examine the SQL statement for correctness. Check source and destination column data types. Either make the destination column wider, or use a subset of the source column (i.e. use substring).<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12900: must specify a default temporary tablespace for a locally managed database<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0a locally managed database must have a temporary tablespace other than SYSTEM tablespace<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify the default temporary tablespace when creating a locally managed database<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-12700 to ORA-12900 ORA-12700: invalid NLS parameter value (string) Cause:\u00a0An invalid or unknown NLS configuration parameter was specified. Action:\u00a0None ORA-12701: CREATE DATABASE character set is not known Cause:\u00a0The character set specified when creating the database is unknown. Action:\u00a0None ORA-12702: invalid NLS parameter string used in SQL function…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1861","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-u1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1861","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1861"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1861\/revisions"}],"predecessor-version":[{"id":1862,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1861\/revisions\/1862"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1861"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}