dba oralcle 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的用户的话,dbca里面是看不见asm实例里面建立的diskgroup
而/dev/raw下面的权限,给grid:asmdba,让grid和oracle都可以读取。
[root@orasrv rules.d]# cat /etc/udev/rules.d/60-raw.rules
# Enter raw device bindings here.
#
# An example would be:
# ACTION=="add", KERNEL=="sda", RUN+="/bin/raw /dev/raw/raw1 %N"
# to bind /dev/raw/raw1 to /dev/sda, or
# ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw /dev/raw/raw2 %M %m"
# to bind /dev/raw/raw2 to the device with major 8, minor 1.
ACTION=="add", KERNEL=="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add", KERNEL=="sdb2", RUN+="/bin/raw /dev/raw/raw2 %N"
ACTION=="add", KERNEL=="sdc1", RUN+="/bin/raw /dev/raw/raw3 %N"
ACTION=="add", KERNEL=="sdc2", RUN+="/bin/raw /dev/raw/raw4 %N"
KERNEL=="raw*", OWNER="grid" GROUP="asmdba", MODE="0660"
# start_udev # raw -qa # ls -l /dev/raw
如果需要grid用户的crs能启动database,还需要将grid用户加入到dba组才可以启动,否则
[grid@orasrv ~]$ srvctl start database -d orclem PRCR-1079 : Failed to start resource ora.orclem.db ORA-01017: invalid username/password; logon denied CRS-5017: The resource action "ora.orclem.db start" encountered the following error: ORA-01017: invalid username/password; logon denied . For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/orasrv/crs/trace/ohasd_oraagent_grid.trc". CRS-2674: Start of 'ora.orclem.db' on 'orasrv' failed ORA-01017: invalid username/password; logon denied
没有评论:
发表评论