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…
Tag: Oracle Administration
Oracle 11g Error Codes and Solution Suggestions from ORA-12900 to ORA-13000
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
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
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
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
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
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
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
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…
Oracle 11g Error Codes and Solution Suggestions from ORA-10700 to ORA-10900
Oracle 11g Error Codes and Solution Suggestions from ORA-10700 to ORA-10900 ORA-10700: Alter access violation exception handler Cause: Use this event to control what the VMS exception handler does when it encounters an access violation. Action: Level: >=10 Suspend current process on access violation *** SET THIS EVENT ONLY UNDER THE SUPERVISION OF ORACLE DEVELOPMENT *** ORA-10701:…