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