RPM: ora-15186:asmlib Error function = [Asm_open], error = [1], 2009-05-24 13:57:38

RPM: ora-15186:asmlib Error function = [Asm_open], error = [1], 2009-05-24 13:57:38

http://space.itpub.net/471666/viewspace-406996

Ora-15186:asmlib error function = [Asm_open], error = [1], MESG = [Operation not permitted]

Reference Metalink note:398622.1

Subject:ora-15186:asmlib error function = [Asm_open], error = [1], MESG = [Operation not permitted]
Doc id:note:398622.1 Type:problem
Last Revision date:06-may-2008 status:published

In this Document
Symptoms
Cause
Solution
References

Applies To:
Oracle server-enterprise edition-version:10.1.0
This problem can occur on any platform.
Oracle Database ASM (Automatic Storage Management) instance
Oracle Asmlib
Raw devices
Symptoms
The Oracle Database ASM instance reports ORA-15186 error in the Alert.log, for example:

Ora-15186:asmlib error function = [Asm_open], error = [1], MESG = [Operation not permitted].

The error occurs periodically, most notably during ASM instance startup and as a result of v$asm_ ... view queries, as well As during RMAN backup.

Despite the error, however, no adverse affects is observed.

Cause
By default, the Oracle Database ASM instance parameter ' asm_diskstring ' is unset and therefore uses a default value of ' * '. This means, the ASM instance scans both/dev/raw/and/dev/oracleasm/disks/directories when searching for Oracle ASM disk S.

When using a combination of Oracleasm disks (/dev/oracleasm/disks/*) with raw devices (/dev/raw/*), in particular where so Me raw devices is not owned by or accessible to the Oracle user) as well as ASM instance parameter ' asm_diskstring ' with An unspecified value, error ORA-15186 was likely to occur.

Solution
The solution is to explictly set Oracle ASM instance parameter ' asm_diskstring ' such that it's only scans for oracleasm dis KS (e.g. with label orcl:*) or to sets the value to scan for intended oracleasm devices known to be oracleasm disks.

Explicitly setting ' Asm_diskstring ' is recommended as it increases Oracle ASM disk scan performance by restricting the NUM ber of devices scanned to only those marked with the default provisioned ' ORCL: ' label prefix or scanning only a given sub Set of devices.

Examples of setting asm_diskstring parameter include:

Sql> alter system set asm_diskstring= ' orcl:* ' Scope=both;
...

Sql> alter system set asm_diskstring= '/dev/raw/raw6,/dev/raw/raw7,/dev/raw/raw8 ' Scope=both;
...

Sql> alter system set asm_diskstring= '/dev/mapper/mpath0,/dev/mapper/mpath1,/dev/mapper/mpath2 ' Scope=both;
...

Note:whilst limiting the ' asm_diskstring ' value to a specific list of disks ensures optimal ASM instance scan performance , the parameter value must is modified to include any new devices whenever oracleasm disks is added or removed.

References
Note 391136.1-new asmlib/oracleasm Disk Gets "Header_status=unknown"-cannot be Added to DiskGroup
Keywords
Automatic~storage~management; Raw~device; Oracleasm; Asmlib;

RPM: ora-15186:asmlib Error function = [Asm_open], error = [1], 2009-05-24 13:57:38