We are evaluating Oracle 11.2.0.2 on Oracle Entreprise Linux 5.5 for a single instance database (no RAC but with Grid Infrastructure):
I have installed:
- ASMLIB: ASMLIB is configured with 'oracle' user and 'oinstall' group
- Grid Infrastructure with 'oracle' account and created one disk group named DATA.
Everything is OK until I reboot the node then I get:
ORA-15186: ASMLIB error function = [asm_open(global)], error = [1], mesg = [Operation not permitted]
ORA-15025: could not open disk "ORCL:DISKP3"
I can also reproduce this issue with "/etc/init.d/oracleasm stop" and "etc/init.d/oracleasm start"
ASM disk is created with following statement using internal RAID physical disks that are using /dev/sda and /dev/sdb:
/etc/init.d/oracleasm createdisk DISKP3 /dev/mapper/asr_raidts2003p3
After node reboot or /etc/init.d/oracleasm stop and start I have:
/etc/init.d/oracleasm querydisk DISKP3
Disk "DISKP3" is a valid ASM disk
I have read that in some cases multipathing can be an issue and that it may be needed to configure variables ORACLEASM_SCANORDER and ORACLEASM_SCANEXCLUDE in /etc/sysconfig/oracleasm. But it does not work:
setting ORACLEASM_SCANORDER="mapper" and ASM disk is not created in /dev/oracleasm.
setting ORACLEASM_SCANEXCLUDE="sd" does also not work.