IO errors on Linux x86_64 2006-06-08 - By Jared Still
Dear List:
I've run into some interesting errors this week.
First, some background:
OS: RH EL4 Linux 2.6.9-22.ELsmp #1 SMP Mon Sep 19 18:00:54 EDT 2005 x86_64
x86_64 x86_64 GNU/Linux
Oracle: 9.2.0.7 64 Bit
HW: Dell 1850 - Dual multicore Pentium ( or whatever the correct chip name
is)
Mem: 8 Gig
Storage: Dell Clariion CX700 SAN
This particular server has several databases on it already that
are working without problem.
The default for filesystemio_options is 'none'.
After the databases have been created and app data imported, I've
changed filesystemio_options = directIO.
No particular reason for doing it later, other than I didn't add it to the
init.ora
when the database was built.
A new database was created this week for another app.
(Yes, it requires another database. Don't get sidetracked :)
In the course of doing some test imports, I turned on directIO.
With directIO on, the following error would occur about halfway throught the
import:
Errors in file /u01/app/oracle//admin/pr09/bdump/pr09_ckpt_29193.trc:
ORA-01171 (See ORA-01171.ora-code.com): datafile 12 going offline due to error advancing checkpoint
ORA-01110 (See ORA-01110.ora-code.com): data file 12: '/u01/oradata/pr09/agile_indx101pr09.ora'
ORA-01115 (See ORA-01115.ora-code.com): IO error reading block from file 12 (block # 1)
ORA-27072 (See ORA-27072.ora-code.com): skgfdisp: I/O error
Linux-x86_64 Error: 5: Input/output error
I've tested this a few times.
Three times with directIO enabled, there were IO errors.
One time with directIO enabled, the export succeeded.
The import has never failed with directIO disabled.
According to everything I can find on MetaLink, there are no
patches required for directIO with this platform and version of Linux.
Just in case this *is* a SW problem, directIO has been turned off
on other databases, though no other db has exhibited this problem.
Has anyone seen a similar problem?
Or maybe someone here will recognize that error as definitely
being HW related? (Matthew Z or Kevin C?)
Our SA has opened a ticket with EMC on this, but nothing yet...
Thanks,
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Dear List:<br><br>I've run into some interesting errors this week.<br><br>First
, some background:<br><br>OS: RH EL4 Linux 2.6.9-22.ELsmp #1 SMP Mon Sep
19 18:00:54 EDT 2005 x86_64 x86_64 x86_64 GNU/Linux<br>Oracle: <a href="http:/
/9.2.0.7">
9.2.0.7</a> 64 Bit<br>HW: Dell 1850 - Dual multicore Pentium ( or
whatever the correct chip name is)<br>Mem: 8 Gig<br>Storage: Dell
Clariion CX700 SAN<br><br>This particular server has several databases on it
already that
<br>are working without problem.<br><br>The default for filesystemio_options is
'none'.<br><br>After the databases have been created and app data imported, I
've <br>changed filesystemio_options = directIO.<br><br>No particular reason for
doing it later, other than I didn't add it to the
init.ora <br>when the database was built.<br><br>A new database was created
this week for another app.<br>(Yes, it requires another database. Don't get
sidetracked :)<br><br>In the course of doing some test imports, I turned on
directIO.
<br><br>With directIO on, the following error would occur about halfway
throught the import:<br><br><div style="margin-left: 40px;">Errors in file /u01
/app/oracle//admin/pr09/bdump/pr09_ckpt_29193.trc:<br>ORA-01171 (See ORA-01171.ora-code.com): datafile 12
going offline due to error advancing checkpoint
<br>ORA-01110 (See ORA-01110.ora-code.com): data file 12: '/u01/oradata/pr09/agile_indx101pr09.ora'<br>ORA
-01115: IO error reading block from file 12 (block # 1)<br>ORA-27072 (See ORA-27072.ora-code.com): skgfdisp:
I/O error<br>Linux-x86_64 Error: 5: Input/output error<br></div>
<br>I've tested this a few times. <br><br>Three times with directIO
enabled, there were IO errors.<br>One time with directIO enabled, the export
succeeded.<br><br>The import has never failed with directIO disabled.<br><br>
According to everything I can find on MetaLink, there are no<br>patches
required for directIO with this platform and version of Linux.<br><br>Just in
case this *is* a SW problem, directIO has been turned off<br>on other databases
, though no other db has exhibited this problem.
<br><br>Has anyone seen a similar problem?<br><br>Or maybe someone here will
recognize that error as definitely <br>being HW related? (Matthew Z or
Kevin C?)<br><br>Our SA has opened a ticket with EMC on this, but nothing yet..
.
<br><br>Thanks,<br><br>-- <br>Jared Still<br>Certifiable Oracle DBA and Part
Time Perl Evangelist<br>
<br>
|
|
