***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