raw devices for oracle

[avik]

I hv bn configuring raw devices for oracle clusterware/asm. As needed by the dba, i have created the vg and lv. the steps executed are as follows.

mkdir /dev/vg_data1
mknod /dev/vg_data1/group c 64 0x090000
vgcreate /dev/vg_data1 /dev/dsk/c9t1d5
lvcreate -n /dev/vg_data1/lv_data1 vg_data1
lvextend -L 24560 /dev/vg_data1/lv_data1
chown oracle:dba /dev/vg_data1/lv_data1
chmod 660 /dev/vg_data1/lv_data1

and asked him to use the /dev/vg_data1/rlv_data1 path. now hes complaining that its not working. I was wondering am i missing anything for it to work?

[Hein van den Heuvel]

"complaining that its not working. "

How about giving an exact error message, or at the very least be specific about the operation attempted which is failing

> chown oracle:dba /dev/vg_data1/lv_data1
> chmod 660 /dev/vg_data1/lv_data1

Uh, should that not be done on the raw device /rlv_data...

Hein.

[avik]

yep, chown & chmod was done on raw device only.

there are infact two raw devices thro' vg_data1 and vg_data2 and hes trying to make a ASM diskgroup out of it. the error hes getting is ORA-15063 - "ASM discovered an insufficient number of disks for diskgroup "

[Hein van den Heuvel]

Was there an oracle init item for "ASM_DISKSTRING"?
It should be NULL or contain:
/dev/vg_data[12]/r*


May we assume the diskgroup was created 'normal redundancy' and with two 'failgroup's?

Be sure to have your DBA share the CREATE DISKGROUP command details with you (and us?).

The full error description can be found with '#oerr ora 15063' or online at:

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14219/e12700.htm#sthref41

"ORA-15063: ASM discovered an insufficient number of disks for diskgroup "string"
Cause: ASM was unable to find a sufficient number of disks belonging to the diskgroup to continue the operation.
Action: Check that the disks in the diskgroup are present and functioning, that the owner of the ORACLE binary has read/write permission to the disks, and that the ASM_DISKSTRING initialization parameter has been set correctly. Verify that ASM discovers the appropriate disks by querying V$ASM_DISK from the ASM instance."

Good luck,
Hein.

[JIJ_1]

Hi Avik,

What is the permission of /dev/vg_data1 directory ??. If this vg is exclusively used for oracle related filesystems you can change owner and group of this directory to oracle:dba.

Regards !
Jijeesh

[Steven E. Protter]

Shalom,

For raw devices, its necessary for the logical volume files to be owned by the oracle user and its group, which is normally dba.

SEP