Oracle 12c R2 Error Codes and Solution Suggestions from ORA-07200 to ORA-07400
- ORA-07200: slsid: oracle_sid not set.
Cause: The environment variable $(ORACLE_SID) is not set.
Action: Set ORACLE_SID environment variable.
Cause: $(ORACLE_HOME) environment variable not set.
Action: Set ORACLE_HOME.
Cause: The sltln name translation routine was called with invalid arguments. The input, or output stings were either NULL or 0 length.
Action: Probable internal oracle error. Contact customer support.
Cause: A string was passed to sltln containing a long environment variable. sltln accepts environment names of 30 or less characters.
Action: Shorten environment variable name to less than 30 characters.
Cause: The sltln routine is given a maximum length buffer to expand the name into. An overflow of this buffer occurred.
Action: Possible internal error. Check output buffer length stored in sercose[0]. Pathnames are limited to 255 characters.
Cause: Time() system call returned an error. Possible OS error.
Action: Check additional information returned. Contact customer support.
Cause: Gettimeofday() system call returned an error. Possible OS error.
Action: Check additional information returned. Contact customer support.
Cause: The sigpidu routine is given a maximum length buffer to hold process ID string. An overflow of this buffer occurred.
Action: Internal error. Contact customer support.
Cause: The fsync system call returned an error. Possible OS error.
Action: Check additional information returned. Contact customer support.
Cause: The size of the file to be opened exceeded the OS limit imposed on this process.
Action: Run osh to increase the file size limit.
Cause: Getrusage system call returned an error. Possible OS error.
Action: Check additional information returned. Contact customer support.
Cause: Gettimeofday system call returned an error. Possible OS error.
Action: Check additional information returned in OS reference manual. Contact customer support.
Cause: times system call returned an error. Possible OS error.
Action: Check additional information returned. Contact customer support.
Cause: times system call returned an error. Possible OS error.
Action: Check additional information returned in OS reference manual. Contact customer support.
Cause: uname system call returned an error. Possible OS error.
Action: Check additional information returned in OS reference manual. Contact customer support.
Cause: Getrusage system call returned an error. Possible OS error.
Action: Check additional information returned. Look for information in OS reference. Contact customer support.
Cause: gethostname system call returned an error. Possible OS error.
Action: Check additional information returned in OS reference manual. Contact customer support.
Cause: getenv call returned a null pointer.
Action: Set the environment variable and try again.
Cause: Unix system() call failed
Action: Examine system error message
Cause: Malloc failed to allocate space to hold spooler arguments.
Action: Check additional information returned in OS reference manual. The process may have run out of heap space. Contact customer support.
Cause: Wait returned an error, when waiting for spool job to complete. Possible spooler program error.
Action: Check additional information returned. Refer to OS reference manual. Contact customer support.
Cause: Exec failed when starting line printer spooler command. Likely that either the default line printer command, or ORACLE_LPPROG, is incorrectly set.
Action: Verify default line printer command and ORACLE_LPPROG are set correctly. Set ORACLE_LPPROG to working line printer spooler.
Cause: The line printer spooler exited with a non-zero return value. This probably indicates an error in spooling file.
Action: Verify that line printer spooler is up. Verify that ORACLE_LPPROG, and ORACLE_LPARG are set properly. Check exit value returned as additional informatin.
Cause: Fork system call failed to create additional process. Probable resource limit reached.
Action: Check additional information returned. Retry operation. Contact system administrator.
Cause: The ulimit system call returned an error.
Action: Check errno and contact customer support.
Cause: Additional information returned is error returned from sltln.
Action: Check additional information.
Cause: The ioctl call returned an error. Possible OS error.
Action: Check additional information for errno. Contact customer support.
Cause: The ioctl call returned an error. Possible OS error.
Action: Check additional information for errno. Contact customer support.
Cause: The ioctl call returned an error. Possible OS error.
Action: Check additional information for errno. Contact customer support.
Cause: error in mpcntl system call
Action: check errno and contact system administrator
Cause: Fopen failed to open file.
Action: Try to determine which file was not opened. Check that file exists and is accessible.
Cause: Function was called with an invalid argument. The file handle used was not obtained be slemcr.
Action: Internal error. Contact customer support.
Cause: An error was encountered when closing the file. Possible OS error.
Action: Contact system administator.
Cause: Function was called with an invalid file handle. File handle was not obtained by slemcr.
Action: Internal error. Contact customer support.
Cause: Unable to seek to desired position in file. Possible OS error. Possible internal error.
Action: Verify that error message file is intact. Try to regenerate error message file. Contact customer support.
Cause: Unable to write item to file. Possible OS error. Possible permissions problem.
Action: Retry operation.
Cause: Unable to open error file. Possible permissions problem.
Action: Verify permission on error message file. Check additional information for errno.
Cause: Function was called with an invalid file handle. Handle was not obtained by previous call to slemop.
Action: Internal error.
Cause: Unable to close file. Possible OS error.
Action: Contact system administator. Check additional information for errno.
Cause: Function was called with invalid file handle. Handle was not obtained by call to slemop.
Action: Internal error. Contact customer support.
Cause: Unable to seek to desired position in file. Possible OS error.
Action: Check that error file is still intact. Verify space on device. Contact system administrator. Check additional information for errno.
Cause: Unable to read file. Possible OS error.
Action: Verify that error file is intact. Regenerate error message file. Contact customer support. Check additional information for errno.
Cause: Additional information indicates error returned from sltln.
Action: Check additional information.
Cause: supplied buffer was not big enough
Action: Internal error. Contact customer support. Additional information indicates how big the supplied buffer was.
Cause: An attempt was made to create a file that exceeds the process’s file size limit.
Action: Run osh to raise the file size limit.
Cause: An attempt was made to move and write to a bad device address.
Action: Check errno. Possible lack of space on device.
Cause: sfofi returns an error.
Action: This is an oracle internal error.
Cause: The ioctl() system call returned an error doing VOL_READ_MIRRORS.
Action: Check errno.
Cause: sfwfb returns an error.
Action: This is an oracle internal error.
Cause: The open() system call returned an error.
Action: Check that /proc has the right permissions.
Cause: An error occurred when trying to get first semaphore set.
Action: Check errno. Verify that system is configured to have semaphores. Verify that enough semaphores are available. Additional information indicates how many semaphores were requested.
Cause: Semget failed to even allocate a single semaphore. Either they are all in use or the system is not configured to have any semaphores.
Action: Check to see if all semaphores are in use. Check to see if system is configured to have semaphores. Check errno.
Cause: Semget system call returned an error. Possible resource limit problem.
Action: Check 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.
Cause: Semctl system call returned an error.
Action: Check semaphore sets. May require manual cleanup. Check additional information returned. Consult OS reference manual.
Cause: An error occurred while translating the name of the oracle executable.
Action: Check sercose[0] for error returned from sltln. Perhaps $(ORACLE_HOME) is not set correctly.
Cause: System failed to set up signal handler.
Action: Check errno and sercose[0] for the signal number that failed.
Cause: System failed to set up signal handler to catch exceptions.
Action: Check errno and sercose[0] for the signal number that failed.
Cause: Error ocurred when expanding program name ora_PNAME_@. The result of this translation is put in argv[0] of oracle process.
Action: Check error returned by sltln returned in sercose[0].
Cause: An error occurred when creating a new process.
Action: Check errno. Perhaps a system limit on the number of processes has been exceeded.
Cause: An oracle detached process died shortly after startup. Wait() indicated that a child process terminated.
Action: Check ?/dbs directory for trace or core files. Check errno.
Cause: Wait system call returned an error.
Action: Check errno.
Cause: Kill system call returned an error. Possibly an attempt to destroy an already gone process.
Action: Check errno.
Cause: This is an internal error.
Action: This is an oracle internal error.
Cause: Kill system call returned an error. Possible OS error.
Action: Check errno. Additional information indicates the process ID tested.
Cause: Semop system call returned an error. Semaphore set may not exist.
Action: Check 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.
Cause: Semop system call returned an error. Semaphore set may not exist.
Action: Check 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.
Cause: Function was passed an invalid oracle process id.
Action: Internal error.
Cause: Function was passed an invalid oracle process id.
Action: Internal error. Additional information indicates the invalid process id.
Cause: Getpwuid() could not find an entry in the passwd file for a user.
Action: Add an entry for the user in the passwd file.
Cause: Detached process succesfully execed, but died shortly thereafter. Additional information indicates exit code, and termination status.
Action: Check termination code for information as to why process exited. Check for core dump or trace file.
Cause: An error occurred while trying to set an interval timer. Probable porting problem.
Action: Check errno.
Cause: Function was called with an invalid oracle process number (0).
Action: Internal oracle error.
Cause: Semaphore ID fetched from SGA was not initialized to valid value. Additional information returned is semaphore set index, and oracle process number.
Action: Oracle internal error. Check semaphore set index. Check oracle process number.
Cause: Semaphore ID fetched from SGA contained an invalid value. Additional information returned is semaphore set index, and oracle process number.
Action: Oracle internal error. Check semaphore set index. Check oracle process number.
Cause: Unable to access “oracle” program. Verify ?/bin/oracle or $ORABCKPRG exist, and are executable.
Action: Check errno returned.
Cause: The kill system call returned an error. Possibly an attempt to signal a process which does not exist.
Action: Check errno.
Cause: A group has not been set up for dba users.
Action: Contact system administrator. Set up dba group in /etc/group.
Cause: A 0 pid was passed to spdde.
Action: Internal error. .
Cause: Splon constructed an ops$username logon which exceeded the alloted buffer space.
Action: Use a shorter Unix username, or use an oracle username. Contact customer support.
Cause: An error occurred when trying to get first semaphore set.
Action: Check errno. Verify that system is configured to have semaphores. Verify that enough semaphores are available. Additional information indicates how many semaphores were requested.
Cause: The ioctl call returned an error. Possible OS error.
Action: Check additional information for errno. Contact customer support.
Cause: times system call returned an error. Possible OS error.
Action: Check additional information returned. Contact customer support.
Cause: The internal buffer is not big enough to hold the archive control string.
Action: Internal restriction. Try a shorter archive control string.
Cause: An invalid volume size was specified.
Action: Specify a valid volume size in archive control string.
Cause: Some non-numeric text follows the volume size specification.
Action: Enter a correct archive control string.
Cause: Volume size was specified for a disk file.
Action: If you are archiving to a disk file, do not specify its volume size.
Cause: Stat on the log archiving device failed.
Action: Check the returned OSD error for the reason of failure.
Cause: Log archiving to this device is unsupported.
Action: Try log archiving to a supported device.
Cause: The specified pathname is not a directory.
Action: Verify that the archive destination directory exists.
Cause: The database buffer size must be a multiple of the database block size, and less than the maximum block size.
Action: Verify that the db_block_size parameter is correct in INIT.ORA.
Cause: The redo buffer size must be a multiple of machine block size.
Action: Verify that the log_buffer INIT.ORA parameter is correctly set.
Cause: Malloc library routine returned an error.
Action: Check errno. Possibly out of swap space.
Cause: Smpdal was called when the PGA had not been previously created.
Action: Internal error.
Cause: The internal buffer is not big enough to hold the number of semaphore set identifiers requested.
Action: Reconfigure OS to have more semaphores per set.
Cause: The specified datafile name contains ‘..’.
Action: Correct the datafile name and retry the operation.
Cause: After normalizing the specified file name, the resulting file name was too long.
Action: Specify the shorter file name and retry the operation.
Cause: An error occurred while expanding the file name to open. Additional information returns error generated in translation routine.
Action: Lookup additional error code for further information.
Cause: Fopen library routine returned an error.
Action: Verify existence and permissions.
Cause: Fclose library routine returned an error.
Action: Possible internal oracle error.
Cause: An error occurred while deleting a text file.
Action: Verify that the file exists and check additional errors.
Cause: An error occurred while performing a string put operation.
Action: This is an internal error. Check additional information.
Cause: The name for the message file overflows internal buffer.
Action: Try making the complete path-name of the message file shorter by reorganizing the directory hierarchy.