发现alert日志频繁报错
ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/PASSWORD/pwdmesprod.256.1168973143
ORA-27300: OS system dependent operation:open failed with status: 13
ORA-27301: OS failure message: Permission denied
ORA-27302: failure occurred at: sskgmsmr_7
trc 日志信息
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.22.0.0.0
Build label: RDBMS_19.22.0.0.0DBRU_LINUX.X64_231229
ORACLE_HOME: /u01/app/oracle/product/19.0.0/dbhome_1
System name: Linux
Node name: orcl1
Release: 5.4.17-2102.201.3.el7uek.x86_64
Version: #2 SMP Fri Apr 23 09:05:55 PDT 2021
Machine: x86_64
CLID: P
Instance name: ORCL1
Redo thread mounted by this instance: 1
Oracle process number: 83
Unix process pid: 28540, image: oracle@orcl1 (TNS V1-V3)
*** 2025-11-30T03:11:07.432948+08:00
*** SESSION ID:(1823.36142) 2025-11-30T03:11:07.432960+08:00
*** CLIENT ID:() 2025-11-30T03:11:07.432964+08:00
*** SERVICE NAME:(SYS$USERS) 2025-11-30T03:11:07.432966+08:00
*** MODULE NAME:(sqlplus@orcl1 (TNS V1-V3)) 2025-11-30T03:11:07.432970+08:00
*** ACTION NAME:() 2025-11-30T03:11:07.432973+08:00
*** CLIENT DRIVER:(SQL*PLUS) 2025-11-30T03:11:07.432975+08:00
ORA-17503: ksfdopn:2 Failed to open file +DATA/MESPROD/PASSWORD/pwdmesprod.256.1168973143
ORA-27300: OS system dependent operation:open failed with status: 13
ORA-27301: OS failure message: Permission denied
ORA-27302: failure occurred at: sskgmsmr_7
此报错对系统运行没有什么影响，排查及解决办法如下（参考官方文档 KB96677）：
1.查看oracle及grid用户信息，正常
[root@rac1 ~]# id oracleuid=1101(oracle)gid=1005(oinstall)groups=1005(oinstall),1001(dba),1002(asmadmin),1003(asmdba),1004(asmoper)[root@rac1 ~]# id griduid=1100(grid)gid=1005(oinstall)groups=1005(oinstall),1001(dba),1002(asmadmin),1003(asmdba),1004(asmoper)2.查看/etc/group文件中oinstall信息
发现现象与官方文档一致，oinstall处缺少oracle及grid用户
3.解决方法
将grid与oracle用户追加到附加组oinstall
[root@rac1 ~]# usermod -a -G oinstall oracle [root@rac1 ~]# usermod -a -G oinstall grid4.验证/etc/group结果，oinstall组信息正常
[root@rac1 ~]# cat /etc/groupoinstall:x:1005:oracle,grid dba:x:1001:grid,oracle asmadmin:x:1002:grid,oracle asmdba:x:1003:grid,oracle asmoper:x:1004:grid,oracle###grid及oracle用户信息查出来没有改变，与原来一致[root@rac1 ~]# id griduid=1100(grid)gid=1005(oinstall)groups=1005(oinstall),1001(dba),1002(asmadmin),1003(asmdba),1004(asmoper)[root@rac1 ~]# id oracleuid=1101(oracle)gid=1005(oinstall)groups=1005(oinstall),1001(dba),1002(asmadmin),1003(asmdba),1004(asmoper)5.后续观察
alert日志中未再出现ORA-17503 ORA-27300 ORA-27301 ORA-27302告警信息
