My Oracle Support Banner

Primary Note: Troubleshooting Unix Resources (Doc ID 1507742.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 12.1.0.1 [Release 9.2 to 12.1]
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 Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


Purpose

This document discusses and provides notes for Common Issues related to Unix Resources while running oracle database.
i.e WARNING:ORACLE PROCESS RUNNING OUT OF OS KERNEL I/O RESOURCES
WARNING: asynch I/O kernel limits is set at AIO-MAX-NR=1048576 AIO-NR=242593
ORA-27300 ORA-27301 ORA-27302

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
 Overview
 Common Issues related to Unix Resources
 WARNING: Oracle process running out of OS kernel I/O resources
 WARNING: Could not set the asynch I/O limit to 128 for SQL direct I/O. It is set to 0
 WARNING: io_submit failed due to kernel limitations MAXAIO for process=4096 pending aio=3968
WARNING: asynch I/O kernel limits is set at AIO-MAX-NR=1048576 AIO-NR=242593
 Process J000 died, see its trace filekkjcre1p: unable to spawn jobq secondary process
 ORA- errors related to the Unix Resources
 ORA-27300 ORA-27301 ORA-27302
 ORA-4030
 ORA-4036
 Other Helpful Documents
 Further Diagnostics
References

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