srvctl start database 失败 ORA-01017: invalid username/password; logon denied

现象

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 ~]$ 
姚远ACE CSDN认证博客专家 ACE 华为云 MVP
Oracle ACE,华为云 MVP,Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890;获得过两次国家部级科技进步奖;发明过两项计算机专利。微信:yaoyuanace 邮箱:yaoyuanace(at)qq.com
已标记关键词 清除标记
相关推荐
©️2020 CSDN 皮肤主题: Age of Ai 设计师:meimeiellie 返回首页