ORA-15183 Unable to Create Database on Server using 11.2 ASM

ORA-15183 Unable to Create Database on Server using 11.2 ASM and Grid Infrastructure [ID 1054033.1]

Applies to:
Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.1.0 - Release: 11.1 to 11.2
Information in this document applies to any platform.

Symptoms
Using 11.2.0.1 Grid Infrastructure and ASM, try to create 11.1.0.7 database as oracle user "oratest",

while Grid is installed as grid user "grid", getting error in "create database ..." command:
ERROR: asm_version error. err: driver/agent not installed rc:2
ORA-15183: ASMLIB initialization error [driver/agent not installed]
WARNING:FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
ERROR: asm_init(): asm_erc:-5 msg:Driver not installed pid:25261

The grid and oratest users are defined as:
[root@node2]# id grid
uid=212(grid) gid=201(oinstall) groups=201(oinstall),202(dba),204(asmadmin),205(asmdba),220(asmoper)

[grid@node2]$ id oratest
uid=215(oratest) gid=201(oinstall) groups=201(oinstall),202(dba),205(asmdba),222(oper)

 

Changes
New installation

Cause
This is caused by the use of job role separation and oracle binary not having the proper group ownership

preventing the database software owner "oratest" from accessing the ASMlib driver.

The output of "/usr/sbin/oracleasm configure" shows:
ORACLEASM_UID=grid
ORACLEASM_GID=asmadmin

Only users that are members of the asmadmin group have direct access to ASM disks and maintenance. For

other database users (software owners), the access is gained via the oracle executable

($ORACLE_HOME/bin/oracle). It should have a setgid bit with group set to "asmadmin". The "oracle" binary

is changed automatically via setasmgidwrap when the instance is started by the CRS daemon (e.g. srvctl

start database/instance).

In this case, the oracle binary is owned by
-rwsr-s--x 1 oratest oinstall
instead of
-rwsr-s--x 1 oratest asmadmin

 

Solution
Manually change the oracle binary ownership and permission:
as root user:
cd $ORACLE_HOME/bin
chgrp asmadmin oracle
chmod 6751 oracle
ls -l oracle

Ensure the ownership and permission is now like:
-rwsr-s--x 1 oratest asmadmin

Then retry "create database" command.

* Note 1: This change is only required for RDBMS $ORACLE_HOME/bin/oracle. Please do not modify

$GRID_HOME/bin/oracle binary ownership.
* Note 2: Anytime when a patch is applied to the database ORACLE_HOME, please ensure above ownership and

permission is corrected after the patch.
References

Show Related Information Related
Products

    * Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition

Keywords
ASMLIB; INFRASTRUCTURE; GRID; ORACLEASM

Errors
ORA-15183