Category: Databases

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

Oracle 11g Error Codes and Solution Suggestions from ORA-10600 to ORA-10650 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 SPACE…

Oracle 11g Error Codes and Solution Suggestions from ORA-10500 to ORA-10600 ORA-10546: Cannot perform block media recovery; standby database does not have requisite redo. Cause: An attempt was made to perform block media recovery on the standby database when the necessary redo was not available. Action: Wait until the necessary redo is available and reattempt block media…

Oracle 11g Error Codes and Solution Suggestions from ORA-10200 to ORA-10500 ORA-10243: simulated error for test string of K2GTAB latch cleanup Cause: levels 1..6 for insert, 7..11 for delete Action: None ORA-10244: make tranids in error msgs print as 0.0.0 (for testing) Cause: also makes “alter system enable distributed recovery” synchronous Action: None ORA-10259: get error message text from remote using…

Oracle 11g Error Codes and Solution Suggestions from ORA-09900 to ORA-10000 ORA-09908: slkmnm: gethostname returned error code. Cause: The system call gethostname returned an error. Action: This is most likely an internal error. Make sure gethostname is successful in other contexts, and if so contact Oracle support. ORA-09909: Malloc of scratch buffer failed. Cause: Memory needed for a…

Oracle 11g Error Codes and Solution Suggestions from ORA-09800 to ORA-09900 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 from…

Oracle 11g Error Codes and Solution Suggestions from ORA-09300 to ORA-09800 ORA-09300: osncon: unable to connect, DPMI not available Cause: Unable to detect the presence of DPMI Action: Restart Windows and retry ORA-09301: osncon: local kernel only supported in standard mode Cause: An attempt was made to connect to S: while in enhanced mode Action: Restart Windows in standard…

Oracle 11g Error Codes and Solution Suggestions from ORA-09200 to ORA-09300 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 be…

Oracle 11g Error Codes and Solution Suggestions from ORA-08400 to ORA-08500 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-08412: error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning…

Oracle 11g 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 Cause: The…