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

Home » RDBMS Server » Server Administration » while creating the index ORA-00603: ORACLE server session terminated by fatal error (oracle 9i, aix5.2)

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

while creating the index ORA-00603: ORACLE server session terminated by fatal error [message #467721]

Mon, 26 July 2010 23:34

soft_doctor
Messages: 33
Registered: May 2010

Member

Hi All,

While creating the index we are getting the error
"ORA-00603: ORACLE server session terminated by fatal error".

We have the space in tablespaces and also in the file systesm.
Please suggest.

Regards,
Chandu.

Report message to a moderator

Re: while creating the index ORA-00603: ORACLE server session terminated by fatal error [message #467722 is a reply to message #467721]

Mon, 26 July 2010 23:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Please suggest.
Upgrade to an Oracle version supported in the 21st century

Report message to a moderator

Re: while creating the index ORA-00603: ORACLE server session terminated by fatal error [message #467725 is a reply to message #467722]

Mon, 26 July 2010 23:50

soft_doctor
Messages: 33
Registered: May 2010

Member

From 2 years, we are maintaining this database. We did not get this error till now.
Can i expect any alternative solution?

Report message to a moderator

Re: while creating the index ORA-00603: ORACLE server session terminated by fatal error [message #467726 is a reply to message #467725]

Mon, 26 July 2010 23:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

00603, 00000, "ORACLE server session terminated by fatal error"
// *Cause: An ORACLE server session was in an unrecoverable state.
// *Action: Login to ORACLE again so a new server session will be created

any additional clues in alert_SID.log file?

Report message to a moderator

Re: while creating the index ORA-00603: ORACLE server session terminated by fatal error [message #467728 is a reply to message #467721]

Tue, 27 July 2010 00:00

soft_doctor
Messages: 33
Registered: May 2010

Member

Errors in file /home/oracle/admin/atca57/udump/atca57_ora_60298.trc:
ORA-01114: IO error writing block to file 1023 (block # 40771)
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 102400
ORA-01114: IO error writing block to file 1023 (block # 40771)
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 102400
ORA-01114: IO error writing block to file 1023 (block # 40771)
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 102400
ORA-01114: IO error writing block to file 1023 (block # 40746)
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 102400

Report message to a moderator

Re: while creating the index ORA-00603: ORACLE server session terminated by fatal error [message #467730 is a reply to message #467728]

Tue, 27 July 2010 00:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>IBM AIX RISC System/6000 Error: 28: No space left on device

disk is full

Report message to a moderator

Re: while creating the index ORA-00603: ORACLE server session terminated by fatal error [message #467745 is a reply to message #467730]

Tue, 27 July 2010 01:35

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

SO Add new disk or free same space

Report message to a moderator

Re: while creating the index ORA-00603: ORACLE server session terminated by fatal error [message #467748 is a reply to message #467721]

Tue, 27 July 2010 01:42

soft_doctor
Messages: 33
Registered: May 2010

Member

We have the sufficient space in all the tablespaces. Can you
kindly let me know exact issue and solution in details. Thanks!

Report message to a moderator

Re: while creating the index ORA-00603: ORACLE server session terminated by fatal error [message #467755 is a reply to message #467748]

Tue, 27 July 2010 02:37

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

let me know exact issue and solution in details. Thanks!

The only thing we can say with what you posted is that "disk is full".

You think you have space enough but it seems Oracle tries to extend a file.

Regards
Michel

Report message to a moderator

Re: while creating the index ORA-00603: ORACLE server session terminated by fatal error [message #467766 is a reply to message #467755]

Tue, 27 July 2010 04:49

zouxiangdong
Messages: 3
Registered: July 2010

Junior Member

first you should add a new harddisk,then create a tablespace ,move the data to the new tablspace.

Report message to a moderator

Re: while creating the index ORA-00603: ORACLE server session terminated by fatal error [message #467804 is a reply to message #467766]

Tue, 27 July 2010 08:16

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

zouxiangdong wrote on Tue, 27 July 2010 05:49

first you should add a new harddisk,then create a tablespace ,move the data to the new tablspace.

Incorrect. Why should objects be moved to a new tablespace?

Report message to a moderator

Re: while creating the index ORA-00603: ORACLE server session terminated by fatal error [message #468619 is a reply to message #467804]

Sat, 31 July 2010 03:26

ashy
Messages: 2
Registered: July 2010

Junior Member

The device on which the file(IO error writing block to file 1023 (block # 40771))
resides is probably offline. If the file is a temporary file, then it is also possible that the device has run out of space.

Report message to a moderator

Re: while creating the index ORA-00603: ORACLE server session terminated by fatal error [message #468968 is a reply to message #468619]

Mon, 02 August 2010 13:07

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

ashy wrote on Sat, 31 July 2010 04:26

The device on which the file(IO error writing block to file 1023 (block # 40771))
resides is probably offline. If the file is a temporary file, then it is also possible that the device has run out of space.

Why do you insist on making new guesses when the obvious correct answer was already given; The disk is full. Period.

Report message to a moderator

Re: while creating the index ORA-00603: ORACLE server session terminated by fatal error [message #468990 is a reply to message #467748]

Mon, 02 August 2010 21:32

hkchital
Messages: 128
Registered: September 2008
Location: Singapore

Senior Member

The error for "file 1023" is on a TEMPORARY TABLESPACE tempfile.

So, check the tempfiles of your temporary tablespace(s). The filesystem holding one or more of the tempfiles was full and the tempfile(s) on that filesystem had attempted to autoextend.

Hemant K Chitale

Report message to a moderator

Previous Topic:	How to see the complete content of trigger_body in user_triggers
Next Topic:	how to delete files in incident folder?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 13:04:51 CST 2024