Friday 4 May 2012

ORA-27148: spawn wait error

ORA-27148: spawn wait error

Cause: OS system call failed

Action: check errno and contact Oracle Support

ORA-27147: post or wait reset failed

ORA-27147: post or wait reset failed

Cause: OS system call failed

Action: check errno and contact Oracle Support

ORA-27146: post or wait initialization failed

ORA-27146: post or wait initialization failed

Cause: OS system call failed

Action: check errno and contact Oracle Support

ORA-27145: insufficient resources for requested number of processes

ORA-27145: insufficient resources for requested number of processes

Cause: OS system call error

Action: check errno and contact Oracle Support

ORA-27144: attempt to kill process failed

ORA-27144: attempt to kill process failed

Cause: OS system call error

Action: check errno and contact Oracle Support

ORA-27143: OS system call failure

ORA-27143: OS system call failure

Cause: OS system call failed

Action: check errno and contact Oracle support

ORA-27142: could not create new process

ORA-27142: could not create new process

Cause: OS system call

Action: check errno and if possible increase the number of processes

ORA-27141: invalid process ID

ORA-27141: invalid process ID

Cause: process operation attempted using invalid process ID

Action: contact Oracle Support

ORA-27140: attach to post or wait facility failed

ORA-27140: attach to post or wait facility failed

Cause: The program attempted to initialize the post or wait facility, but the facility could not be attached.

Action: Check for additional errors and contact Oracle Support.

ORA-27128: unable to determine pagesize

ORA-27128: unable to determine pagesize

Cause: sysconf() call failed

Action: contact Oracle support

ORA-27127: unable to unlock shared memory segment

ORA-27127: unable to unlock shared memory segment

Cause: insufficient privileges to unlock shared memory segment

Action: make sure process is running with necessary privileges.

ORA-27126: unable to lock shared memory segment in core

ORA-27126: unable to lock shared memory segment in core

Cause: insufficient privileges to lock shared memory segment in core

Action: make sure process is running with necessary privileges.

ORA-27125: unable to create shared memory segment

ORA-27125: unable to create shared memory segment

Cause: shmget() call failed

Action: contact Oracle support

ORA-27124: unable to detach from shared memory segment

ORA-27124: unable to detach from shared memory segment

Cause: shmdt() call failed

Action: contact Oracle support

ORA-27123: unable to attach to shared memory segment

ORA-27123: unable to attach to shared memory segment

Cause: shmat() call failed

Action: check permissions on segment, contact Oracle support

ORA-27122: unable to protect memory

ORA-27122: unable to protect memory

Cause: mprotect() call failed

Action: contact Oracle support

ORA-27121: unable to determine size of shared memory segment

ORA-27121: unable to determine size of shared memory segment

Cause: shmctl() call failed

Action: check permissions on segment, contact Oracle support

ORA-27120: unable to removed shared memory segment

ORA-27120: unable to removed shared memory segment

Cause: shmctl() call failed

Action: check permissions on segment, contact Oracle support

ORA-27103: internal error

ORA-27103: internal error

Cause: internal error

Action: contact Oracle support

ORA-27102: out of memory

ORA-27102: out of memory

Cause: Out of memory

Action: Consult the trace file for details

ORA-27101: shared memory realm does not exist

ORA-27101: shared memory realm does not exist

Cause: Unable to locate shared memory realm

Action: Verify that the realm is accessible

ORA-27100: shared memory realm already exists

ORA-27100: shared memory realm already exists

Cause: Tried to start duplicate instances, or tried to restart an instance that had not been properly shutdown

Action: Use a different instance name, or cleanup the failed instance s SGA

ORA-27094: raw volume used can damage partition table

ORA-27094: raw volume used can damage partition table

Cause: A raw device with VTOC information was provided as a database file.

Action: Make sure the disk partition that is provided to Oracle does not start at sector 0

ORA-27093: could not delete directory

ORA-27093: could not delete directory

Cause: rmdir system call returned error

Action: check errno

ORA-27092: size of file exceeds file size limit of the process

ORA-27092: size of file exceeds file size limit of the process

Cause: an attempt was made to open a file that exceeds the process s file size limit (ulimit), additional information shows the current limit (logical blocks) and the size of the file (logical blocks)

Action: increase the processes file size limit (ulimit) and retry

ORA-27091: unable to queue I or O

ORA-27091: unable to queue I or O

Cause: read or write or readv or writev system call returned error, additional information indicates starting block number of I or O

Action: check errno

ORA-27089: unable to release advisory lock

ORA-27089: unable to release advisory lock

Cause: release of file lock failed

Action: see errno

ORA-27088: unable to get file status

ORA-27088: unable to get file status

Cause: file not open or file descriptor is invalid.

Action: none

ORA-27087: unable to get share lock - file not readable

ORA-27087: unable to get share lock - file not readable

Cause: share lock request was made on a file not open for read access.

Action: file must be open read-only or read-write to get a share lock.

ORA-27086: unable to lock file - already in use

ORA-27086: unable to lock file - already in use

Cause: the file is locked by another process, indicating that it is currently in use by a database instance.

Action: determine which database instance legitimately owns this file.

ORA-27084: unable to get or set file status flags

ORA-27084: unable to get or set file status flags

Cause: The fcntl() system call with F_GETFL or F_SETFL flag returned an error.

Action: Check errno.

ORA-27083: waiting for async I or Os failed

ORA-27083: waiting for async I or Os failed

Cause: The aio_waitn() library call returned an error.

Action: Check errno.

ORA-27081: unable to close the file

ORA-27081: unable to close the file

Cause: The close() system call failed.

Action: Check errno.

ORA-27080: too many files open

