本文主要是介绍rac两节点,一个库起不来,其他集群状态正常。(ORA-01078 ORA-01565 ORA-17503 ORA-01017),希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
尝试开启实例,报如下错误:
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/ptgk/spfileptgk.ora'
ORA-17503: ksfdopn:10 Failed to open file +DATA/ptgk/spfileptgk.ora
ORA-01017: invalid username/password; logon denied
根据Troubleshooting ORA-1031 or ORA-1017 Errors When Connecting As SYSDBA (文档 ID 730067.1)
查看两节点oracle用户属组信息
[oracle@rac1 ~]$ id
uid=1200(oracle) gid=1000(oinstall)groups=1000(oinstall),1200(dba),1201(oper),1300(asmdba)
[oracle@rac2 ~]$ id
uid=1200(oracle) gid=1000(oinstall) groups=1000(oinstall),10(wheel)
怀疑是人为修改过Oracle用户的属组
使用如下命令进行修改
usermod -goinstall,dba,oper,asmdba.whell oracle
问题解决!
ora.ptgk.db
1 ONLINE ONLINE rac1 Open
2 ONLINE ONLINE rac2 Open
这篇关于rac两节点,一个库起不来,其他集群状态正常。(ORA-01078 ORA-01565 ORA-17503 ORA-01017)的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!