Home » RDBMS Server » Server Administration » SVR4 Error: 11: Resource temporarily unavailable
SVR4 Error: 11: Resource temporarily unavailable [message #258768] Mon, 13 August 2007 09:53 Go to next message
TLegend33
Messages: 203
Registered: March 2005
Senior Member
RHEL4 Oracle 10.2.0.2

I get the below message when I attempt a simple query on our members table:

SQL> select firstname, lastname from members where rownum < 25;
select firstname, lastname from members where rownum < 25
*
ERROR at line 1:
ORA-01115: IO error reading block from file 12 (block # Cool
ORA-01110: data file 12: '/d6/oradata/ESDEV/MEMBER/ES_DEV_mdata_01.dbf'
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
Additional information: 4
Additional information: 7
Additional information: 8192


Here is what is in the alert.log:

Errors in file /opt/oracle/admin/ESDEV/bdump/es_dev_j001_16434.trc:
ORA-12012: error on auto execute of job 16560
ORA-01115: IO error reading block from file ORA-01115: IO error reading block from file 12 (block # Cool
ORA-01110: data file 12: '/d6/oradata/ESDEV/MEMBER/ES_DEV_mdata_01.dbf'
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
SVR4 Error: 11: Resource temporarily unavailable
Additional information: 4
Additional information: 7
Additional information: 8192
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1488
ORA-06512: at "SYS.DBMS_SPACE", line 1554

I can perform:

SQL> select count(*) from members;

COUNT(*)
----------
15431

and get a valid response.

The disk is not full. Is this datafile corrupt? I've experienced corrupt datafiles before, but have not seen an error like this.
Thanks.

[Updated on: Mon, 13 August 2007 09:54]

Report message to a moderator

Re: SVR4 Error: 11: Resource temporarily unavailable [message #258772 is a reply to message #258768] Mon, 13 August 2007 10:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Anything related in /var/log/messages?
Run dbv against file.
Does dmesg report disk problems?
Re: SVR4 Error: 11: Resource temporarily unavailable [message #258788 is a reply to message #258772] Mon, 13 August 2007 10:21 Go to previous message
TLegend33
Messages: 203
Registered: March 2005
Senior Member
I checked in /var/log and could not find any related messages.


dbv file=ES_DEV_mdata_01.dbf blocksize=16384

DBVERIFY: Release 10.2.0.1.0 - Production on Mon Aug 13 11:10:53 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

DBVERIFY - Verification starting : FILE = ES_DEV_mdata_01.dbf


DBVERIFY - Verification complete

Total Pages Examined : 6
Total Pages Processed (Data) : 0
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 6
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 0
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 830596156 (2.830596156)


I also brought this to the attention of our SysAdmin and he found that the disk is question is critically close to failure. I'll have to recover this datafile to another location. Thanks for your help.
Previous Topic: Btree index
Next Topic: Standby database
Goto Forum:
  


Current Time: Tue Dec 03 07:53:14 CST 2024