重庆思庄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)
