19C-19.16 ORA-17503 ORA-27300 ORA-27301 ORA-27302
***alter 日志告警
2023-07-01T02:05:13.474592+08:00
Errors in file /u01/app/oracle/diag/rdbms/dg/dg1/trace/dg1_ora_17925.trc:
ORA-17503: ksfdopn:2 Failed to open file +DATA/dg/PASSWORD/pwddg
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@dg1 trace]$ more /u01/app/oracle/diag/rdbms/dg/dg1/trace/dg1_ora_17925.trc
Trace file /u01/app/oracle/diag/rdbms/dg/dg1/trace/dg1_ora_17925.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Build label: RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417
ORACLE_HOME: /u01/app/oracle/product/19.3.0/db_1
System name: Linux
Node name: dg1
Release: 3.10.0-957.el7.x86_64
Version: #1 SMP Thu Oct 4 20:48:51 UTC 2018
Machine: x86_64
Instance name: dg1
Redo thread mounted by this instance: 1
Oracle process number: 109
Unix process pid: 17925, image: oracle@dg1 (TNS V1-V3)
*** 2023-07-01T02:05:13.474407+08:00
*** SESSION ID:(13190.26415) 2023-07-01T02:05:13.474440+08:00
*** CLIENT ID:() 2023-07-01T02:05:13.474445+08:00
*** SERVICE NAME:(SYS$USERS) 2023-07-01T02:05:13.474449+08:00
*** MODULE NAME:(sqlplus@dg1 (TNS V1-V3)) 2023-07-01T02:05:13.474453+08:00
*** ACTION NAME:() 2023-07-01T02:05:13.474457+08:00
*** CLIENT DRIVER:() 2023-07-01T02:05:13.474461+08:00
ORA-17503: ksfdopn:2 Failed to open file +DATA/dg/PASSWORD/pwddg
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
ORA-17503: ksfdopn:2 Failed to open file +DATA/dg/PASSWORD/pwddg
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
<error barrier> at 0x7ffcd5ada518 placed kzia.c@2118
ORA-01017: invalid username/password; logon denied
***官网文档
Customer RecommendedDatabases alert log showing ORA-17503/ORA-01017 (Doc ID 2919585.1)
***实际环境验证
[oracle@dg1 trace]$ cat /etc/group | grep oinstall
oinstall:x:501:zabbix
[oracle@dg1 trace]$
***解决办法:
1) Take the backup of /etc/group
2) modify the oinstall in /etc/group as "oinstall:x:1001:grid,oracle"
Existing entry
oinstall:x:1001:grid
Change To
oinstall:x:1001:grid,oracle
***操作后
[root@dg1 ~]# cat /etc/group | grep oinstall
oinstall:x:501:grid,oracle,zabbix
[root@dg1 ~]#
***安装数据库的时候创建用户语法
[root@dg1 ~]# history |grep grid
25 /usr/sbin/useradd -u 601 -g oinstall -G asmadmin,asmdba,asmoper,dba grid
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 实操Deepseek接入个人知识库
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库