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