This discussion is archived
3 Replies Latest reply: Nov 17, 2012 9:44 PM by Girish Sharma RSS

sqlnet.ora ADRCI entries

Neo-b Newbie
Currently Being Moderated
Hello All,

I am using Oracle 11g R2. (11.2.0.3)

My application team are requesting to add the below entries in the sqlnet.ora file of the oracle client not server:

DIAG_ADR_ENABLED=FALSE

DIAG_DDE_ENABLED=FALSE

DIAG_SIGHANDLER_ENABLED=FALSE

Does that impact my database in any way ? what disadvantages it has?

Regards,
  • 1. Re: sqlnet.ora ADRCI entries
    Girish Sharma Guru
    Currently Being Moderated
    When the DIAG_ADR_ENABLED parameter is set to OFF, non-ADR file tracing is used.
    http://docs.oracle.com/cd/B28359_01/network.111/b28317/sqlnet.htm#BIIHGAED

    1- If you don’t find Oracle Net flies in the directories where you expect those just set DIAG_ADR_ENABLED=OFF parameter in the relative sqlnet.ora file.

    Oracle will create the trace files depending on type Client/Server in the following directories:

    Client – OS Home dir/oradiag_os username/diag/clients/user_oradb/host_number/trace/

    RDBMS – ORACLE_BASE/diag/rdbms/db_name/instance_name/trace/

    Source:http://www.pythian.com/news/tag/diag_adr_enabled/

    2.Controlling ADR Creation and Disabling Fault Diagnosability Using sqlnet.ora
    http://docs.oracle.com/cd/B28359_01/appdev.111/b28395/oci10new.htm#CHDCIAHJ

    When I saw this link then here bit confusion regarding DIAG_ADR_ENABLED=FALSE or DIAG_ADR_ENABLED=off.

    Anyway, but I think there should not be any impact my database. They are just trace, dump files which an incident (an occurrence of a problem) on the OCI client is captured without user intervention in the form of diagnostic data: dump files or core dump files.

    Regards
    Girish Sharma
  • 2. Re: sqlnet.ora ADRCI entries
    Neo-b Newbie
    Currently Being Moderated
    Thanks for your answers:

    Does setting these parameters to false changes the directory structure of my trace files? If yes: that is mean it changes the directory structure only on the client side? or as well as the database server side? (I did not modify sqlnet.ora on the server side)

    Edited by: NB on Nov 17, 2012 5:05 PM
  • 3. Re: sqlnet.ora ADRCI entries
    Girish Sharma Guru
    Currently Being Moderated
    Does setting these parameters to false changes the directory structure of my trace files?
    No, I don't think that setting these parameter to false may change the directory structure, because Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. Setting these parameter to false just stops to create trace and dump files which are required to send the Oracle support. When the DIAG_ADR_ENABLED parameter is set to OFF, non-ADR file tracing is used.

    See Structure, Contents, and Location of the Automatic Diagnostic Repository :
    http://docs.oracle.com/cd/E11882_01/server.112/e25494/diag001.htm#ADMIN11008

    Regards
    Girish Sharma

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points