disk owner for oracle ASM changed to bin:sys

[yulianto piyut]

hi all,

last week i have a case that cause oracle ASM that using raw device down. The problem is owner for disk device that used by oracle ASM, the owner changed to bin:sys. Nobody changed these owner, no log at history file and syslog. anyone knows about it ? how come the owner of these device is changed?

-yut-

[Yogeeraj_1]

hi -yut-,

When did u notice the change?
was it after a restart?

revert

kind regards
yogeeraj

[yulianto piyut]

Server not restart before, before is happened, database and system is running normally.

[Yogeeraj_1]

hi,

Can you post more details?

1. Which device files are being used by ASM?

select name, path from v$asm_disk

e.g.
SQL> select name, path from v$asm_disk;

DG_DATA01_0000 /u01/oradata/asmdisks/r10vdisk01
DG_DATA01_0001 /u01/oradata/asmdisks/r10vdisk02

Elapsed: 00:00:00.06
SQL>


2. File details

ll

e.g.
[server ~]$ ll /u01/oradata/asmdisks/
total 8
lrwxrwxrwx 1 root root 8 Aug 22 2007 r10vdisk01 -> /dev/sdc
lrwxrwxrwx 1 root root 8 Aug 22 2007 r10vdisk02 -> /dev/sdd
[server ~]$

and
[server ~]$ ll /dev/sdc
brw-rw---- 1 oracle oinstall 8, 32 Feb 5 07:21 /dev/sdc
[server ~]$ ll /dev/sdd
brw-rw---- 1 oracle oinstall 8, 48 Feb 5 07:21 /dev/sdd
[server ~]$

revert.

kind regards
yogeeraj

[yulianto piyut]

hi,

belows are all disk that used by ASM. ONLY device c10t2d3 & c10t2d4 that changed to bin:sys.

eaipdb3:/dev/rdsk>ls -lrt |grep oracle
crw-r----- 1 oracle dba 188 0x0a0500 Mar 17 13:54 c10t0d5
crw-r----- 1 oracle dba 188 0x0a2300 Mar 17 13:54 c10t2d3
crw-r----- 1 oracle dba 188 0x0a0000 Mar 17 13:54 c10t0d0
crw-r----- 1 oracle dba 188 0x060200 Mar 17 13:54 c6t0d2
crw-r----- 1 oracle dba 188 0x080300 Mar 17 13:54 c8t0d3
crw-r----- 1 oracle dba 188 0x080100 Mar 17 13:54 c8t0d1
crw-r----- 1 oracle dba 188 0x0a2400 Mar 17 13:54 c10t2d4
crw-r----- 1 oracle dba 188 0x0c2200 Mar 17 13:54 c12t2d2

[Yogeeraj_1]

hi again,

do you have any error messages reported in the syslog.log?

have you already rechanged the file ownership to the Oracle user?


revert

kind regards
yogeeraj

[yulianto piyut]

1. no log at syslog related to
2. of course, these servers are production and i have changed the owner of disks.

do you have any clue for this case ?

[Oviwan]

hey

maybe a sys admin executed "insf -e" this reinstalls the special files etc...

regards

[Duncan Edmonstone]

Hi,

This can happen when someone runs an 'insf -e' on the system. The fact that only one changed might be because they actually ran 'insf -eH '.

'insf -e' will re-create device files with default ownership and permissions - it can also be called after a reboot so can catch you out then as well.

To get round this, I would create my own disk devices specifically for ASM . So in your case I would have done the following:

mkdir /dev/asm
cd /dev/asm
mknod disk1 c 188 0x0a0500
mknod disk2 c 188 0x0a2300
mknod disk3 c 188 0x0a0000
mknod disk4 c 188 0x060200
mknod disk5 c 188 0x080300
mknod disk6 c 188 0x080100
mknod disk7 c 188 0x0a2400
mknod disk8 c 188 0x0c2200
chown oracle:dba disk*

Then set ASM_DISKSTRING to point to this new area /dev/asm/disk* .

HTH

Duncan

[Robert-Jan Goossens]

Hi,

I have seen this on AIX after a varyoffvg/varyonvg, could be someone did a vgexport/vgimport or an insf -e.

You could create softlink to the raw disks.

Regards,
Robert-Jan

Ps.
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1071623

[yulianto piyut]

thx all for your suggestions,

for 8 disks that used by oracle, ONLY 2 disks that changed to bin:sys, if someone run "insf -e", all disks will changed to bin:sys. Before this case is happened, i had ever same case that the owner of all disks used by oracle changed to bin:sys after i run "insf -e".

-yut-

[yulianto piyut]

hi duncan,

do you had ever tried for your idea before?
if i want to change based on your idea, i must reconfigure the oracle ASM and will be taking more time to do it.
by the way, many thanks for your idea.

-yut-