Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00603: ORACLE server session terminated by fatal error

user3636719Oct 5 2011 — edited Oct 5 2011
I am getting below error,
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for HPUX: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production

SQL> create index idx_index5 on user.newtable1 (column1) tablespace tablespace_index_01;
create index idx_index5 on user.newtable1 (column1) tablespace tablespace_index_01;                                          *
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error


SQL> exit
According to suggestion that I got from all great blogs, I saw log file, below is my log file
ORA-01114: IO error writing block to file 201 (block # 581129)
ORA-27072: File I/O error
HPUX-ia64 Error: 28: No space left on device
Additional information: 4
Additional information: 581129
Additional information: -1
ORA-01114: IO error writing block to file 201 (block # 581129)
ORA-27072: File I/O error
HPUX-ia64 Error: 28: No space left on device
Additional information: 4
Additional information: 581129
Additional information: -1
ORA-01114: IO error writing block to file 201 (block # 581129)
ORA-27072: File I/O error
HPUX-ia64 Error: 28: No space left on device
Additional information: 4
Additional information: 581129
Additional information: -1
ORA-01114: IO error writing block to file 201 (block # 581129)
ORA-27072: File I/O error
HPUX-ia64 Error: 28: No space left on device
Additional information: 4
Additional information: 581129
Additional information: -1
But, There is enough space allocated for tablespace_index_01 abut 55Gig, and table user.newtable1 is about 80Gig.

I am not sure why I am still getting No space left on device error.

Any suggestions greatly appreciated.
This post has been answered by mseberg on Oct 5 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2011
Added on Oct 5 2011
33 comments
30,905 views