3 Replies Latest reply: Nov 17, 2012 11:44 PM by Girish Sharma RSS

    sqlnet.ora ADRCI entries

    Neo-b
      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
          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
            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
              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