Unexpected behavior from ASM (?)

From: Hubler, Daniel <daniel.hubler_at_aurora.org>
Date: Wed, 19 Mar 2014 13:03:19 +0000
Message-ID: <850425C04FB76547AC0ED12C5F7E0B8021B0B1_at_HEIMSEAT021.ahc.root.loc>

Oracle DBMS v11.2.0.3
2-node RAC
ASM on raw devices
AIX v6.1
(a TEST environment !)

Added a bunch of raw devices into ASM using the following: ===
SQL> alter diskgroup data
add disk '/dev/rhdisk35','/dev/rhdisk36','/dev/rhdisk37','/dev/rhdisk38','/dev/rhdisk39','/dev/rhdisk40','/dev/rhdisk41' rebalance power 8;

Diskgroup altered.

Shortly (minutes) after this completed,
both database instances crashed.
ASM survived.

Immediately started looking at the details on these raw devices. Discovered that the permissions on some of them were incorrect; missing various r-w permissions.

Changed those permissions.
Restarted the DBMS instances successfully; no issues since.

I guess my question is, how did this get past ASM ? Does it not check for this?

(the coincidence is that the AIX-admin who built the raw devices was doing this for the first time)

Thanks for any input.

Daniel Hubler
Aurora Healthcare
IT Infrastructure

Received on Wed Mar 19 2014 - 14:03:19 CET

Original text of this message