Tempfile weirdness

From: Stephen Lee <Stephen.Lee_at_DTAG.Com>
Date: Wed, 17 Sep 2003 13:54:44 -0800
Message-ID: <F001.005D0414.20030917135444@fatcity.com>

Any comments on the following??

When creating index, got
ORA-00603: ORACLE server session terminated by fatal error

apparently caused by

ksedmp: internal or fatal error
ORA-01114: IO error writing block to file 121 (block # 149) ORA-27063: skgfospo: number of bytes read/written is incorrect Additional information: 16384
Additional information: 49152

which I determined was caused by attempted write to temp tablespace using a tempfile. The tablespace was dropped and recreated, and all was well again.

What I think MIGHT have happened is the tablespace created weeks ago, but not used. So it didn't grab any actual storage. In the mean time, some of the storage might have been used by something else, but storage was released. Now tempfile goes to grab some space, but filesystem is all screwed up about what storage the tempfile should be grabbing.

Does this sound plausible?
Is there something else going on here?
Is this another one of those spiffy cool things in Oracle that are just something else to go wrong and make life a bitch?

Note that the index create blew up immediately, so the original tempfile never grabbed any space.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Stephen Lee
  INET: Stephen.Lee_at_DTAG.Com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Sep 17 2003 - 16:54:44 CDT