ORA-27080: too many files open

Cause: The number of files opened has reached the system limit.

Action: Check the error, and set system configuration values.

ORA-27078: unable to determine limit for open files

ORA-27078: unable to determine limit for open files

Cause: The getrlimit() system call returned an error.

Action: Check errno.

ORA-27077: too many files open

ORA-27077: too many files open

Cause: internal error, the number of files opened through skgfofi has reached the limit

Action: Check for trace file and contact Oracle Support.

ORA-27076: unable to set limit for open files

ORA-27076: unable to set limit for open files

Cause: The setrlimit() system call returned an error.

Action: Check errno.

ORA-27075: SSTMOFRC constant too large

ORA-27075: SSTMOFRC constant too large

Cause: internal error

Action: check for trace file and contact Oracle Support

ORA-27074: unable to determine limit for open files

ORA-27074: unable to determine limit for open files

Cause: The getrlimit() system call returned an error.

Action: Check errno.

ORA-27073: Trying to close a file which has async I or Os pending to be dequeued

ORA-27073: Trying to close a file which has async I or Os pending to be dequeued

Cause: internal error, the file is being closed but not all async I or Os to the file have been dequeued, additional information indicates number of I or Os pending on the file

Action: check for trace file and contact Oracle Support

ORA-27072: File I or O error

ORA-27072: File I or O error

Cause: read or write or readv or writev system call returned error, additional information indicates starting block number of I or O

Action: check errno

ORA-27071: unable to seek to desired position in file

ORA-27071: unable to seek to desired position in file

Cause: lseek system call returned error, additional information indicates block number in file to which seek was attempted

Action: check errno

ORA-27070: async read or write failed

ORA-27070: async read or write failed

Cause: aioread or aiowrite system call returned error, additional information indicates starting block number of I or O

Action: check errno

ORA-27069: attempt to do I or O beyond the range of the file

ORA-27069: attempt to do I or O beyond the range of the file

Cause: internal error, the range of blocks being read or written is outside the range of the file, additional information indicates the starting block number, number of blocks in I or O, and the last valid block in the file

Action: check for trace file and contact Oracle Support

ORA-27068: I or O buffer is not aligned properly

ORA-27068: I or O buffer is not aligned properly

Cause: internal error, buffer is not aligned to SSIOALIGN boundary, additional information indicates where in function the error was encountered and the buffer pointer

Action: check for trace file and contact Oracle Support

ORA-27067: size of I or O buffer is invalid

ORA-27067: size of I or O buffer is invalid

Cause: internal error, buffer size is either 0, or greater than SSTIOMAX or not a multiple of logical block size, additional information indicates where in function the error was encountered and the buffer size

Action: check for trace file and contact Oracle Support

ORA-27066: number of buffers in vector I or O exceeds maximum

ORA-27066: number of buffers in vector I or O exceeds maximum

Cause: internal error, number of buffers in vector I or O exceeds maximum allowed by the OSD, additional information indicates both these numbers

Action: check for trace file and contact Oracle Support

ORA-27065: cannot perform async vector I or O to file

ORA-27065: cannot perform async vector I or O to file

Cause: internal error, asked to perform async vector I or O when it cannot be performed on the file

Action: check for trace file and contact Oracle Support

ORA-27064: cannot perform async I or O to file

ORA-27064: cannot perform async I or O to file

Cause: internal error, asked to perform async I or O when IOV indicates that it cannot be performed on the file

Action: check for trace file and contact Oracle Support

ORA-27063: number of bytes read or written is incorrect

ORA-27063: number of bytes read or written is incorrect

Cause: the number of bytes read or written as returned by aiowait does not match the original number, additional information indicates both these numbers

Action: check errno

ORA-27062: could not find pending async I or Os

ORA-27062: could not find pending async I or Os

Cause: There should have been some async I or Os in the system but a blocking aiowait indicates that there are no more I or Os. It could be either because of an Oracle bug or the vendor OS bug or due to a NFS server not responding

Action: check Oracle trace file, OS message files and contact Oracle Support

ORA-27061: waiting for async I or Os failed

ORA-27061: waiting for async I or Os failed

Cause: aiowait function returned error

Action: check errno

ORA-27060: could not set close-on-exec bit on file

ORA-27060: could not set close-on-exec bit on file

Cause: fcntl system call returned error

Action: check errno

ORA-27059: could not reduce file size

ORA-27059: could not reduce file size

Cause: ftruncate system call returned error

Action: check errno

ORA-27058: file I or O question parameter is invalid

ORA-27058: file I or O question parameter is invalid

Cause: internal error, invalid query is being asked

Action: check for trace file and contact Oracle Support

ORA-27057: cannot perform async I or O to file

ORA-27057: cannot perform async I or O to file

Cause: internal error, query is being asked about async vector I or O when the file does not support async I or O

Action: check for trace file and contact Oracle Support

ORA-27056: could not delete file

ORA-27056: could not delete file

Cause: unlink system call returned error

Action: check errno

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Cause: The file was on an NFS partition and either reading the mount tab file failed or the partition wass not mounted with the correct mount option.

Action: Make sure mount tab file has read access for Oracle user and the NFS partition where the file resides is mounted correctly. For the list of mount options to use refer to your platform specific documentation.

ORA-27053: blocksize in file header not a multiple of logical block size

ORA-27053: blocksize in file header not a multiple of logical block size

Cause: the logical block size is invalid, additional information indicates the logical block size and the blocksize in the file header

Action: use a different logical block size, or do not reuse file

ORA-27052: unable to flush file data

ORA-27052: unable to flush file data

Cause: fsync system call returned error, additional information indicates which function encountered the error

Action: check errno