Re: Raw usage in Solaris

From: Yong Huang <yong321_at_yahoo.com>
Date: 15 May 2002 07:06:34 -0700
Message-ID: <b3cb12d6.0205150606.6e0a1f69@posting.google.com>

Hi, Nuno,

Could you show your telnet window? You probably only changed the symbolic link ownership but didn't change the underlined device? Here's what I have on a toy database:

SQL> select * from dba_data_files;

FILE_NAME

---

   FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS
---------- ------------------------------ ---------- ----------

---

RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ----------

---

...
/dev/rdsk/tiny/rawtest01.dbf

         9 RAWTEST                          33751040       4120
AVAILABLE
           9 NO           0          0            0   33685504       

4112

9 rows selected.

SQL> !
$ ls -l /dev/rdsk/tiny/rawtest01.dbf
lrwxrwxrwx 1 oracle dba 18 Apr 26 16:59
/dev/rdsk/tiny/rawtest01.dbf -> /dev/rdsk/c0t1d0s4
$ ls -l /dev/rdsk/c0t1d0s4
lrwxrwxrwx 1 root root 55 Jan 9 11:51
/dev/rdsk/c0t1d0s4 ->

../../devices/sbus_at_1f,0/SUNW,fas_at_e,8800000/sd_at_1,0:e,raw $ ls -l /devices/sbus_at_1f,0/SUNW,fas_at_e,8800000/sd_at_1,0:e,raw crw-r----- 1 oracle dba 32, 12 Apr 30 08:55
/devices/sbus_at_1f,0/SUNW,fas_at_e,8800000/sd_at_1,0:e,raw

The actual device at /devices/sbus... should be owned by oracle.

Yong Huang
yong321_at_yahoo.com

To other folks: Steve Adams' newsletter is only sent to subscribers now. Subscription is free. At least I didn't pay for it, thanks to his generosity.

nsouto_at_optushome.com.au (Nuno Souto) wrote in message news:<dd5cc559.0205141939.2807127f_at_posting.google.com>...

> yong321_at_yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0205140906.1379e652_at_posting.google.com>...
> 
> > You don't need Veritas or SDS to use raw. In fact, if you do, that's
> > not called raw any more. To allow oracle to read from the raw device,
> > run chown oracle:dba [thedevice] as root.
> 
> Thanks.
> 
> That's what I thought.  So I went to /dev/rdsk and did that for the 
> "cxtydzsw" that I wanted to use.  It silently finished, but no change 
> whatsoever to the ownership when I checked with "ls -al".

Received on Wed May 15 2002 - 09:06:34 CDT