While trying to import a dump, i got an error during "create index": IMP-00003: ORACLE error 1115 encountered ORA-01115: IO error reading block from file 23 (block # 47913) ORA-01110: data file 23: '/data/oracle/DEV/IS_D2C_02.DBF' ORA-27091: skgfqio: unable to queue I/O ORA-27072: skgfdisp: I/O error Linux Error: 11: Resource temporarily unavailable Additional information: 47897
Followed by
IMP-00003: ORACLE error 12801 encountered
ORA-12801: error signaled in parallel query server P002, instance racf0:DEV1 (1)
ORA-01115: IO error reading block from file 202 (block # 22129)
ORA-27072: skgfdisp: I/O error
Linux Error: 5: Input/output error
Additional information: 22129
No errors in alert.log only one trace file in bdump containing the last message. No errors found using dbverify.
The only way to reproduce this without using import was to use "create index" statement that contains "parallel (degree 6 instances 1)" on a table that has 2 partitions, each of them having 3 subpartitions.
Again, no errors in alert.log and no trace files.
Only error on screen:
ORA-12801: error signaled in parallel query server P001, instance racf1:DEV2 (2)
ORA-01115: IO error reading block from file 201 (block # 7352)
ORA-27072: skgfdisp: I/O error
Linux Error: 11: Resource temporarily unavailable
Additional information: 7352
Similar "create index" statement, only containing "parallel" with no degree and instances specified finished with no errors.
select * from v$pq_sesstat; revealed, that it was done with height=3 and width=2.
Could anyone explain me the cause of this error?
I am using RAC over NFSv3, 9.2.0.4, kernel 2.6.0-test6
thanks,
Bruno Vanters Junior Oracle DBA
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruno Vanters INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
