Home » RDBMS Server » Server Administration » : ORA-00603: ORACLE server session terminated by fatal error
: ORA-00603: ORACLE server session terminated by fatal error [message #286796] Mon, 10 December 2007 02:41 Go to next message
mr.rajeshyadav
Messages: 48
Registered: November 2007
Member
Hi,

can any body tell me why this error will come

ORA-00603: ORACLE server session terminated by fatal error
ORA-01114: IO error writing block to file 201 (block # 94218)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed. (OS 94249)
ORA-01114: IO error writing block to file 201 (block # 94218)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed. (OS 94249)
ORA-01114: IO error writing block to file 201 (block # 94218)
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed. (OS 94249)

Thanks,
Rajesh.
Re: : ORA-00603: ORACLE server session terminated by fatal error [message #286799 is a reply to message #286796] Mon, 10 December 2007 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
because of:
Quote:

IO error writing block to file 201

Check file system space, file size (compare to max possible), OS io error log...

Regards
Michel

[Updated on: Mon, 10 December 2007 02:46]

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #286802 is a reply to message #286799] Mon, 10 December 2007 02:53 Go to previous messageGo to next message
mr.rajeshyadav
Messages: 48
Registered: November 2007
Member
Thanks,
where can i find OS error log.
Re: : ORA-00603: ORACLE server session terminated by fatal error [message #286803 is a reply to message #286802] Mon, 10 December 2007 02:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on your OS.

Regards
Michel
Re: : ORA-00603: ORACLE server session terminated by fatal error [message #286809 is a reply to message #286803] Mon, 10 December 2007 03:02 Go to previous messageGo to next message
mr.rajeshyadav
Messages: 48
Registered: November 2007
Member
Thanks for your response,
These are the versions of oracle and OS
Oracle9.2.0.1.0 - Production,Windows XP.

Thanks,
Rajesh.
Re: : ORA-00603: ORACLE server session terminated by fatal error [message #286815 is a reply to message #286809] Mon, 10 December 2007 03:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Control Panel -> Administrative Tool -> Computer management -> Event viewer -> System

Regards
Michel
Re: : ORA-00603: ORACLE server session terminated by fatal error [message #286821 is a reply to message #286815] Mon, 10 December 2007 03:14 Go to previous messageGo to next message
mr.rajeshyadav
Messages: 48
Registered: November 2007
Member
Hi,
I have cleared all the events present there still it is giving the same error.

Thanks in Advance,
Rajesh.
Re: : ORA-00603: ORACLE server session terminated by fatal error [message #286825 is a reply to message #286821] Mon, 10 December 2007 03:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Event log is just a log, clearing it is useless, you have to see in the messages why there is an error (if any is logged).

Regards
Michel
Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287030 is a reply to message #286796] Mon, 10 December 2007 23:48 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Increase the size of the datafile or add a new datafile to the tablespace.
It seems you are out of disk space.
Move your tablespace to another location.
Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287068 is a reply to message #287030] Tue, 11 December 2007 00:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Wow! You see that from the error, I'm really impressed.

Regards
Michel
Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287073 is a reply to message #286796] Tue, 11 December 2007 01:05 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:

ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file

What else could be the reason?
Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287077 is a reply to message #287073] Tue, 11 December 2007 01:08 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

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

I don't think it is related to out of disk space.
Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287083 is a reply to message #286796] Tue, 11 December 2007 01:14 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
What does the statement "outside the range of file" signify?
Isn't it talking about the space range of the datafile?
Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287084 is a reply to message #287073] Tue, 11 December 2007 01:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also file size OS limit, file size hardware limit, user file size limit, hardware failure, driver error, virus, anti-virus....

Regards
Michel
Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287087 is a reply to message #286796] Tue, 11 December 2007 01:21 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:

Also file size OS limit, file size hardware limit, user file size limit

So it could be an space issue as well.
The datafile might have been autoextended to the OS limit
Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287091 is a reply to message #287087] Tue, 11 December 2007 01:25 Go to previous message
Michel Cadot
Messages: 64124
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It could be but you said "It seems you are out of disk space" but it does not seem that, not at all.

Regards
Michel
Previous Topic: characterset UTF8 and WE8MSWIN1252
Next Topic: ASM files and log location (merged)
Goto Forum:
  


Current Time: Wed Dec 07 06:40:55 CST 2016

Total time taken to generate the page: 0.09059 seconds