Re: Oracle and raw devices on Linux don't work :-(

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

-- 
Felix Rauch, research assistant at laboratory for computersystems, ETH Zuerich
http://www.nice.ch/~felix/    Member of Swiss Internet User Group: www.siug.ch
This article contains my personal view only! Use of my addresses for marketing
purposes is hereby strictly prohibited according to swiss privacy laws.