| SVR4 Error: 11: Resource temporarily unavailable [message #258768] |
Mon, 13 August 2007 09:53  |
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 # 
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 #
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 #258788 is a reply to message #258772] |
Mon, 13 August 2007 10:21  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
