Home » RDBMS Server » Server Administration » Oracle erros-please help! (ORacle 9i WindowsXP)
Oracle erros-please help! [message #354299] Fri, 17 October 2008 08:49 Go to next message
aviana
Messages: 106
Registered: July 2007
Senior Member
Hi,
When I am executing a few sql scripts I am getting the following errors..But when executing a different ones, I am not getting any error..
I have searched the net and a few sites say I have to drop and re create the tempfiles in my temporary tablespace(There are 2 tempfiles and both are showing 98 and 99% full)..
Please let me know what is the solution for this?
Please let me know if I should post the sql scripts as well.

Posting errors below:-
Quote:


ERROR at line 14:
ORA-01114: IO error writing block to file 202 (block # 507785)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed. (OS 507799)
ORA-01114: IO error writing block to file 202 (block # 507785)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed. (OS 507799)


Report message to a moderator

Re: Oracle erros-please help! [message #354300 is a reply to message #354299] Fri, 17 October 2008 08:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
 
ORA-27069: attempt to do I/O beyond the range of the file
 *Cause:  internal error, the range of blocks being read or written is
          outside the range of the file, additional information indicates
          the starting block number, number of blocks in I/O, and the
          last valid block in the file
 *Action: check for trace file and contact Oracle Support

Regards
Michel

Report message to a moderator

Re: Oracle erros-please help! [message #354301 is a reply to message #354300] Fri, 17 October 2008 08:56 Go to previous messageGo to next message
aviana
Messages: 106
Registered: July 2007
Senior Member
Hi I have seen this answer in other sites too..ie, to contact oracle support!
Is this the only solution?Is there anything else I can do?
Why this error is appearing sometimes ?
What is the basic cause?
Also check for trace file means the alert log??It doesnt specify anything about this error!

[Updated on: Fri, 17 October 2008 09:00]

Report message to a moderator

Re: Oracle erros-please help! [message #354309 is a reply to message #354301] Fri, 17 October 2008 09:54 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:

What is the basic cause?



The basic cause is that you have corrupted datafiles. The datafiles are damaged.

That could be an hardware problem, an OS Bug or an Oracle bug.

Which can realistically only be resolved by Oracle support.

One other option could be to revert to a backup which is known to be good.

Report message to a moderator

Re: Oracle erros-please help! [message #354568 is a reply to message #354309] Mon, 20 October 2008 06:04 Go to previous messageGo to next message
aviana
Messages: 106
Registered: July 2007
Senior Member
But the file number specified in the error(file 202) does not correspond to any datafile number
I checked the dba_datafiles and dba_tempfiles as well.
When I bounced the database, this error now does not appear..did not do any other changes
Any thoughts?

Report message to a moderator

Re: Oracle erros-please help! [message #354802 is a reply to message #354568] Tue, 21 October 2008 06:10 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
But you also need to contact oracle support if it is a production box. but it might be some BUG with OS relate.

Report message to a moderator

Previous Topic: log_archive_format
Next Topic: SYSAUX
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 21:24:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.