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 JANUARY 07, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.5 to 11.2.0.3 [Release 10.1 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata 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
Oracle Solaris on SPARC (64-bit)
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
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
| Symptoms |
| Cause |
| Solution |