Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NL-08014, NL-08015

Xiaogang ZhengSep 18 2020 — edited Sep 23 2020

Hi,

I get the strange error on file sqlnet.log:

###########################################################################

NL-08014: Failed to initialize Diagnosability framework, falling back to old network tracing/logging

NL-08015: Client(OCI) side initialization of Diagnosability framework failed

  ORA-48165: user missing read, write, or exec permission on specified ADR Base directory []

]ser inputted base directory is invalid [48187] [/urac01/app/oracle/diag/client

###########################################################################

The $ORACLE_HOME/network/admin/sqlnet.ora file contains the following two lines:

DIAG_ADR_ENABLED = ON

ADR_BASE = /urac01/app/oracle/diag/client

And 'oracle' account has fully permission (777) on this directory

> ls -l /urac01/app/oracle/diag/

total 20

drwxrwxr-x.  2 oracle oinstall     6 Sep 23  2015 afdboot

drwxrwxr-x.  2 oracle oinstall     6 Sep 23  2015 apx

drwxrwxr-x.  2 oracle oinstall     6 Sep 23  2015 asm

drwxrwxr-x.  3 oracle oinstall    24 Sep 14  2016 asmtool

drwxrwxrwx   2 oracle oinstall     6 Sep 18 16:13 client

......

I also test to create a file and write to it without problem.

/urac01/app/oracle/diag > touch client/test.txt

thailand:prd1203 | /urac01/app/oracle/diag > cat > client/test.txt

Test

^Z

[2]+  Stopped                 cat > client/test.txt

thailand:prd1203 | /urac01/app/oracle/diag > cat client/test.txt

Test

It is definitely not a permission issue.

Please help what's wrong.

Thanks

Xiaogang

Comments
Post Details
Added on Sep 18 2020
5 comments
5,800 views