现象
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 ~]$
