{"id":1787,"date":"2016-03-15T12:18:21","date_gmt":"2016-03-15T09:18:21","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1787"},"modified":"2016-10-21T12:20:19","modified_gmt":"2016-10-21T09:20:19","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-07200-to-ora-07400","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-07200-to-ora-07400\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-07200 to ORA-07400"},"content":{"rendered":"

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

\n
ORA-07200: slsid: oracle_sid not set.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The environment variable $(ORACLE_SID) is not set.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Set ORACLE_SID environment variable.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07201: slhom: oracle_home variable not set in environment.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0$(ORACLE_HOME) environment variable not set.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Set ORACLE_HOME.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07202: sltln: invalid parameter to sltln.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The sltln name translation routine was called with invalid arguments. The input, or output stings were either NULL or 0 length.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Probable internal oracle error. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07203: sltln: attempt to translate a long environment variable.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A string was passed to sltln containing a long environment variable. sltln accepts environment names of 30 or less characters.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Shorten environment variable name to less than 30 characters.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07204: sltln: name translation failed due to lack of output buffer space.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The sltln routine is given a maximum length buffer to expand the name into. An overflow of this buffer occurred.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Possible internal error. Check output buffer length stored in sercose[0]. Pathnames are limited to 255 characters.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07205: slgtd: time error, unable to obtain time.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Time() system call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information returned. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07206: slgtd: gettimeofday error, unable to obtain time.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Gettimeofday() system call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information returned. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07207: sigpidu: process ID string overflows internal buffer.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The sigpidu routine is given a maximum length buffer to hold process ID string. An overflow of this buffer occurred.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07208: sfwfb: failed to flush dirty buffers to disk.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The fsync system call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information returned. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07209: sfofi: file size limit was exceeded.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The size of the file to be opened exceeded the OS limit imposed on this process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Run osh to increase the file size limit.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07210: slcpu: getrusage error, unable to get cpu time.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Getrusage system call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information returned. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07211: slgcs: gettimeofday error, unable to get wall clock.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Gettimeofday system call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information returned in OS reference manual. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07212: slcpu: times error, unable to get cpu time.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0times system call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information returned. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07213: slgcs: times error, unable to get wall clock.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0times system call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information returned in OS reference manual. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07214: slgunm: uname error, unable to get system information.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0uname system call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information returned in OS reference manual. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07215: slsget: getrusage error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Getrusage system call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information returned. Look for information in OS reference. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07216: slghst: gethostname error, unable to get name of current host.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0gethostname system call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information returned in OS reference manual. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07217: sltln: environment variable cannot be evaluated.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0getenv call returned a null pointer.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Set the environment variable and try again.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07218: slkhst: could not perform host operation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Unix system() call failed<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Examine system error message<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07219: slspool: unable to allocate spooler argument buffer.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Malloc failed to allocate space to hold spooler arguments.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information returned in OS reference manual. The process may have run out of heap space. Contact customer support.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-07220: slspool: wait error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Wait returned an error, when waiting for spool job to complete. Possible spooler program error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information returned. Refer to OS reference manual. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07221: slspool: exec error, unable to start spooler program.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Exec failed when starting line printer spooler command. Likely that either the default line printer command, or ORACLE_LPPROG, is incorrectly set.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify default line printer command and ORACLE_LPPROG are set correctly. Set ORACLE_LPPROG to working line printer spooler.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07222: slspool: line printer spooler command exited with an error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The line printer spooler exited with a non-zero return value. This probably indicates an error in spooling file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that line printer spooler is up. Verify that ORACLE_LPPROG, and ORACLE_LPARG are set properly. Check exit value returned as additional informatin.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07223: slspool: fork error, unable to spawn spool process.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Fork system call failed to create additional process. Probable resource limit reached.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information returned. Retry operation. Contact system administrator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07224: sfnfy: failed to obtain file size limit; errno =\u00a0string<\/i>.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The ulimit system call returned an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno and contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07225: sldext: translation error, unable to expand file name.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Additional information returned is error returned from sltln.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07226: rtneco: unable to get terminal mode.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The ioctl call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information for errno. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07227: rtneco: unable to set noecho mode.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The ioctl call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information for errno. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07228: rtecho: unable to restore terminal to echo mode.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The ioctl call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information for errno. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07229: slcpuc: error in getting number of CPUs.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0error in mpcntl system call<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0check errno and contact system administrator<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07230: slemcr: fopen error, unable to open error file.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Fopen failed to open file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Try to determine which file was not opened. Check that file exists and is accessible.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07231: slemcc: invalid file handle, seals do not match.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Function was called with an invalid argument. The file handle used was not obtained be slemcr.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07232: slemcc: fclose error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error was encountered when closing the file. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact system administator.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07233: slemcw: invalid file handle, seals do not match.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Function was called with an invalid file handle. File handle was not obtained by slemcr.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07234: slemcw: fseek error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Unable to seek to desired position in file. Possible OS error. Possible internal error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that error message file is intact. Try to regenerate error message file. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07235: slemcw: fwrite error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Unable to write item to file. Possible OS error. Possible permissions problem.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07236: slemop: open error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Unable to open error file. Possible permissions problem.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify permission on error message file. Check additional information for errno.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07237: slemcl: invalid file handle, seals do not match.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Function was called with an invalid file handle. Handle was not obtained by previous call to slemop.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07238: slemcl: close error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Unable to close file. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact system administator. Check additional information for errno.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07239: slemrd: invalid file handle, seals do not match.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Function was called with invalid file handle. Handle was not obtained by call to slemop.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07240: slemrd: seek error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Unable to seek to desired position in file. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that error file is still intact. Verify space on device. Contact system administrator. Check additional information for errno.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07241: slemrd: read error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Unable to read file. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that error file is intact. Regenerate error message file. Contact customer support. Check additional information for errno.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07242: slembfn: translation error, unable to translate error file name.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Additional information indicates error returned from sltln.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07243: supplied buffer not big enough to hold entire line<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0supplied buffer was not big enough<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error. Contact customer support. Additional information indicates how big the supplied buffer was.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07244: ssfccf: create file failed, file size limit reached.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create a file that exceeds the process’s file size limit.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Run osh to raise the file size limit.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07245: sfccf: unable to lseek and write the last block.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to move and write to a bad device address.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno. Possible lack of space on device.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07246: sfofi: open error, unable to open database file.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0sfofi returns an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an oracle internal error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07247: skgfrfms, skgfrnms: read error, unable to read block from database file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The ioctl() system call returned an error doing VOL_READ_MIRRORS.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07248: sfwfb: write error, unable to write database block.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0sfwfb returns an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an oracle internal error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07249: slsget: open error, unable to open \/proc\/pid.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The open() system call returned an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check that \/proc has the right permissions.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07250: spcre: semget error, unable to get first semaphore set.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred when trying to get first semaphore set.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno. Verify that system is configured to have semaphores. Verify that enough semaphores are available. Additional information indicates how many semaphores were requested.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07251: spcre: semget error, could not allocate any semaphores.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Semget failed to even allocate a single semaphore. Either they are all in use or the system is not configured to have any semaphores.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check to see if all semaphores are in use. Check to see if system is configured to have semaphores. Check errno.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07252: spcre: semget error, could not allocate semaphores.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Semget system call returned an error. Possible resource limit problem.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno. Verify that enough semaphores are available in system. If additional errors occur in destroying the semaphore sets then sercose[0] will be non-zero. If this occurs, remove the semaphore sets using ipcrm.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07253: spdes: semctl error, unable to destroy semaphore set.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Semctl system call returned an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check semaphore sets. May require manual cleanup. Check additional information returned. Consult OS reference manual.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07254: spdcr: translation error while expanding ?\/bin\/oracle.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred while translating the name of the oracle executable.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check sercose[0] for error returned from sltln. Perhaps $(ORACLE_HOME) is not set correctly.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07255: spini: cannot set up signal handler.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0System failed to set up signal handler.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno and sercose[0] for the signal number that failed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07256: sptrap: cannot set up signal handler to catch exceptions.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0System failed to set up signal handler to catch exceptions.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno and sercose[0] for the signal number that failed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07257: spdcr: translation error expanding program name.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Error ocurred when expanding program name ora_PNAME_@. The result of this translation is put in argv[0] of oracle process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check error returned by sltln returned in sercose[0].<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07258: spdcr: fork error, unable to create process.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred when creating a new process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno. Perhaps a system limit on the number of processes has been exceeded.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07259: spdcr: exec error, detached process failed in startup.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An oracle detached process died shortly after startup. Wait() indicated that a child process terminated.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check ?\/dbs directory for trace or core files. Check errno.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07260: spdcr: wait error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Wait system call returned an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07261: spdde: kill error, unable to send signal to process.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Kill system call returned an error. Possibly an attempt to destroy an already gone process.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07262: sptpa: sptpa called with invalid process id.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This is an internal error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an oracle internal error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07263: sptpa: kill error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Kill system call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno. Additional information indicates the process ID tested.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07264: spwat: semop error, unable to decrement semaphore.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Semop system call returned an error. Semaphore set may not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno. Semaphore ID is returned in sercose[0]. Verify semaphore set exists. A possible cause for this error is that a “shutdown abort” was done while this process was running.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07265: sppst: semop error, unable to increment semaphore.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Semop system call returned an error. Semaphore set may not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno. Semaphore ID is returned in sercose[0]. Check semaphore set existence. A possible cause for this error is that a “shutdown abort” was done while this process was running.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07266: sppst: invalid process number passed to sppst.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Function was passed an invalid oracle process id.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07267: spwat: invalid process number.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Function was passed an invalid oracle process id.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error. Additional information indicates the invalid process id.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07268: szguns: getpwuid error.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Getpwuid() could not find an entry in the passwd file for a user.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Add an entry for the user in the passwd file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07269: spdcr: detached process died after exec.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Detached process succesfully execed, but died shortly thereafter. Additional information indicates exit code, and termination status.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check termination code for information as to why process exited. Check for core dump or trace file.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07270: spalck: setitimer error, unable to set interval timer.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred while trying to set an interval timer. Probable porting problem.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07271: spwat: invalid oracle process number.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Function was called with an invalid oracle process number (0).<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal oracle error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07272: spwat: invalid semaphore set id.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Semaphore ID fetched from SGA was not initialized to valid value. Additional information returned is semaphore set index, and oracle process number.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Oracle internal error. Check semaphore set index. Check oracle process number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07273: sppst: invalid semaphore id.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Semaphore ID fetched from SGA contained an invalid value. Additional information returned is semaphore set index, and oracle process number.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Oracle internal error. Check semaphore set index. Check oracle process number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07274: spdcr: access error, access to oracle denied.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Unable to access “oracle” program. Verify ?\/bin\/oracle or $ORABCKPRG exist, and are executable.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno returned.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07275: unable to send signal to process<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The kill system call returned an error. Possibly an attempt to signal a process which does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07276: no dba group in \/etc\/group.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A group has not been set up for dba users.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact system administrator. Set up dba group in \/etc\/group.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07277: spdde: illegal pid passed as argument.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A 0 pid was passed to spdde.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error. .<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07278: splon: ops$username exceeds buffer length.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Splon constructed an ops$username logon which exceeded the alloted buffer space.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a shorter Unix username, or use an oracle username. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07279: spcre: semget error, unable to get first semaphore set.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred when trying to get first semaphore set.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno. Verify that system is configured to have semaphores. Verify that enough semaphores are available. Additional information indicates how many semaphores were requested.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07280: slsget: unable to get process information.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The ioctl call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information for errno. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07281: slsget: times error, unable to get cpu time.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0times system call returned an error. Possible OS error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check additional information returned. Contact customer support.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07282: sksaprd: string overflow.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The internal buffer is not big enough to hold the archive control string.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal restriction. Try a shorter archive control string.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07283: sksaprd: invalid volume size for archive destination.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid volume size was specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a valid volume size in archive control string.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07284: sksaprd: volume size specification not terminated properly.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Some non-numeric text follows the volume size specification.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enter a correct archive control string.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07285: sksaprd: volume size should not be specified for a disk file.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Volume size was specified for a disk file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If you are archiving to a disk file, do not specify its volume size.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07286: sksagdi: cannot obtain device information.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Stat on the log archiving device failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the returned OSD error for the reason of failure.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07287: sksagdi: unsupported device for log archiving.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Log archiving to this device is unsupported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Try log archiving to a supported device.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07290: sksagdi: specified directory for archiving does not exist.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified pathname is not a directory.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the archive destination directory exists.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07303: ksmcsg: illegal database buffer size.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The database buffer size must be a multiple of the database block size, and less than the maximum block size.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the db_block_size parameter is correct in INIT.ORA.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07304: ksmcsg: illegal redo buffer size.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The redo buffer size must be a multiple of machine block size.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the log_buffer INIT.ORA parameter is correctly set.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07305: ksmcsg: illegal database buffer size.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The database buffer size must be a multiple of the extended cache mapping size for indirect data buffers to be used.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the db_block_size parameter is correct in INIT.ORA, or disable the use_indirect_data_buffers parameter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07324: smpall: malloc error while allocating pga.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Malloc library routine returned an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check errno. Possibly out of swap space.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07327: smpdal: attempt to destroy pga when it was not mapped.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Smpdal was called when the PGA had not been previously created.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Internal error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07339: spcre: maximum number of semaphore sets exceeded.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The internal buffer is not big enough to hold the number of semaphore set identifiers requested.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reconfigure OS to have more semaphores per set.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07345: The datafile name must not contain the string ‘..’.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified datafile name contains ‘..’.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the datafile name and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07346: slnrm: normalized file name is too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0After normalizing the specified file name, the resulting file name was too long.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify the shorter file name and retry the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07390: sftopn: translate error, unable to translate file name.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred while expanding the file name to open. Additional information returns error generated in translation routine.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Lookup additional error code for further information.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07391: sftopn: fopen error, unable to open text file.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Fopen library routine returned an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify existence and permissions.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07392: sftcls: fclose error, unable to close text file.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Fclose library routine returned an error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Possible internal oracle error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07393: unable to delete text file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred while deleting a text file.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that the file exists and check additional errors.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07394: unable to append string to text file<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred while performing a string put operation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This is an internal error. Check additional information.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-07400: slemtr: translated name for the message file is too long.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The name for the message file overflows internal buffer.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Try making the complete path-name of the message file shorter by reorganizing the directory hierarchy.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-07200 to ORA-07400 ORA-07200: slsid: oracle_sid not set. Cause:\u00a0The environment variable $(ORACLE_SID) is not set. Action:\u00a0Set ORACLE_SID environment variable. ORA-07201: slhom: oracle_home variable not set in environment. Cause:\u00a0$(ORACLE_HOME) environment variable not set. Action:\u00a0Set ORACLE_HOME. ORA-07202: sltln: invalid parameter to sltln. Cause:\u00a0The sltln name translation routine was called…<\/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-1787","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-sP","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1787","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=1787"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1787\/revisions"}],"predecessor-version":[{"id":1788,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1787\/revisions\/1788"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1787"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}