Oracle Raw devices

[nyck]

I have allocated a whole load of LUNS from our SAN to a Solaris9 server to be used a raw devices for an oracle9.2.0.7 server. One of my users is attempting to create a tablespace on the raw device and its failing with the following error:-

SQL> create tablespace ARBOR_TEMP datafile '/ora2/oradata/CLTT1_C1/arbor_temp.dbf' size 500M reuse;
create tablespace ARBOR_TEMP datafile '/ora2/oradata/CLTT1_C1/arbor_temp.dbf' size 500M reuse
*
ERROR at line 1:
ORA-01119: error in creating database file
'/ora2/oradata/CLTT1_C1/arbor_temp.dbf'
ORA-27041: unable to open file
SVR4 Error: 5: I/O error
Additional information: 1

Can someone tell me what he is doing wrong?

 

[LKBrwnDBA]

Raw devices are not available directly from the OS, you need Oracle ASM (Automated Storage Manager) to use the raw devices (but I'm not sure it's available for 9i).



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[DrD123]

Hi nyck,


You can use w/o ASM. SAW space has been in use far back in Oracle 7.x and maybe even before.

Create Tablespace works differently for RAW than cooked spaces. You need to define the device name for the LUNs you created, as opposed to a file in a directory. You might also be able to create a link from the device to a file in the directory, then you can use the filename.

Also the permissions for the block devices need to be oraclesdba

So look in /dev for the LUN's you created. If you want, post the listing of ls -lrt /dev which only shows the LUN's.


Good Luck
DrD

 

[nyck]

Below is an example of one of the EMC powerpath devices we are trying to use:-

pwd
/dev/rdsk
# ls -lrt emcpower5a
lrwxrwxrwx 1 oracle dba 33 Oct 3 14:08 emcpower5a -> ../../devices/pseudo/emcp@5:a,raw
# ls -lrt ../../devices/pseudo/emcp@5:a,raw
crw-rw-rw- 1 oracle dba 282, 40 Oct 3 14:08 ../../devices/pseudo/emcp@5:a,raw

 

[DrD123]

Hi nyck,

Give your create tablespace a try using:

'/dev/rdsk/emcpower5a' instead of '/ora2/oradata/CLTT1_C1/arbor_temp.dbf'

The permissions appear correct, so things should be OK.

Good Luck
DrD