{"id":1808,"date":"2016-03-24T14:58:27","date_gmt":"2016-03-24T11:58:27","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1808"},"modified":"2016-10-21T15:00:33","modified_gmt":"2016-10-21T12:00:33","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-09800-to-ora-09900","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-09800-to-ora-09900\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-09800 to ORA-09900"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-09800 to ORA-09900<\/strong><\/p>\n

\n
ORA-09800: Process sensitivity label retrieval failed.<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to get the sensitivity label for a process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system failure. If there is no error, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09801: Unable to get user ID from connection<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to retrieve the user’s ID number from the SQL*Net connection.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system error. Also check the “additional information” field for the SQL*Net error. If there is no error, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09802: Conversion of binary label to string failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to convert a binary label to a string.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system failure. If there is no error, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09803: Allocation of string buffer failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0a buffer used to hold the name of the file for which a label was to be obtained could not be allocated.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system failure. If there is no error, contact Oracle Support Services. The number of bytes that ORACLE attempted to allocate is in the “Additional Information” field.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09804: Class conversion from binary to ORACLE failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to convert a class component from binary format to ORACLE format.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system failure. If there is no error, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09805: conversion of category number to string failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to translate a category number to its corresponding string representation failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system failure. If there is no error, contact Oracle Support Services. The category number is contained in the “Additional information” field.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09806: Allocation of label string buffer failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0a temporary buffer used to hold a label could not be allocated.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system failure. If there is no error, contact Oracle Support Services. The number of bytes that ORACLE attempted to allocate is in the “Additional Information” field.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09807: Conversion of label from string to binary failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to convert the string representation of a label to binary format.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-enter a valid label.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09808: Could not obtain user clearance.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to get a user’s clearance level.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system failure. If there is no error, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09809: Unable to get user’s group ID from connection<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to retrieve the user’s group ID number from the SQL*Net connection.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system error. Also check the “additional information” field for the SQL*Net error. If there is no error, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09810: Unable to get process ID from connection<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to retrieve the user’s process ID number from the SQL*Net connection.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system error. Also check the “additional information” field for the SQL*Net error. If there is no error, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09811: Unable to initialize package.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to initialize the library used to obtain security information.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error. Contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09812: Unable to get user clearance from connection<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to retrieve the user’s operating system session clearance from the SQL*Net connection.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system error. Also check the “additional information” field for the SQL*Net error. If there is no error, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n<\/dl>\n

<\/p>\n

