Category: Databases

Oracle 11g Error Codes and Solution Suggestions from ORA-13200 to ORA-13400 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 CREATE…

Oracle 11g Error Codes and Solution Suggestions from ORA-13000 to ORA-13200 ORA-13000: dimension number is out of range Cause: The specified dimension is either smaller than 1 or greater than the number of dimensions encoded in the HHCODE. Action: Make sure that the dimension number is between 1 and the maximum number of dimensions encoded in the…

Oracle 11g Error Codes and Solution Suggestions from ORA-12900 to ORA-13000   ORA-12900: must specify a default temporary tablespace for a locally managed database Cause: a locally managed database must have a temporary tablespace other than SYSTEM tablespace Action: specify the default temporary tablespace when creating a locally managed database ORA-12901: default temporary tablespace must be of…

Oracle 11g Error Codes and Solution Suggestions from ORA-12700 to ORA-12900 ORA-12700: invalid NLS parameter value (string) Cause: An invalid or unknown NLS configuration parameter was specified. Action: None ORA-12701: CREATE DATABASE character set is not known Cause: The character set specified when creating the database is unknown. Action: None ORA-12702: invalid NLS parameter string used in SQL function…

Oracle 11g 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 operation….

Oracle 11g 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 label…

Oracle 11g Error Codes and Solution Suggestions from ORA-12300 to ORA-12400 ORA-12315: database link type is invalid for the ALTER DATABASE statement Cause: The database link name you specified on the ALTER DATABASE statement is not an ROM: link. You must specify an ROM: link when using the ALTER DATABASE statement to mount or open a…

Oracle 11g Error Codes and Solution Suggestions from ORA-12100 to ORA-12300 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 further…

Oracle 11g 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 no…

Oracle 11g Error Codes and Solution Suggestions from ORA-10900 to ORA-12000 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-10902: disable seghdr conversion for ro operation Cause: causes seghdr conversion to be turned off for ro ops(#555856) Action: this should be…