>>>>> "3" == 3 <trzeci_at_tiger.com.pl> writes:
3> Felix Rauch wrote:
>> it seems I can't get Oracle to work with raw devices on Linux and
>> would appreciate any help.
>>
>> I installed Oracle with raw device support, but generated all the
>> system tables in regular files in the file system (I thought
>> mixing regular files and raw devices for different table spaces
>> should be possible and seemed easier to set up). Then I bound
>> /dev/raw5 to /dev/sdb9, but when I try to create a tablespace on
>> the raw device I get:
>>
SVRMGR> create tablespace "DATA" datafile '/dev/raw5';
>> create tablespace "DATA" datafile '/dev/raw5' * ORA-01119: error
>> in creating database file '/dev/raw5' ORA-27059: skgfrsz: could
>> not reduce file size Additional information: 2
>>
>> The use of "reuse" doesn't seem to help:
>>
SVRMGR> create tablespace "DATA" datafile '/dev/raw5' reuse;
>> create tablespace "DATA" datafile '/dev/raw5' reuse * ORA-01119:
>> error in creating database file '/dev/raw5' ORA-27059: skgfrsz:
>> could not reduce file size Additional information: 2
>>
>> Any hints on what I should do to get it running or what Oracle
>> actually requires from the raw device to work?
>>
>> My environment ist: - SuSE Linux 6.0 (I know this is old, but I
>> have to use this version for a performance comparison of a
>> colleagues work) - Oracle8 Release 8.0.5.0.0 - Production (At
>> least that's what svrmgrl prints on startup.) - Linux kernel
>> 2.4.3 (I also tried 2.4.18)
>>
>> My Background: I'm not a database expert, but I'm doing research
>> on distributed file systems.
>>
>> Regards, Felix
>>
3> Try to create tablespace on a regular file, next dd this file
3> (database must be stopped) onto a raw device. Replace the file
3> with symbolic link to the raw device. I am using this method on
3> kernel 2.4.20 and it works fine.
Just FYI, I think there was a thread here a few weeks ago where
someone posted some results form doing some test comparing raw device
with ext2 and the results indicated ext2 was actually faster than
using a raw device. the thread should be locatable via google.
Tim
--
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you
really need to send mail, you should be able to work it out!
Received on Fri Mar 07 2003 - 03:03:41 CST
