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

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

\n
ORA-09908: slkmnm: gethostname returned error code.<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The system call gethostname returned an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is most likely an internal error. Make sure gethostname is successful in other contexts, and if so contact Oracle support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09909: Malloc of scratch buffer failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Memory needed for a temporary buffer could not be allocated. The additional information field contains the number of bytes that ORACLE attempted to allocate.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number. It is probable that the system has run out of memory. If there is no error, contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09910: Unable to find ORACLE password file entry for user.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0No entry exists for the user in the ORACLE password file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Have the database administrator install a password entry by running orapasswd.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09911: Incorrect user password.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The password entered by the user was incorrect.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter the correct password.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09912: Malloc of name buffer(s) failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to allocate memory for one or both of the buffers that are used to hold the name of DBA and the operator users.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number. It is probable that the system has run out of memory. If there is no error, contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09913: Malloc of dummy name failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to allocate memory for the user name that is to to be used in the encryption of the user’s password.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number. It is probable that the system has run out of memory. If there is no error, contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09914: Unable to open the ORACLE password file.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE could not open the password file for reading.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number. If the error number indicates that the file does not exist, have the database administrator create the file by running orapasswd. If the error number indicates insufficient permissions, ask the database administrator to change the permissions. Otherwise, contact ORACLE customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09915: Password encryption failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to encrypt a password.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error – contact ORACLE customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09916: Required password was not specified.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A user attempted to connect as “internal,” but did not specify a password.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Connect as internal again and specify a password.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09918: Unable to get user privileges from SQL*Net<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to retrieve the user’s privilege set 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09919: Unable to set label of dedicated server<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to set the label of the dedicated to server to the required value.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for a possible operating system error. Also, check the privileges on the oracle executable. It should have at least “allowmacaccess” privilege.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-09920: Unable to get sensitivity label from connection<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to retrieve the user’s sensitivity label 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09921: Unable to get information label from connection<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to retrieve the user’s information label 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09922: Can’t spawn process – background log directory not created properly<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to spawn a background process because the directory that will hold trace files of the background processes was not created properly.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Examine the directory pointed to by the initialization parameter “background_dump_dest”. Make sure that all of the following is true:<\/span><\/span><\/span><\/dd>\n
1. The directory exists.<\/span><\/span><\/span><\/dd>\n
2. The name indeed points to a directory, and is not a file.<\/span><\/span><\/span><\/dd>\n
3. The directory is accessible and writable to the ORACLE user.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09923: Can’t spawn process – user log directory not created properly<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to spawn a background process because the directory that holds the trace files of the dedicated server processes was not created properly.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Examine the directory pointed to by the initialization parameter “user_dump_dest”. Make sure that all of the following is true:<\/span><\/span><\/span><\/dd>\n
1. The directory exists.<\/span><\/span><\/span><\/dd>\n
2. The name indeed points to a directory, and is not a file.<\/span><\/span><\/span><\/dd>\n
3. The directory is accessible and writable to the ORACLE user.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09924: Can’t spawn process – core dump directory not created properly<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to spawn a background process because the directory that holds the core dumps produced by ORACLE processes in the event of exceptions was not created properly.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Examine the directory pointed to by the initialization parameter “core_dump_dest”. Make sure that all of the following is true:<\/span><\/span><\/span><\/dd>\n
1. The directory exists.<\/span><\/span><\/span><\/dd>\n
2. The name indeed points to a directory, and is not a file.<\/span><\/span><\/span><\/dd>\n
3. The directory is accessible and writable to the ORACLE user.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09925: Unable to create audit trail file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was not able to create the file being used to hold audit trail records.<\/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 customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09926: Unable to set effective privilege set of the server<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A dedicated server was unable to set it’s own privilege set.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the privileges granted to the ORACLE executable. It must have at least “allowmacacess” privilege.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09927: Unable to set label of server<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was not able to set the label of a server to a new value.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the privileges on $ORACLE_HOME\/bin\/oracle. Make sure that it has “allowmacaccess” privilege.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09928: Unable to restore the label of server<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to restore the label of the server to the value that it had before raising it to database high.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error – contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09929: GLB of two labels is invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The result of a greatest lower bound operation on two labels was not valid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Repeat the operation with two different labels. Consult the system encoding file for the values of valid labels.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09930: LUB of two labels is invalid<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The result of a least upper bound operation on two labels was not valid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Repeat the operation with two different labels. Consult the system encoding file for the values of valid labels.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09931: Unable to open ORACLE password file for reading<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to open a password file for reading failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the permissions on the file have not been changed so that the ORACLE user cannot open it.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09932: Close of ORACLE password file failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to close a password file failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for the specific reason.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09933: Deletion of old password file failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The removal of the old password file failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for the specific reason.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09934: Link of current password file to old failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to create a link so that the old password file could be saved.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for the specific reason.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09935: Unlink of current password file failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to complete the saving of the current password file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for the specific reason.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09936: Open of ORACLE password file for write failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to create a password file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for the specific reason.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09937: Chmod of ORACLE password file failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to change a password file to be readonly.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number for the specific reason.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09938: Save of signal handlers failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to save the previous values of selected signal handlers.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error. Contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09939: Restoration of signal handlers failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to restore the previous values of selected signal handlers.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error. Contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09940: ORACLE password file header is corrupt<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The header of one of the password files was not in the format that ORACLE expected.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the headers of both files. The header should be in the format “FILE VERSION: N.N.N.N.N EXECUTABLE VERSION: N.N.N.N.N” where N is a number. Remove the corrupt file(s) and re-run “orapasswd”.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09941: Version of orapasswd or installer is older than file.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The version of orapasswd or installer that is being run is older than that of the ORACLE password file. Since the file version is only changed when the format is changed, this error means that the executable is using a different format than that with which the file was created.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Run a version of the installer or orapasswd whose version is the same or later than that of the file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09942: Write of ORACLE password file header failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The attempt to write out the header of the ORACLE password file failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the operating system error number. It is possible that the file system became full.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09943: Allocation of memory for password list component failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When it is building a list of password file entries, ORACLE allocates memory for various components. One of the allocations failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the operating system error number. The system has probably run out of memory.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09944: Password entry is corrupt.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An entry in an ORACLE password file was not in the format that ORACLE expected.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Removed the corrupt file(s) and re-run “orapasswd.”<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09945: Unable to initialize the audit trail file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE unable to write header information to the file being 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 customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09946: File name too long for buffer<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The buffer that was to be used to hold a file name was determined to be too short for the generated name. This will happen if the translated name for either a trace file or an audit file is longer than the maximum allowed, which on many ports is 256 characters.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a shorter file name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09947: Unable to allocate connection attributes structure<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was not able to allocate the memory needed to hold the attributes of the SQL*Net connection. The “Additional Information” field holds the number of bytes that ORACLE attempted to allocate.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the UNIX error number. It is probable that the system has run out of memory. If there is no error, contact ORACLE customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09948: Process information label retrieval failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to get the information 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09949: Unable to get client operating system privileges<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to get the operating system privileges for the client 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09950: Unable to get server operating system privileges<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to get its privileges from the operating system.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an error that should never happen. Contact ORACLE customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09951: Unable to create file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to create a file.<\/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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09952: scgcmn: lk_open_convert unexpected return: open failed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The distributed lock manager returned an unexpected value<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check for system error message and refer to the distributed lock manager documentation or contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09953: scggc: unexpected return of a lock convert<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The distributed lock manager returned an unexpected value<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check for lock manager error message and refer to DLM documentation refer to the distributed lock manager documentation or contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09954: scgcc: unexpected return status to callback of lock close<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The distributed lock manager returned an unexpected value<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check for lock manager error message and refer to DLM documentation refer to the distributed lock manager documentation or contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09955: scgcan: unexpected return status when canceling a lock<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0DLM system service x returned an unexpected value<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check for system error message and refer to DLM documentation refer to the distributed lock manager documentation or contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09956: scgcm: unexpected lock status condition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A global locking system service returned an unexpected value.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check for system error message (if any) and refer to refer to the distributed lock manager documentation or contact your customer support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09957: Unable to send termination request to IMON<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The attempt to send a termination signal to IMON failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error, contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09958: IMON: two processes with the same ORACLE pid are active<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The IMON process was unable to add an entry for a server process because another active process occupies the slot.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error, contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09959: IMON: deletion of a process failed.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The IMON process was unable to delete a server process from its process ID array because no entry for the process could be found.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error, contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09960: Unable to establish signal handler for termination signal<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE was unable to set up a handler for the signal used to notify it that the instance was shutting down.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error, contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09961: Unable to restore termination signal handler<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ORACLE failed to set the handler for the termination signal to its previous value.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error, contact ORACLE support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09966: falure in translation while expanding ?\/dbs\/lk for lock file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Oracle failed to translate ?\/dbs\/lk, when creating a file name for the database mount lock or the instance startup\/shutdown lock.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional return errors for more information.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09967: unable to create or open lock file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Oracle failed, when making an open system call, inorder to acquire a file lock used by the database mount lock or the instance startup\/shutdown lock.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno for more information.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09968: unable to lock file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The system call for locking a file returned an error when trying to acquire a database mount lock or the instance startup\/shutdown lock.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno for more information.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09969: unable to close or remove lock file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The close system call or unlink system call returned an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno for more information.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09974: skxfidini: Error Initializing SDI Channel<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The process was unable to initialize the SDI channel properly.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the operating system error and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09975: kxfspini: Error Initializing SDI Process<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The process was unable to attach to the SDI channel.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the SDI process specific limits correctly configured. Correct the operating system error and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09976: skxfqdini: Error Creating Port<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The process was unable to create a communications endpoint.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the SDI port specific limits correctly configured. Correct the operating system error and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09977: skxfqhini: Error Connecting<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The process was unable to connect to another endpoint.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the SDI port specific limits correctly configured. Check that the other node(s) is part of the cluster and operating properly. Correct the operating system error and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09978: skxfqhdel: Error Disconnecting from another endpoint.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The process was unable to disconnect cleanly from another endpoint.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that the other node(s) are part of the cluster and operating properly. Check the instance and processes on the other node(s). Correct the operating system error and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09979: skxfqhsnd: Error Sending a message to another endpoint<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The process was unable to send a message to an existing endpoint.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that the other node(s) are part of the cluster and operating properly. Check the instance and processes on the other node(s). Correct the operating system error and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09980: skxfqdrcv: Error Receiving a message from another endpoint<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The process encountered an error while trying to receive a message.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that the other node(s) are part of the cluster and operating properly. Check the instance and processes on the other node(s). Correct the operating system error and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09981: skxfqdreg: Error Adding a page to the SDI buffer pool<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The process was unable to add a page to the SDI buffer pool.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the operating system error and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09982: skxfqddrg: Error Removing a page from the SDI buffer pool<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The process was unable to remove a page to the SDI buffer pool.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the operating system error and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09983: skxfidsht: Error shutting down SDI channel<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The process was unable shut down the SDI channel<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the SDI persistent resources using SDI tools. Verify that all processes exited cleanly and the instance is safely shut down. Delete any remaining SDI channel IDs associated with the current instance.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09984: SGA file $ORACLE_HOME\/dbs\/sgadef$ORACLE_SID.dbf does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0file does not exist or is not accessible<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Restart the instance to create the SGA definition file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09985: SGA definition file could not be read<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0UNIX read() operation failed<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0check errno and take appropriate action.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09986: wrong number of bytes read from SGA definition file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Struct skgmsdef size differs from no. of bytes read from SGA file<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Compare the two struct definitions and ensure that they are identical in size and structure.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09987: unable to attach to SGA in READ-ONLY mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The instance is not up, or SGA segments are not read-accessible<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the instance is up and read permissions for the SGA segments are set.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09988: error while detaching SGA<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0skgmsdef struct is corrupted and\/or segment addresses are modified<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Safely shut down instance and mount SGA segments again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-09989: attempt to use invalid skgmsdef struct pointer<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Pointer to skgmsdef struct used without validating it<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Assign a valid address to the skgmsdef struct pointer before using it.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-09900 to ORA-10000 ORA-09908: slkmnm: gethostname returned error code. Cause:\u00a0The system call gethostname returned an error. Action:\u00a0This 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:\u00a0Memory needed for a…<\/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":false,"_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-1811","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-td","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1811","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=1811"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1811\/revisions"}],"predecessor-version":[{"id":1812,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1811\/revisions\/1812"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1811"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}