Home » RDBMS Server » Server Administration » ORA-1115 error
ORA-1115 error [message #339368] Thu, 07 August 2008 06:45 Go to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi,

My database version is 9.2.0.8 and it's using raw filesystem.
For the last one week,I'm getting the following error in alert log,


Errors in file /u02/oracle/app/product/orahome/admin/testdb/bdump/testdb_smon_512324.trc
ORA-01115: IO error reading block from file 1 (block # 10057)
ORA-01110: data file 1: '/dev/rpsystem01'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
IBM AIX RISC System/6000 Error: 5: I/O error


I ran DBVERIFY utility on this file,it says that the file is fine,please look at the output of dbverify utility,

$ dbv file=/dev/rpsystem01 blocksize=8192

DBVERIFY: Release 9.2.0.8.0 - Production on Thu Aug 7 12:16:04 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE = /dev/rpsystem01


DBVERIFY - Verification complete

Total Pages Examined : 130944
Total Pages Processed (Data) : 42571
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 9294
Total Pages Failing (Index): 0
Total Pages Processed (Other): 11969
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 67110
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 2776196209960 (646.1647336744)


But the database is up and running fine without any issue,
please someone help me in resolving this error and the trace file (testdb_smon_512324.trc) is also not generated for me in bdump,please help me in fixnig this problem also.


Thanks...
Re: ORA-1115 error [message #339384 is a reply to message #339368] Thu, 07 August 2008 07:07 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

IBM AIX RISC System/6000 Error: 5: I/O error

There is no problem with oracle datafile, ask your system administrator to check Operating File system.

Re: ORA-1115 error [message #339391 is a reply to message #339368] Thu, 07 August 2008 07:26 Go to previous messageGo to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi Taj,

Thanks for your reply. May I know why the trace file (testdb_smon_512324.trc) was not generated for me in bdump?

Thanks..
Re: ORA-1115 error [message #339398 is a reply to message #339391] Thu, 07 August 2008 07:33 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe for the same reason there were io errors on datafile.

Regards
Michel
Previous Topic: PGA_TARGET
Next Topic: Archive log files
Goto Forum:
  


Current Time: Fri Dec 02 18:21:42 CST 2016

Total time taken to generate the page: 0.25800 seconds