Oracle 19c RAC报错ORA-17503,ORA-27300,ORA-27301,ORA-27302-洪萨配资

发现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 grid

4.验证/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)