ORA-27091 ORA-27072 IO Error
744052Feb 12 2011 — edited Mar 22 2011Hi,
Presently I was in the activity of moving some large tables from one database to another on Oracle 9i (9.2.0.8.0) on AIX (5.3).
After the movement to the another database using the export and import, I am facing the the issue as shown below;
SQL> select count(*) from SSRDE.TXT_OLD;
select count(*) from SSRDE.TXT_OLD
*+
ERROR at line 1:
ORA-01115: IO error reading block from file 114 (block # 292873)
ORA-01110: data file 114: '/u02/oradata/exp_xx/indx/tt_data15.dbf'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error
As I am trying to access one of the large tables, an I/O error appears on the database where these have just been migrated.
I have been searching but there are no clear indicators on OS as to what is causing the issue and how to verify the above.
Thanks