Category: Databases

Oracle 11g 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 selected…

Oracle 11g 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 type…

Oracle 11g Error Codes and Solution Suggestions from ORA-07600 to ORA-07700 ORA-07600: slkmnm: $GETSYIW failure Cause: VMS system service $GETSYIW failed Action: Examine system error message and refer to VMS documentation ORA-07601: spguno: $GETJPIW failure Cause: VMS system service $GETJPIW failed Action: Examine system error message and refer to VMS documentation ORA-07602: spgto: $GETJPIW failure Cause: VMS system service $GETJPIW…

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

Oracle 11g Error Codes and Solution Suggestions from ORA-07400 to ORA-07500 ORA-07400: slemtr: translated name for the message file is too long. Cause: The name for the message file overflows internal buffer. Action: Try making the complete path-name of the message file shorter by reorganizing the directory hierarchy. ORA-07401: sptrap: cannot restore user exception handlers. Cause: The system…

Oracle 11g Error Codes and Solution Suggestions from ORA-07200 to ORA-07400 ORA-07200: slsid: oracle_sid not set. Cause: The environment variable $(ORACLE_SID) is not set. Action: Set ORACLE_SID environment variable. ORA-07201: slhom: oracle_home variable not set in environment. Cause: $(ORACLE_HOME) environment variable not set. Action: Set ORACLE_HOME. ORA-07202: sltln: invalid parameter to sltln. Cause: The sltln name translation routine was called…

Oracle 11g Error Codes and Solution Suggestions from ORA-06800 to ORA-07000 ORA-06800: TLI Driver: SQL*Net SPX client went away during reconnect Cause: The client process was aborted by the system or the user, and was unable to complete the connection establishment with the server listener process. Action: Determine cause of client exit, and reattempt connection. ORA-06801: TLI…

Oracle 11g Error Codes and Solution Suggestions from ORA-06600 to ORA-06800 ORA-06600: LU6.2 Driver: SNA software is not loaded Cause: The SNA software is not running. Action: Start the SNA software and try again. ORA-06601: LU6.2 Driver: Invalid database ID string Cause: The database string in the connect was invalid. Action: Provide a valid database string, as defined in…

Oracle 11g Error Codes and Solution Suggestions from ORA-06500 to ORA-06600 ORA-06500: PL/SQL: storage error Cause: PL/SQL was unable to allocate additional storage. This message normally appears with an ORA-4030 or ORA-4031 error which gives additional information. Sometimes this error can be caused by runaway programs. Action: 1) Ensure there are no issues or bugs in your…

Oracle 11g Error Codes and Solution Suggestions from ORA-06300 to ORA-06500 ORA-06300: IPA: Disconnect failure Cause: A fatal error occurred during the disconnect from the server. This was probably caused by inaccessible message queues. Action: If there is no message queue, restart the SQL*Net IPA servers using ipactl. Otherwise contact your customer support representative. ORA-06301: IPA: Cannot…