oracle 11gR2开始,安装grid集群和oracle软件分开两个用户安装

grid用户单独安装集群,比如包括asm实例,监听资源,节点资源等

oracle用户就只安装oracle代码

grid用户下面新增了三个组asmadmin,asmdba,asmoper

下面列出具体每个用户和组之间对应的关系

用户组	所属该组的用户	用户组描述
oinstall	grid, oracle	Oracle Inventory and Software Owner
dba	grid, oracle	Database Administrator
asmadmin	grid	Oracle Automatic Storage Management Group
asmdba	grid, oracle	ASM Database Administrator Group
asmoper	grid	ASM Operator Group
oper	oracle	Database Operator

如果对oracle用户没赋予asmdba组的话,则会导致oracle用户认不到diskgroup,启动对应节点实例失败。

Thu Jul 08 18:04:18 2010
ASMB started with pid=29, OS id=21238
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+TESTDG/racdb/controlfile/current.256.723833823'
ORA-17503: ksfdopn:2 Failed to open file +TESTDG/racdb/controlfile/current.256.723833823
ORA-15001: diskgroup "TESTDG" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges
Starting background process ASMB

通过id命令可以显示用户包含哪些组

[oracle@rac1 trace]$ id
uid=502(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),506(asmdba)
[oracle@rac1 trace]$

ITPub博客

oracle 11gR2 rac grid和oracle所属的组信息

最新文章