ORA-15183 Unable to Create Database on Server using 11.2 ASM and Grid Infrastructure (Doc ID 1054033.1)
In this Document
|Scalability RAC Community|
Using 126.96.36.199 Grid Infrastructure and ASM, try to create pre-11.2 database as RDBMS software owner "oradb", while Grid is installed as grid user "oragrid", getting error in "create database ..." command:
For 11.1.0.x database, the error is like:
For 10.2.0.x database, the error is like:
Or if the database is created in earlier release, after upgrade to 11.2 Grid Infrastructure and ASM, user orasup in dba group (not the RDBMS software owner) can not query v$database:
The grid, oracle and orasup users are defined as:
This is caused by the use of job role separation and oracle binary not having the proper group ownership preventing the database software owner "oradb" from accessing the ASMlib driver or ASM disks.
During 11.2 Gird Infrastructure installation, it prompts to select ASM admin group and ASM dba group. Assume asmadmin is used for ASM admin group and asmdba is used for ASM dba group.
Only users that are members of the asmadmin group have direct access to ASM disks and maintenance. For other database users (software owners or dba group users), the access is gained via the oracle executable ($ORACLE_HOME/bin/oracle). It should have a setgid bit with group set to "asmadmin".
The 11.2 "oracle" binary is changed automatically via setasmgidwrap when the instance is started by the CRS daemon (e.g. srvctl start database/instance). But for earlier release, the "oracle" binary group and ownership need to be set manually.
In this case, the oracle binary is owned by
-rwsr-s--x 1 oracle oinstall
-rwsr-s--x 1 oracle asmadmin
For Linux platform, one can verify via "/usr/sbin/oracleasm configure" to confirm the ASM admin group group setting:
For other platform, check installAction
1. Manually change the oracle binary ownership and permission:
Ensure the ownership and permission is now like:
With 188.8.131.52+ GI, the same change can be achieved via the following commands: (refer to Document 1084186.1 Database Creation on 11.2 Grid Infracture with Role Separation ( ORA-15025, KFSG-00312, ORA-15081 ) )
2. Restart the instance
3. Retry "create database" command or retry the query as dba group user.
To discuss this topic further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the My Oracle Support Scalability RAC Community.BUG:9575578 - KFSG-00312: NOT AN ORACLE BINARY, USING SETASMGIDWRAP
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17252115/viewspace-1104347/，如需转载，请注明出处，否则将追究法律责任。