Database Startup, Shutdown Or New Connections Hang With Truss Showing OS Failing Semtimedop Call With Err#11 EAGAIN (Doc ID 760968.1)

Last updated on JULY 21, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.5 to 11.2.0.3 [Release 10.1 to 11.2]
Oracle Solaris on SPARC (64-bit)
***Checked for relevance on 21-Jul-2017***

Symptoms

Database startup hangs indefinitely with last lines of alert log showing the following.

Wed Jan 7 09:13:39 2009
alter database open
Wed Jan 7 09:13:39 2009
Beginning crash recovery of 1 threads

Or database shutdown hangs indefinitely with last lines of alert log showing the following.

WARNING: aiowait timed out
WARNING: aiowait timed out
WARNING: aiowait timed out

Another symptom have seen is that new connections to the database can hang, including sysdba.

C:\oracle\ora10\BIN>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jan 13 16:04:35 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved

When truss ( truss -o connect.out -f sqlplus / as sysdba ) the startup or shutdown, or truss the SQL*Plus connection, they all will show spinning on the same semtimedop command.

8934: semtimedop(123, 0xFFFFFFFF7FFFE05C, 1, 0xFFFFFFFF7FFFE048) Err#11 EAGAIN
8906: semtimedop(123, 0xFFFFFFFF7FFFE05C, 1, 0xFFFFFFFF7FFFE048) (sleeping...)
8916/1: semtimedop(123, 0xFFFFFFFF7FFFE05C, 1, 0xFFFFFFFF7FFFE048) (sleeping...)
8912: semtimedop(123, 0xFFFFFFFF7FFFE05C, 1, 0xFFFFFFFF7FFFE048) (sleeping...)
8896: pollsys(0x103536A18, 2, 0xFFFFFFFF7FFFD390, 0x00000000) (sleeping...)
8920/1: semtimedop(123, 0xFFFFFFFF7FFFE05C, 1, 0xFFFFFFFF7FFFE048) (sleeping...)
8920/7: lwp_park(0x00000000, 0) (sleeping...)
8920/10: lwp_park(0x00000000, 0) (sleeping...)
8920/9: lwp_park(0x00000000, 0) (sleeping...)
8934: semtimedop(123, 0xFFFFFFFF7FFFE05C, 1, 0xFFFFFFFF7FFFE048) (sleeping...)
8900/1: semtimedop(123, 0xFFFFFFFF7FFFE05C, 1, 0xFFFFFFFF7FFFE048) Err#11 EAGAIN
8906: semtimedop(123, 0xFFFFFFFF7FFFE05C, 1, 0xFFFFFFFF7FFFE048) Err#11 EAGAIN
8916/1: semtimedop(123, 0xFFFFFFFF7FFFE05C, 1, 0xFFFFFFFF7FFFE048) Err#11 EAGAIN
8912: semtimedop(123, 0xFFFFFFFF7FFFE05C, 1, 0xFFFFFFFF7FFFE048) Err#11 EAGAIN
8896: pollsys(0x103536A18, 2, 0xFFFFFFFF7FFFD390, 0x00000000) = 0
8896: kill(8896, SIG#0) = 0
8896: open("/proc/8896/psinfo", O_RDONLY) = 17

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms