Re: Possible Oracle Bug, Oracle Claims No

From: Chuckster <chuckycarson_at_networkcloud.com>
Date: Wed, 12 Mar 2003 08:27:02 -0800
Message-ID: <3E6F5FD6.5080905@networkcloud.com>

Norman Dunbar wrote:
> Hi Chuck,
>
>

>>>ORA-27063: skgfospo: number of bytes read/written is incorrect
>>>Additional information: 8192
>>

>
> As you were building indexes, I presume this was an 8K block write
> operation that Oracle requested. However, when the result of the write
> was returned, 8192 was not the answer Oracle got. It should have been.
> (It would be nice if the additional information told us what number
> Oracle got, and not what it expected - or even better, both !)
>
>
>

>>>The datafile in question is a 2GB datafile, however, when I looked at
>>

> the file within
>

>>>the OS, it displayed the file size as 400k.
>>

>
> Does Oracle still see it as 2Gb then? If so, then the file was 2 GB at
> creation time, or has been extended to 2GB at some point since creation.
> If the OS says that a file you and Oracle *know* is 2GB is actually 400
> Kb then you almost certainly have a disc problem.
>
> I'd have to agree that this is not an Oracle problem, more like Oracle
> finding a problem.
>
> Cheers,
> Norman.
>
> PS. I'm only a wannabe SA myself - I do Oracle better than Unix
> regardless of the sig my company makes me use :o)
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>

The problem ended up being the way an index rebuild was done, using a third party cartridge. I do not know the details yet because another DBA discovered this, but from what I understand, the index rebuild process clobbered the existing datafile with a new one, the new one being only 400k. Why Oracle would even allow this to occur I do not know. This involves a third party cartridge called Daylight that has become the bane of our existence since we purchased it.

It is a someware written by scientists, not software engineers, so of course it is crapola.

-Chuck

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Mar 12 2003 - 10:27:02 CST