OraFAQ Forum: Server Administration » : ORA-00603: ORACLE server session terminated by fatal error

Home » RDBMS Server » Server Administration » : ORA-00603: ORACLE server session terminated by fatal error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

: ORA-00603: ORACLE server session terminated by fatal error [message #286796]

Mon, 10 December 2007 02:41

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.

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #286799 is a reply to message #286796]

Mon, 10 December 2007 02:45

Michel Cadot
Messages: 68643
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

mr.rajeshyadav
Messages: 48
Registered: November 2007

Member

Thanks,
where can i find OS error log.

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #286803 is a reply to message #286802]

Mon, 10 December 2007 02:54

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It depends on your OS.

Regards
Michel

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #286809 is a reply to message #286803]

Mon, 10 December 2007 03:02

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.

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #286815 is a reply to message #286809]

Mon, 10 December 2007 03:07

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Control Panel -> Administrative Tool -> Computer management -> Event viewer -> System

Regards
Michel

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #286821 is a reply to message #286815]

Mon, 10 December 2007 03:14

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.

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #286825 is a reply to message #286821]

Mon, 10 December 2007 03:17

Michel Cadot
Messages: 68643
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

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287030 is a reply to message #286796]

Mon, 10 December 2007 23:48

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.

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287068 is a reply to message #287030]

Tue, 11 December 2007 00:57

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Wow! You see that from the error, I'm really impressed.

Regards
Michel

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287073 is a reply to message #286796]

Tue, 11 December 2007 01:05

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?

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287077 is a reply to message #287073]

Tue, 11 December 2007 01:08

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.

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287083 is a reply to message #286796]

Tue, 11 December 2007 01:14

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?

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287084 is a reply to message #287073]

Tue, 11 December 2007 01:15

Michel Cadot
Messages: 68643
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

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287087 is a reply to message #286796]

Tue, 11 December 2007 01:21

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

Report message to a moderator

Re: : ORA-00603: ORACLE server session terminated by fatal error [message #287091 is a reply to message #287087]

Tue, 11 December 2007 01:25

Michel Cadot
Messages: 68643
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

Report message to a moderator

Previous Topic:	characterset UTF8 and WE8MSWIN1252
Next Topic:	ASM files and log location (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 06:18:15 CDT 2024