增加temp表空间数据文件报错:
SQL> alter tablespace temp add tempfile '+DATADG';
alter tablespace temp add tempfile '+DATADG'
*
ERROR at line 1:
ORA-01119: error in creating database file '+DATADG'
ORA-17502: ksfdcre:4 Failed to create file +DATADG
ORA-15001: diskgroup "DATADG" does not exist or is not mounted
ORA-01017: invalid username/password; logon denied
datadg磁盘组正常mount,数据库也能正常起来。
oracle mos查找,找到一篇文档"ORA-17502 /ORA-01017: invalid username/password; logon denied " (Doc ID 2610682.1)
经过对比发现"/etc/group" 未显示 "oracle" user 对应为 "oinstall" 组。
修改用户组:
usermod -g oinstall -G oinstall,dba oracle
usermod -g oinstall -G oinstall,dba grid