Troubleshooting ORA-27300 ORA-27301 ORA-27302 Errors
(Doc ID 579365.1)
Last updated on SEPTEMBER 05, 2024
Applies to:
Oracle Database Cloud Exadata Service - Version N/A and laterOracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.1.0.7 to 21.4 [Release 11.1 to 21.0]
Information in this document applies to any platform.
Purpose
This note helps identify the possible causes of the ORA-2730x errors that have already been reported and provides solution where available. The errors are usually caused by OS system call error or OS configuration issue and are in the form of:
ORA-27301: OS failure message: %s
ORA-27302: failure occurred at: %s
You can refer the respective OS manual for the background information on how Unix OS errors work. Check below link for 'Typical Unix Errors from errno.h Header File":
https://docs.faircom.com/doc/knowledgebase/56135.htm
Please note only a handful of errors are standard across all Unix-based platforms. Documentation is available at the OS level for some of the dependent operation or OS calls such as fork() or semget(). The 'status' reported in the ORA-27300 error usually corresponds to a Unix error code defined in the "errno.h" header file on the OS, returned by the OS call.
For example,
ORA-27300: OS system dependent operation:fork failed with status: 11
A "man fork" shows:
EAGAIN (status 11) : The system lacked the necessary resources to create another process, or the system-imposed limit on the total number of processes under execution system-wide or by a single user {CHILD_MAX} would be exceeded. EAGAIN corresponds to status 11.
The fork() function may fail if:
ENOMEM (status 12) : Insufficient storage space is available.
Troubleshooting Steps
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Troubleshooting Steps |
| References |