Category: Errors and Solutions

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…

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 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 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…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-08400 to ORA-08600 ORA-08401: invalid compiler name: string Cause: An invalid compiler name compname was passed to a UTL_PG conversion routine. Action: Correct the compiler name parameter in the PL/SQL code that called the conversion routine. ORA-08402: error executing PL/SQL code coverage Cause: An error occurred during execution of a PL/SQL code…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-08200 to ORA-08400 ORA-08205: ora_addr: $ORACLE_SID not set in environment Cause: The environment variable ORACLE_SID is not set. Action: Set the ORACLE_SID environment variable. ORA-08206: ora_addr: cannot translate address file name Cause: Cannot translate $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf. Action: Ensure that ORACLE_HOME and ORACLE_SID are properly set. ORA-08207: ora_addr: cannot open address file…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-10260 to ORA-10590 ORA-10260: PGA limit (string MB) exceeded – process terminated Cause: The Resource Manager SESSION_PGA_LIMIT directive was exceeded because the process used too much program global area (PGA) memory. Action: Reduce the complexity of the update or query, or contact your database administrator for more information. ORA-10261:…