My Oracle Support Banner

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 later
Information 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>

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.