Select From V$DIAG_ADR_CONTROL Fails With ORA-48118 ORA-48193
(Doc ID 1269466.1)
Last updated on FEBRUARY 19, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
Select from V$DIAG_ADR_CONTROL fails ORA-48118 ORA-48193 if DIAGNOSTIC_DEST contains a dir with no read and write privileges.
SQL> select * from V$DIAG_ADR_CONTROL;
ERROR:
ORA-48118: error encountered with list directory
[<diagnostic_dest>/<DIR>]
ORA-48193: OS command to open a directory failed
SVR4 Error: 13: Permission denied
Additional information: 2
SQL> show parameter DIAGNOSTIC_DEST
NAME TYPE VALUE
------------------------------------ -----------
diagnostic_dest string <diagnostic_dest>
ERROR:
ORA-48118: error encountered with list directory
[<diagnostic_dest>/<DIR>]
ORA-48193: OS command to open a directory failed
SVR4 Error: 13: Permission denied
Additional information: 2
SQL> show parameter DIAGNOSTIC_DEST
NAME TYPE VALUE
------------------------------------ -----------
diagnostic_dest string <diagnostic_dest>
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |