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…
Month: September 2016
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-08200 to ORA-08400
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
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
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
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…