Category: Databases

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

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-08000 to ORA-08200 ORA-08000: maximum number of session sequence lists exceeded Cause: the sequence parent state objects for this session are all used Action: an internal error; quit the session and begin a new one ORA-08002: sequence string.CURRVAL is not yet defined in this session Cause: sequence CURRVAL has been…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-09800 to ORA-10000 ORA-09800: Process sensitivity label retrieval failed. Cause: ORACLE was unable to get the sensitivity label for a process. Action: Check the UNIX error number for a possible operating system failure. If there is no error, contact Oracle Support Services. ORA-09801: Unable to get user ID…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-07700 to ORA-08000 ORA-07700: sksarch: interrupt received Cause: An interrupt was received while archiving the logs Action: Retry operation ORA-07701: sksatln: internal exception: output buffer too small Cause: Overflow of buffer for parsing archive control text string Action: This is an internal error, please report to Oracle ORA-07702: unrecognized device…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-07500 to ORA-07700 ORA-07500: scglaa: $cantim unexpected return Cause: VMS system service $CANTIM returned an unexpected value Action: Check for system error message and refer to VMS documentation ORA-07501: scgtoa: $deq unexpected return Cause: VMS system service $DEQ returned an unexpected value Action: Check for system error message and refer…