topic Re: oracle 10g R2 ASM with mutipathing 11.31 in Operating System - HP-UX

oracle 10g R2 ASM with mutipathing 11.31

tom quach_1 — Sat, 21 Jun 2008 02:25:53 GMT

Dear all,

I am moving my RAC 10gR2 from PA-Risc 11.11 to Itanium 11.31 with native multi-pathing.
created 6 disks 30Gb each from EVA4400 for this server
in 11.31 the devices
itauxdev:[root]:[TWO_TASK=OCP]:/dev/rdisk
#ll
total 0
crw-r----- 1 bin sys 23 0x00000a Jun 18 10:27 disk11
crw-r----- 1 bin sys 23 0x00000b Jun 19 11:26 disk16
crw-r----- 1 bin sys 23 0x000000 May 6 12:37 disk4
crw-rw-r-- 1 oracle dba 23 0x00000c Jun 19 15:26 disk41
crw-rw-r-- 1 oracle dba 23 0x00000d Jun 19 15:26 disk42
crw-rw-r-- 1 oracle dba 23 0x00000e Jun 19 15:26 disk43
crw-rw-r-- 1 oracle dba 23 0x00000f Jun 19 15:26 disk44
crw-rw-r-- 1 oracle dba 23 0x000010 Jun 19 15:26 disk45
crw-rw-r-- 1 oracle dba 23 0x000011 Jun 19 15:26 disk46

chmod and chown 664 and oracle:dba
but on my ASM installation, Oracle could not detect the disks. However, if i went back to the old way using

itauxdev:[root]:[TWO_TASK=OCP]:/dev/rdsk
crw-rw-r-- 1 oracle dba 188 0x060300 Jun 20 20:22 c6t0d3
crw-rw-r-- 1 oracle dba 188 0x060400 Jun 20 20:22 c6t0d4
crw-rw-r-- 1 oracle dba 188 0x060500 Jun 20 20:22 c6t0d5
crw-rw-r-- 1 oracle dba 188 0x060600 Jun 20 20:22 c6t0d6
crw-rw-r-- 1 oracle dba 188 0x060700 Jun 20 20:22 c6t0d7
crw-rw-r-- 1 oracle dba 188 0x061000 Jun 20 20:22 c6t1d0
chmod and chown 664 and oracle:dba
and ASM installation would detect those disks just fine.
Would someone please correct me if i did someting wrong here or it was not the correct way to use the new disks /dev/rdisk/disk41 to 46

Thanks for your helps!
Tom

Re: oracle 10g R2 ASM with mutipathing 11.31

Duncan Edmonstone — Sat, 21 Jun 2008 06:30:02 GMT

Tom,

Did you change the ASM parameter ASM_DISKSTRING to point at the new disks. I'm guessing it defaults to /dev/rdsk.

Have you reviewed the whitepapers on best practices for the EVA with ASM available here:

http://h71028.www7.hp.com/enterprise/cache/324315-0-0-0-121.html#oracle

HTH

Duncan

Re: oracle 10g R2 ASM with mutipathing 11.31

kevin_m — Wed, 25 Jun 2008 16:44:27 GMT