\n
<\/a><\/a>ORA-09813: Unable to get directory status<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to determine if a directory is multilevel.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system error. If there is no error, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09814: Unable to expand file name<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to expand the name of a file that resides in multilevel directory.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system error. If there is no error, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09815: File name buffer overflow<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The buffer that ORACLE uses to hold the expanded name of a too small.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error. Contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09817: Write to audit file failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to write an entry to the file used as the audit trail.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system error. If there is no error, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09818: Number is too large<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to convert a component string to a number because the number is larger than the largest possible value for an integer. The additional information field specifies the maximum.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the string and repeat the conversion.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09819: Number exceeds maximum legal value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the number specified for a component was greater than the maximum value allowed for that component.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the component to a value less than the maximum and repeat the conversion. The maximum component number is contained in the “Additional information” field.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09820: Conversion of class string to numeric representation failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to convert a class string to a number because all of the characters in the string were not numeric.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the string to be either all numbers or all non-numeric characters and repeat the conversion.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09821: Numeric label is not valid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A label specified in ORACLE numeric format was found not to be valid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-enter a valid label. Consult your system’s encodings for valid numeric component values.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09822: Translation of audit file name failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Oracle was unable to translate the value of the AUDIT_FILE_DEST initialization parameter.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system error. If there is no error, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09823: device name is too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The name of a device was too long to fit into an internal buffer. The additional information field contains the length of the device name.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error. Contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09824: Unable to enable allowmacaccess privilege.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was not able to turn on allowmacaccess privilege so that it could do a label comparison.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number. If it indicates that ORACLE does not have the allowmacaccess privilege, add the allowmacaccess privilege to the potential privilege set of $ORACLE_HOME\/bin\/oracle using chpriv (1M). If the executable already has the allowmacaccess privilege, contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09825: Unable to disable allowmacaccess privilege.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was not able to turn off the allowmacaccess privilege after doing a label comparison.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error. Contact Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09826: SCLIN: cannot initialize atomic latch.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0System call atomic_op() return error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information in the trace file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09827: SCLGT: atomic latch return unknown error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0System call atomic_op() return unexpected error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information in the trace file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09828: SCLFR: atomic latch return error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0System call atomic_op() return unexpected error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information in the trace file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09829: pw_createPorts: server call pws_start_instance failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The call pws_start_instance to (Oracle helper) failed; system resources might be exhausted.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the server is still active. Check the error code returned in sercerrno, and look for error messages in the server log file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09830: snyAddPort: failed to perform a remote procedure call.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The msg_rpc system call returned an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error. Contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09831: snyStartThread: failed to build the server port set.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The routine failed to build a port set on which to listen for requests.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Possible operating system failure. Contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09832: infoCallback: bad message format.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The routine received an incorrectly formatted request.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error. Contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09833: addCallback: bad message format.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The routine received an incorrectly formatted request.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error. Contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09834: snyGetPortSet: failed to collect info on a port.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The port_status system called failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Possible operating system error. Contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09835: addCallback: callback port is already in a set.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The port to be added to the callback list is already in a port set.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error. Contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09836: addCallback: could not add a port to the callback set.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The port_set_add system called failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Possible operating system error. Contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09837: addCallback: could not add allocate a callback link.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The malloc library call failed to allocate space for a callback link.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Possible operating system error. Contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09838: removeCallback: failure removing the callback port.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The port port_set_remove system call failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Possible operating system error. Contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09839: removeCallback: callback port is not in the callback set.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The port to be removed to the callback list is not in the callback port set.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error. Contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09840: soacon: Name translation failure.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0sltln() could not translate the named pipe ?\/dbs\/mon2arch_@.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the ORACLE_HOME specified for this ORACLE_SID in oratab is correct.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09841: soacon: Name translation failure.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0sltln() could not translate the named pipe ?\/dbs\/arch2mon_@.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the ORACLE_HOME specified for this ORACLE_SID in oratab is correct.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09842: soacon: Archmon unable to create named pipe.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0mknod() failed to create named pipe ?\/dbs\/mon2arch_@.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Your current OS login may lack write permission for the ORACLE_HOME\/dbs directory. Only userids in the dba group of a given instance can run archmon for that ORACLE_SID. Make sure that the ORACLE_HOME directory is correct in oratab.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09843: soacon: Archmon unable to create named pipe.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0mknod() failed to create named pipe ?\/dbs\/arch2mon_@.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Your current OS login may lack write permission for the ORACLE_HOME\/dbs directory. Only userids in the dba group of a given instance can run archmon for that ORACLE_SID. Make sure that the ORACLE_HOME directory is correct in oratab.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09844: soacon: Archmon unable to open named pipe.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0open() failed to open named pipe ?\/dbs\/mon2arch_@.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Only the oracle dba can run archmon. Make sure that your current OS login has owner or group search permission for the ORACLE_HOME\/dbs directory. The max number of open files may have been exceeded.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09845: soacon: Archmon unable to open named pipe.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0open() failed to open named pipe ?\/dbs\/arch2mon_@.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Only the oracle dba can run archmon. Make sure that your current OS login has owner or group search permission for the ORACLE_HOME\/dbs directory. The max number of open files may have been exceeded.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09846: soacon: ARCH unable to open named pipe.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0open() failed to open named pipe ?\/dbs\/mon2arch_@.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the OS userid of the currently running database has search permission for the ORACLE_HOME\/dbs directory. The max number of open files may have been exceeded.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09847: soacon: ARCH unable to open named pipe.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0open() failed to open named pipe ?\/dbs\/arch2mon_@.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the OS userid of the currently running database has search permission for the ORACLE_HOME\/dbs directory. The max number of open files may have been exceeded.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09850: soacon: Archmon unable to lock named pipe.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0fcntl() failed to set write lock on named pipe ?\/dbs\/arch2mon_@.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that archmon is not already active on another terminal for this ORACLE_SID. Only one archmon session is allowed at a time for a given instance.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09851: soacon: Archmon unable to lock named pipe.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0fcntl() failed to set read lock on named pipe ?\/dbs\/mon2arch_@.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that archmon is not already active on another terminal for this ORACLE_SID. Only one archmon session is allowed at a time for a given instance.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09853: snyRemovePort: bad return code from request.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The request to remove a port from the callback set returned a failure code.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Possible operating system error. Contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09854: snyPortInfo: bad return code from request.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The request to collect info on a port in the callback set returned a failure code.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Possible operating system error. Contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09855: removeCallback: bad message format.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The routine received an incorrectly formatted request.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error. Contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09856: smpalo: vm_allocate error while allocating pga.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The vm_allocate system call returned an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check returned error. Possibly out of system resources.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09857: smprset: vm_protect error while protecting pga.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The vm_protect system call returned an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error. Contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09858: sfngat: the input file name is not in the OMF format<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The function sfngat() received a filename which is not an OMF file name.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Further diagnostic information should be in the error stack.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09859: sfngat: the input file name is not in the autobackup OMF format<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The function sfngat() received a filename which is not an autobackup OMF file name.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Further diagnostic information should be in the error stack.<\/span><\/span><\/span><\/dd>\n<\/dl>\n
\n
ORA-09870: spini: failure initializing maximum number of open files.<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ulimit system call returned an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09871: TASDEF_NAME: translation error while expanding ?\/dbs\/tasdef@.dbf.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Failure of sltln(?\/tasdef@.dbf) while creating test and set pages.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional return error for more information.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09872: TASDEF_CREATE: create failure in creating ?\/dbs\/tasdef@.dbf.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Create() failed when trying to create the tasdef file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify permissions on $(ORACLE_HOME)\/dbs directory.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09873: TASDEF_OPEN: open error when opening tasdef@.dbf file.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Unable to open tasdef@.dbf file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno. Possible permission problem. Verify that tasdef@.dbf file exists.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09874: TASDEF_READ: read error, unable to read tasdef@.dbf file.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Read system call returned an error when attempting to read ?\/dbs\/tasdef@.dbf.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno returned. Sgadef file may be corrupted or incompatible with oracle version.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09875: TASDEF_WRITE: write error when writing ?\/dbs\/tasdef@.dbf file.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Write call failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno returned. Possibly out of space on device.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09876: TASDEF_CLOSE: unable to close ?\/dbs\/tasdef@.dbf file.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Close system call returned an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno returned. Possible operating system failure.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09877: sstascre: shmget error, unable to get a shared memory segment.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Error in shmget.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno returned. Verify that enough shared memory is available on the system.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09878: sstascre\/sstasat: shmat error, unable to attach tas write page<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Error in shmat.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno returned.Verify that enough shared memory is available on the system.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09879: sstascre\/sstasat: shmat error, unable to attach tas read page<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Error in shmat.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno returned.Verify that enough shared memory is available on the system.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09880: sstasfre\/sstasdel: shmdt error, unable to detach tas write page<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Error in shmdt.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno returned.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09881: sstasfre\/sstasdel: shmdt error, unable to detach tas read page<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Error in shmdt.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno returned.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09882: sstasfre\/sstasdel: shmctl error, unable to remove tas shm page<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Error in shmctl.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno returned.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09883: Two Task interface: oratab file does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The oratab file does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Install oracle before you use it or recreate the oratab file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09884: Two Task interface: SID doens’t match current PU<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You are trying to start oracle on another PU than you configured oracle on or there is no entry for this SID in oratab file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Start oracle with this SID on its designated PU (see oratab file). Or install the new database with SID.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09885: osnTXtt: cannot create TXIPC channel<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The TXIPC driver failed to create pipes for two-task communications with the oracle shadow process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0You have probably exceeded the maximum number of open file descriptors per user or the system file table is full. Note the operating system error code and contact your system administrator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09886: osnTXtt: translation error while expanding txipc@.trc.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Failure of sltln(txipc@.trc) while creating debug channel.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional return error for more information.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09888: osnTXtt: txipc channel creation failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The txipc driver failed to create channels for two-task communications with the oracle shadow process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0You have probably exceeded the maximum number of open file descriptors per user or the system file table operating system error code and contact your system administrator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09889: osnTXtt: access error on oracle executable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The txipc driver could not access the oracle executable.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the permissions on the ORACLE executable and each component of the ORACLE_HOME\/bin path.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09890: osnTXtt: malloc failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The txipx driver failed to allocate enough heap space for its context area buffers.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/span><\/dd>\n<\/dl>\n

<\/a><\/p>\n

\n
<\/dd>\n<\/dl>\n
\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-09800 to ORA-09900 ORA-09800: Process sensitivity label retrieval failed. Cause:\u00a0ORACLE was unable to get the sensitivity label for a process. Action:\u00a0Check 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…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1808","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-ta","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1808","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1808"}],"version-history":[{"count":2,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1808\/revisions"}],"predecessor-version":[{"id":1810,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1808\/revisions\/1810"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1808"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1808"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}