topic Re: Oracle process running out of OS Kernel I/O Resources in Operating System - Linux

Oracle process running out of OS Kernel I/O Resources

Basheer_2 — Tue, 27 Dec 2005 17:48:44 GMT

Which parameter to increase to avoid this error.

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, Oracle Label Security, OLAP and Data Mining options ORACLE_HOME
Linux, Release: 2.4.21-32.EL
Version: #1 SMP Fri Apr 15 21:02:58 EDT 2005
Machine: x86_64
*** SERVICE NAME:(SYS$BACKGROUND) 2005-11-09 14:50:46.940
*** SESSION ID:(167.1) 2005-11-09 14:50:46.940
WARNING:Oracle process running out of OS kernel I/O resources

Re: Oracle process running out of OS Kernel I/O Resources

Steven E. Protter — Wed, 28 Dec 2005 07:33:34 GMT

Shalom Basheer,

sysctl -a

You need to actually know what resources are running out in this situation.

I/O resources implies that there is an I/O bottleneck, which means you may need to reconsider your current storage layout. Oracle databases with a lot of writes, perform best when their data is written to RAID 1 storage.

Raid 5 storage causes writes to be very slow because lots of disks are being updated with every write. Very quickly a system can fall behind on i/o and get this problem.

What kind of system is this?
What OS, though I believe we're looking at RH 3 64 bit. Is the server Itanium or other Intel product?

How much memory does the system have.

Oracle needs logs of shared memroy (shmmax in the kernel) and logs of shared memory segments (shmseg in the kernel).

How many instances are you running?

With more information, we can help. Please check syslog, /var/adm/messages for problems and error messages. They can be most helpful.

SEP

Re: Oracle process running out of OS Kernel I/O Resources

Basheer_2 — Wed, 28 Dec 2005 10:05:48 GMT

Thanks Sep

RHEL Ver 3 and 5 x86_64
16GB RAM
Intel DL380G2
Its on the SAN with RAID5
App is Datawarehouse
Only One Instance
ora 10g

kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 2147483648

Oracle needs logs of shared memroy (shmmax in the kernel) and logs of shared memory segments (shmseg in the kernel).

No /var/adm/messages - no such dir /var/adm

Re: Oracle process running out of OS Kernel I/O Resources

Delrish — Wed, 28 Dec 2005 10:42:57 GMT

This is a bug reported for Oracle enterprise edition, version 10.2.0.1.0 on kernel number 2.4.21-32.EL.
After database startup the following error was received: .
WARNING:Oracle process running out of OS kernel I/O resources .
Verified the issue by the trace file /db01/oracle/admin/dwhs/bdump/dwhs_dbw_07206.trc, which displays
WARNING:Oracle process running out of OS kernel I/O resources.
Oracle do not release any fix for this bug yet.

Re: Oracle process running out of OS Kernel I/O Resources

Basheer_2 — Wed, 28 Dec 2005 12:33:04 GMT

Salaams Ali,

Thanks for the info.

I Need more Info from the Bug so I can send that to our DBA's.

Do you have anything from metalink. Is this searchable under Metalink.

Thanks
Basheer

Re: Oracle process running out of OS Kernel I/O Resources

Delrish — Wed, 28 Dec 2005 14:11:39 GMT

Ø³Ù Ø§Ù Ø¹Ù Û Ú©Ù
This error is related to bug no. 4758594 .You can contact them for further information. As I told you later, they do not offer any fix for this bug yet.
They are gathering informtion for this error. As I understood, this bug is seen on HP-UX and Linux operating systems.
take a look at following link of metalink.
https://metalink.oracle.com/metalink/plsql/f?p=130:15:2020623650024614718::::p15_database_id,p15_docid,p15_show_header,p15_show_help,p15_black_frame,p15_font:BUG,4758594,1,1,1,helvetica

Re: Oracle process running out of OS Kernel I/O Resources

Steven E. Protter — Wed, 28 Dec 2005 14:35:16 GMT

Weee!

I invented a new log file.

A cross between HP-UX and Linux called HPinux.

I meant /var/log/messages

Sorry about the error.

If you don't have the sar utilities installed on your system, get them at rpmfind.net and collect some data.

Might be interesting to run some vmstat information on the system.

If you are paging to disk, you might do what all good sysadmins do with Oracle resource issues. Throw memory at the problem.

Good Luck,

SEP

Re: Oracle process running out of OS Kernel I/O Resources

hp-unix — Thu, 01 Mar 2007 10:25:54 GMT

Hi ,

I am also facing the same warning mesg in alert log at the time of shutdown the DB.
/u01/app/oracle/product/10g/admin/miscd/udump/miscd1_ora_29923.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /u02/oracle10g2
System name: HP-UX
Node name: hpdev1
Release: B.11.23
Version: U
Machine: ia64
Instance name: miscd1
Redo thread mounted by this instance: 1
Oracle process number: 25
Unix process pid: 29923, image: oracle@hpdev1 (TNS V1-V3)

*** SERVICE NAME:(SYS$USERS) 2007-02-28 17:15:49.373
*** SESSION ID:(302.3) 2007-02-28 17:15:49.372
ksimdel: READY status 5
WARNING:Oracle process running out of OS kernel I/O resources
WARNING:Oracle process running out of OS kernel I/O resources
WARNING:Oracle process running out of OS kernel I/O resources
WARNING:Oracle process running out of OS kernel I/O resources
WARNING:Oracle process running out of OS kernel I/O resources
WARNING:Oracle process running out of OS kernel I/O resources
WARNING:Oracle process running out of OS kernel I/O resources
*** 2007-02-28 17:16:06.102
WARNING:Oracle process running out of OS kernel I/O resources
WARNING:Oracle process running out of OS kernel I/O resources
WARNING:Oracle process running out of OS kernel I/O resources
WARNING:Oracle process running out of OS kernel I/O resources
WARNING:Oracle process running out of OS kernel I/O resources
WARNING:Oracle process running out of OS kernel I/O resources
WARNING:Oracle process running out of OS kernel I/O resources
*** 2007-02-28 17:16:07.471 60639 kcrr.c
ARCH: Archival disabled due to shutdown: 1089
*** 2007-02-28 17:16:08.467 60639 kcrr.c
ARCH: Archival disabled due to shutdown: 1089
~
Pls reply asap.

thanks