You may want to create alternate device files using mksf and configuring Oracle to use those instead. Otherwise the permissions could get reset after a reboot. Plus using alternates allows a more descriptive name, such as /dev/oracle/asm/db1. In that case set ASM_DISKSTRING=/dev/oracle/asm/* and it should be able to detect them.

Kevin

Re: oracle 10g R2 ASM with mutipathing 11.31

tom quach_1 — Wed, 25 Jun 2008 21:00:03 GMT

Thank-you Duncan and kevin,

Duncan, i did change the location to /dev/rdisk
and chown to oracle:dba but it could not detected the disks.
Kevin, on linux, yes it would change permission
if i did not follow your instruction but it is fine on Unix. I've used it for the last 3 yrs.

i just wonder if anyone uses /dev/rdisk for ASM in Oracle 10g.

regards,
Tom

Re: oracle 10g R2 ASM with mutipathing 11.31

kevin_m — Thu, 26 Jun 2008 11:55:05 GMT

Check Oracle's reference to ASM and multipathing at http://www.oracle.com/technology/tech/linux/asmlib/multipath.html. It's geared for Linux but still applicable to HP-UX in some respects.

Kevin

Re: oracle 10g R2 ASM with mutipathing 11.31

kevin_m — Thu, 26 Jun 2008 13:05:13 GMT

Oops my original link didn't work. Try http://www.oracle.com/technology/tech/linux/asmlib/multipath.html instead.

Re: oracle 10g R2 ASM with mutipathing 11.31

tom quach_1 — Mon, 30 Jun 2008 23:09:45 GMT

Thanks Kevin_m for the link.

the Linux and HPUX 11.31 are quite different.

I would hope if anyone is using mutipathing with oracle ASM. Please give me a hint.

Regards,
Tom

Re: oracle 10g R2 ASM with mutipathing 11.31

李志远 — Sun, 10 Aug 2008 11:36:29 GMT

hi,I met the same environment.but my question is the disk in the two server displayed did not point to the same lun.
eg:
db1:
disk 139 64000/0xfa00/0x8 esdisk CLAIMED DEVICE online HP HSV210
0/0/4/1/0.0x50001fe1500f3ebd.0x4004000000000000
0/0/4/1/0.0x50001fe1500f3ebe.0x4004000000000000
0/0/4/1/0.0x50001fe1500f3eb8.0x4004000000000000
0/0/4/1/0.0x50001fe1500f3ebb.0x4004000000000000
0/0/6/1/0.0x50001fe1500f3ebc.0x4004000000000000
0/0/6/1/0.0x50001fe1500f3ebf.0x4004000000000000
0/0/6/1/0.0x50001fe1500f3eba.0x4004000000000000
0/0/6/1/0.0x50001fe1500f3eb9.0x4004000000000000
1/0/4/1/0.0x50001fe1500f3ebc.0x4004000000000000
1/0/4/1/0.0x50001fe1500f3ebf.0x4004000000000000
1/0/4/1/0.0x50001fe1500f3eba.0x4004000000000000
1/0/4/1/0.0x50001fe1500f3eb9.0x4004000000000000

db2:
disk 139 64000/0xfa00/0x8 esdisk CLAIMED DEVICE online HP HSV210
0/0/4/1/0.0x50001fe1500f3eb8.0x4001000000000000
0/0/4/1/0.0x50001fe1500f3ebb.0x4001000000000000
0/0/4/1/0.0x50001fe1500f3ebd.0x4001000000000000
0/0/4/1/0.0x50001fe1500f3ebe.0x4001000000000000
0/0/6/1/0.0x50001fe1500f3eba.0x4001000000000000
0/0/6/1/0.0x50001fe1500f3ebc.0x4001000000000000
0/0/6/1/0.0x50001fe1500f3eb9.0x4001000000000000
0/0/6/1/0.0x50001fe1500f3ebf.0x4001000000000000
1/0/4/1/0.0x50001fe1500f3eb8.0x4001000000000000
1/0/4/1/0.0x50001fe1500f3ebb.0x4001000000000000
1/0/4/1/0.0x50001fe1500f3ebd.0x4001000000000000
1/0/4/1/0.0x50001fe1500f3ebe.0x4001000000000000

I think I should use mksf to build the new device file...

Re: oracle 10g R2 ASM with mutipathing 11.31

tom quach_1 — Mon, 11 Aug 2008 14:48:04 GMT

---> hi,I met the same environment.but my question is the disk in the two server displayed did not point to the same lun.

it should point to the same LUN but the device file may be different. in this case use mknod to create a new device file for both nodes.
Hope this help!

Re: oracle 10g R2 ASM with mutipathing 11.31

Oviwan — Mon, 11 Aug 2008 15:57:08 GMT

hey

does it work now?

if you have upgraded to 10.2.0.3 check this bug on metalink: 433770.1

and also check this thread:
http://forums.oracle.com/forums/thread.jspa?threadID=681657&tstart=0

Regards