disk corruption?
Hi all, I'm getting a disk error: ORA-01115: IO error reading block from file 9 (block # 262144) ORA-01110: data file 9: '/orafiles/data01/xlepmprd/ewlarge.dbf' ORA-27072: skgfdisp: I/O error SVR4 Error: 25: Inappropriate ioctl for device Additional information: 262143 My sysadmin tells me that the disk is ok, since there are no errors in /var/adm/messages (I didn't see any, either). Is there a way to verify that the disk is free of errors?? Any other log files to look at? The platform is Sun: SunOS msubxm01 5.6 Generic_105181-12 sun4u sparc SUNW,Ultra-4 Thanks! Jerry _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jerry C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: disk corruption?
controller hiccup? ( guess not if it's repeatable...is it? ) what is cache policy on your controllers? -Original Message- Sent: Thursday, June 28, 2001 12:23 PM To: Multiple recipients of list ORACLE-L Hi all, I'm getting a disk error: ORA-01115: IO error reading block from file 9 (block # 262144) ORA-01110: data file 9: '/orafiles/data01/xlepmprd/ewlarge.dbf' ORA-27072: skgfdisp: I/O error SVR4 Error: 25: Inappropriate ioctl for device Additional information: 262143 My sysadmin tells me that the disk is ok, since there are no errors in /var/adm/messages (I didn't see any, either). Is there a way to verify that the disk is free of errors?? Any other log files to look at? The platform is Sun: SunOS msubxm01 5.6 Generic_105181-12 sun4u sparc SUNW,Ultra-4 Thanks! Jerry _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jerry C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: disk corruption?
Hi Riyaj, Thanks for the info. This db is on: Oracle8 Enterprise Edition Release 8.0.5.1.0 - Production - Jerry - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, June 28, 2001 1:46 PM Subject: Re: disk corruption? Hi Jerry block # 262144 is the last block in a 2GB file assuming 8k block size. There are few Oracle bugs associated with this..Refer docid 110573.1. Also, refer bugs 1063586 or 1152315. It is to do with files beyond 2GB. Also What version of Oracle you are running ? Also you may want to truss Oracle shadow process and see what call is failing.. ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle DBAi2 technologies www.i2.com "Jerry C" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/28/01 11:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:disk corruption?Hi all,I'm getting a disk error:ORA-01115: IO error reading block from file 9 (block # 262144)ORA-01110: data file 9: '/orafiles/data01/xlepmprd/ewlarge.dbf'ORA-27072: skgfdisp: I/O errorSVR4 Error: 25: Inappropriate ioctl for deviceAdditional information: 262143My sysadmin tells me that the disk is ok, since there are no errors in/var/adm/messages (I didn't see any, either). Is there a way to verify thatthe disk is free of errors?? Any other log files to look at? The platform isSun:SunOS msubxm01 5.6 Generic_105181-12 sun4u sparc SUNW,Ultra-4Thanks!Jerry_Do You Yahoo!?Get your free @yahoo.com address at http://mail.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Jerry CINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: disk corruption?
Jerry, If you're on 8.0.x and file 9 is 2GB then it's a known bug (774252) when a read crosses the 2GB boundary. The datafile is not corrupt, Oracle is merely unable to read it properly. It wasn't fixed in any of the patchsets, but there are PSE's (patchset exceptions) for most 8.0.x versions. Log a tar with support to get the right one for your specific RDBMS version. HTH, -- Anita --- Jerry C [EMAIL PROTECTED] wrote: Hi all, I'm getting a disk error: ORA-01115: IO error reading block from file 9 (block # 262144) ORA-01110: data file 9: '/orafiles/data01/xlepmprd/ewlarge.dbf' ORA-27072: skgfdisp: I/O error SVR4 Error: 25: Inappropriate ioctl for device Additional information: 262143 My sysadmin tells me that the disk is ok, since there are no errors in /var/adm/messages (I didn't see any, either). Is there a way to verify that the disk is free of errors?? Any other log files to look at? The platform is Sun: SunOS msubxm01 5.6 Generic_105181-12 sun4u sparc SUNW,Ultra-4 Thanks! Jerry _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jerry C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: disk corruption?
Jerry, We had this problem recently on Solaris 2.6 and Oracle 8.0.5, Oracle initially said upgrade to the 8.0.5.2 patch will fix the problem, we ended up upgraded to the 8.0.6.2 to get rid of the problem. Anita is right about the datafile is still intact, it just a read error, you can run dbv to verify it. KC -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Friday, June 29, 2001 8:30 AM Jerry, If you're on 8.0.x and file 9 is 2GB then it's a known bug (774252) when a read crosses the 2GB boundary. The datafile is not corrupt, Oracle is merely unable to read it properly. It wasn't fixed in any of the patchsets, but there are PSE's (patchset exceptions) for most 8.0.x versions. Log a tar with support to get the right one for your specific RDBMS version. HTH, -- Anita --- Jerry C [EMAIL PROTECTED] wrote: Hi all, I'm getting a disk error: ORA-01115: IO error reading block from file 9 (block # 262144) ORA-01110: data file 9: '/orafiles/data01/xlepmprd/ewlarge.dbf' ORA-27072: skgfdisp: I/O error SVR4 Error: 25: Inappropriate ioctl for device Additional information: 262143 My sysadmin tells me that the disk is ok, since there are no errors in /var/adm/messages (I didn't see any, either). Is there a way to verify that the disk is free of errors?? Any other log files to look at? The platform is Sun: SunOS msubxm01 5.6 Generic_105181-12 sun4u sparc SUNW,Ultra-4 Thanks! Jerry _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jerry C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KC INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).