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….
Category: Oracle
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-12700 to ORA-12800
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
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
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
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
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
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…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-10614 to ORA-10707
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-10614 to ORA-10707 ORA-10614: Operation not allowed on this segment Cause: This procedure can be used only on segments in tablespaces with AUTO SEGMENT SPACE MANAGEMENT Action: Recheck the segment name and type and re-issue the statement ORA-10615: Invalid tablespace type for temporary tablespace Cause: Tablespace with AUTO SEGMENT…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-09700 to ORA-09800
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-09700 to ORA-09800 ORA-09700: sclin: maximum number of latches exceeded Cause: ORACLE wants to use more latches then available. Action: increase INIT.ORA parameter latch_pages or decrease the amount of shared memory you are using. ORA-09701: scnfy: maximum number of processes exceeded Cause: PROCESSES INIT.ORA parameter exceeded. Action: Decrease the PROCESSES…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-09200 to ORA-09370
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-09200 to ORA-09370 ORA-09200: sfccf: error creating file Cause: Could be out of disk space Action: See OSD error accompanying this message ORA-09201: sfcopy: error copying file Cause: Block sizes may not match Action: See OSD error accompanying this message ORA-09202: sfifi: error identifying file Cause: db_block_size specified in init.ora could…