现象
vctl start database -database orcl
PRCR-1079 : Failed to start resource ora.orcl.db
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-01017: invalid username/password; logon denied
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/dell/crs/trace/ohasd_oraagent_grid.trc".
ORA-01017: invalid username/password; logon denied
CRS-2674: Start of 'ora.orcl.db' on 'dell' failed
ORA-01017: invalid username/password; logon denied
分析
[grid@dell ~]$ crsctl getperm resource ora.orcl.db
Name: ora.orcl.db
owner:grid:rwx,pgrp:asmdba:r-x,other::r--,group:oinstall:r-x,user:oracle:rwx
[grid@dell ~]$
[grid@dell ~]$ sr
[grid@dell ~]$ id grid
uid=54322(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54327(asmdba),54328(asmoper),54329(asmadmin)
[grid@dell ~]$ crsctl -h
[grid@dell ~]$ crsctl getperm resource ora.orcl.db -u grid
Name: ora.orcl.db
rwx
[grid@dell ~]$ crsctl getperm resource ora.orcl.db -u oracle
Name: ora.orcl.db
rwx
[grid@dell ~]$ crsctl getperm resource ora.orcl.db -g oinstall
Name: ora.orcl.db
r-x
[grid@dell ~]$
解决
编辑/etc/group ,给grid加了一个组 racdba,重新启动成功!
[grid@dell ~]$ id grid
uid=54322(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54330(racdba),54327(asmdba),54328(asmoper),54329(asmadmin)
[grid@dell ~]$ srvctl start database -database orcl
[grid@dell ~]$