Category: Databases

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-13200 to ORA-13300 ORA-13200: internal error [string] in spatial indexing. Cause: This is an internal error. Action: Contact Oracle Support Services with the exact error text. ORA-13201: invalid parameters supplied in CREATE INDEX statement Cause: An error was encountered while trying to parse the parameters clause for the spatial…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-13100 to ORA-13200 ORA-13100: feature does not exist Cause: The feature does not exist. Action: Contact Oracle Support Services. ORA-13101: invalid ptn_type parameter Cause: An incorrect ptn_type parameter was specified. Action: Ensure the ptn_type parameter value is correct. ORA-13102: invalid ptn_capacity parameter Cause: An incorrect ptn_capacity parameter was specified. Action: Ensure the…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-13000 to ORA-13100 ORA-13000: dimension number is out of range Cause: The specified dimension was either smaller than 1 or greater than the number of dimensions encoded in the HHCODE. Action: Ensure that the dimension number is between 1 and the maximum number of dimensions encoded in the…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-12800 to ORA-13000 ORA-12800: system appears too busy for parallel query execution Cause: load on system is too high to perform parallel queries. Action: re-execute serially or wait until system load is reduced. ORA-12801: error signaled in parallel query server string Cause: A parallel query server reached an exception condition….

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-12700 to ORA-12800 ORA-12700: invalid NLS parameter value (string) Cause: An invalid or unknown NLS configuration parameter was specified. Action: n/a ORA-12701: CREATE DATABASE character set is not known Cause: The character set specified when creating the database is unknown. Action: n/a ORA-12702: invalid NLS parameter string used in SQL…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-12500 to ORA-12700 ORA-12500: TNS:listener failed to start a dedicated server process Cause: The process of starting up a dedicated server process failed. The executable could not be found or the environment may be set up incorrectly. Action: Turn on tracing at the ADMIN level and reexecute the…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-12400 to ORA-12500 ORA-12400: invalid argument to facility error handling Cause: An argument to a facility error handling function exceeded a maximum limit or referred to an invalid product/facility. Action: Specify a valid facility error handling parameter value. ORA-12401: invalid label string: string Cause: The policy could not convert the…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-12150 to ORA-12400 ORA-12150: TNS:unable to send data Cause: Unable to send data. Connection probably disconnected. Action: Reestablish connection. If the error is persistent, turn on tracing and reexecute the operation. ORA-12151: TNS:received bad packet type from network layer Cause: Internal error. Action: Not normally visible to the user. For…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-12000 to ORA-12100 ORA-12001: cannot create log: table ‘string’ already has a trigger Cause: Materialized view logs are filled by a trigger on the master table. That trigger cannot be created. Action: To create a materialized view log, drop the current trigger on the master. ORA-12002: there is…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-10900 to ORA-10999 ORA-10900: extent manager fault insertion event #string Cause: causes faults to be generated in instrumented extent code Action: this should only be enabled for internal testing ORA-10901: disable the fix for bug 1230798 ORA-10902: disable seghdr conversion for ro operation Cause: causes seghdr conversion to be…