Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle and raw devices on Linux don't work :-(
Felix Rauch wrote:
> Alistair Thomson <alistair_at_despammed.com> wrote:
> > Don't you need to specify the size of the file? I think the maximum size
> > your file can be is one block less than the raw partition.
>
> It doesn't seem to matter what size I try. There is a specific limit
> where the error message changes, but it still doesn't work:
>
> localhost:~> cat /proc/partitions | grep sdb9
> 8 25 1028128 sdb9
>
> I get the following error for n up = 1028120..1028124 (I tried in 1K steps):
>
> SVRMGR> create tablespace "DATA" datafile '/dev/raw5' size nK;
> create tablespace "DATA" datafile '/dev/raw5' size nK
> *
> ORA-19504: failed to create file "/dev/raw5"
> ORA-27059: skgfrsz: could not reduce file size
> Additional information: 2
>
> But for n >= 1028125 I get the following error:
>
> SVRMGR> create tablespace "DATA" datafile '/dev/raw5' size nK;
> create tablespace "DATA" datafile '/dev/raw5' size nK
> *
> ORA-01119: error in creating database file '/dev/raw5'
> ORA-27042: skgfrcre: unable to seek to and write the last block
> Linux Error: 9: Bad file descriptor
>
> So it seems I can't specify the right size :-(
>
> Thanks for the hint anyway.
>
> - Felix
>
Hello Felix,
as far as I know there is 1MB overhead in using raw partitions.
Sepp
Received on Sun Mar 09 2003 - 06:11:24 CST