重庆思庄Oracle、Redhat认证学习论坛

标题: oracle数据库日志报错ORA-27300 ORA-27301 ORA-27302 ORA-27157 [打印本页]

作者: jiawang    时间: 2024-8-9 18:07
标题: oracle数据库日志报错ORA-27300 ORA-27301 ORA-27302 ORA-27157
本帖最后由 jiawang 于 2024-8-9 18:07 编辑

环境介绍:
os:Oracle Linux 8.6
db:19.19

alter日志:2024-08-06T02:06:19.221643+08:00
Errors in file /u01/app/oracle/diag/rdbms/ptdb/ptdb1/trace/ptdb1_ora_918381.trc:
ORA-17503: ksfdopn:2 Failed to open file +DGDATA/PTDB/PASSWORD/pwdptdb.256.1138232689
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
2024-08-06T02:06:19.225750+08:00
Errors in file /u01/app/oracle/diag/rdbms/ptdb/ptdb1/trace/ptdb1_ora_918381.trc:
ORA-17503: ksfdopn:2 Failed to open file +DGDATA/PTDB/PASSWORD/pwdptdb.256.1138232689
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-01017: invalid username/password; logon denied


.trc详细日志:
Trace file /u01/app/oracle/diag/rdbms/ptdb/ptdb1/trace/ptdb1_ora_918381.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
Build label:    RDBMS_19.19.0.0.0DBRU_LINUX.X64_230321.1
ORACLE_HOME:    /u01/app/oracle/product/19.19.0/db_1
System name:        Linux
Node name:        his01
Release:        5.4.17-2136.307.3.1.el8uek.x86_64
Version:        #2 SMP Mon May 9 17:29:47 PDT 2022
Machine:        x86_64
Instance name: ptdb1
Redo thread mounted by this instance: 1
Oracle process number: 135
Unix process pid: 918381, image: oracle@his01 (TNS V1-V3)




*** 2024-08-06T02:06:19.221458+08:00 (CDB$ROOT(1))
*** SESSION ID:(2349.28015) 2024-08-06T02:06:19.221495+08:00
*** CLIENT ID:() 2024-08-06T02:06:19.221501+08:00
*** SERVICE NAME:(SYS$USERS) 2024-08-06T02:06:19.221505+08:00
*** MODULE NAME:(sqlplus@his01 (TNS V1-V3)) 2024-08-06T02:06:19.221510+08:00
*** ACTION NAME:() 2024-08-06T02:06:19.221515+08:00
*** CLIENT DRIVER:(SERVER) 2024-08-06T02:06:19.221518+08:00
*** CONTAINER ID:(1) 2024-08-06T02:06:19.221523+08:00

ORA-17503: ksfdopn:2 Failed to open file +DGDATA/PTDB/PASSWORD/pwdptdb.256.1138232689
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 +DGDATA/PTDB/PASSWORD/pwdptdb.256.1138232689
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 0x7ffc0a32afb8 placed kzia.c@2652
ORA-01017: invalid username/password; logon denied


官方文档:
Customer RecommendedDatabases alert log showing ORA-17503/ORA-01017 (Doc ID 2919585.1)
E6810678E57A252AB362F5380E380419.png
登录/注册后可看大图