My Oracle Support Banner

Troubleshooting ORA-27300 ORA-27301 ORA-27302 Errors (Doc ID 579365.1)

Last updated on NOVEMBER 11, 2024

Applies to:

Oracle Database Backup Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
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-27300: OS system dependent operation:%s failed with status: %s
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:

The fork() function shall fail if:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.