最近denied比较频繁
告警日志频繁出现读取口令文件时，权限不足，检查相关trc文件
-
Trace file /oracle/app/oracle/diag/rdbms/ORCL/ORCL1/trace/ORCL1_ora_14549066.trc
-
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
-
Version 19.9.0.0.0
-
Build label: RDBMS_19.9.0.0.0DBRU_AIX.PPC64_200930
-
ORACLE_HOME: /oracle/app/oracle/product/19.3.0/db_1
-
System name: AIX
-
Node name: db1
-
Release: 1
-
Version: 7
-
Machine: 00FBDF014C00
-
Instance name: ORCL1
-
Redo thread mounted by this instance: 1
-
Oracle process number: 96
-
Unix process pid: 14549066, image: oracle@db1 (TNS V1-V3)
-
-
-
*** 2022-06-21T15:54:40.044178+08:00
-
*** SESSION ID:(8.61294) 2022-06-21T15:54:40.044205+08:00
-
*** CLIENT ID:() 2022-06-21T15:54:40.044212+08:00
-
*** SERVICE NAME:(SYS$USERS) 2022-06-21T15:54:40.044219+08:00
-
*** MODULE NAME:(sqlplus@db1 (TNS V1-V3)) 2022-06-21T15:54:40.044227+08:00
-
*** ACTION NAME:() 2022-06-21T15:54:40.044234+08:00
-
*** CLIENT DRIVER:() 2022-06-21T15:54:40.044240+08:00
-
-
ORA-17503: ksfdopn:2 Failed to open file +DATADG/ORCL/PASSWORD/pwdorcl
-
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 +DATADG/ORCL/PASSWORD/pwdorcl
-
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 0xfffffffffff4140 placed kzia.c@2131
-
ORA-01017: invalid username/password; logon denied
-
ORA-17503: ksfdopn:2 Failed to open file +DATADG/ORCL/PASSWORD/pwdorcl
-
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
似乎又是属组的问题，搜索mos
ORA-17503/ORA-27300/ORA-27301/ORA-27302 occurred if connected database via an os user who is not in "oinstall" group (Doc ID 2310640.1)
后来问题就消失，不再出现。
通过last|head 推测案发现场：
有个正经人，登录主机，配置监控，但是os用户权限没搞对，就导致登录数据库报错，后来可能是意识到问题，增加了oinstall组，解决了。
但是看了看 cat /etc/passwd 没有怀疑对象，未完...
阅读(1486) | 评论(0) | 转发(0) |
