1 Reply Latest reply: Oct 28, 2009 8:40 AM by user7110532 RSS

    DIAGNOSTIC_DEST directory getting created in $HOME of  oracle user accout

    Ken_73
      DB version:11.1.0.7
      OS:     AIX


      I have an 11.1.0.7 and 10gR2 database in a machine. During creation of the 11g Database, i had explicitly specified the DIAGNOSTIC_DEST parameter in $ORACLE_BASE. Few days back i've noticed a directory called oradiag_oracle in the $HOME(not $ORACLE_HOME) of the oracle user account. Yesterday i removed it. But soon this directory got created automatically.

      Any idea why Oracle is creating this directory in $HOME. I checked the alert log, but this directory is not mentioned there.
      $ ls -R oradiag_oracle/
      diag/
      oradiag_oracle/diag:
      clients/
      
      oradiag_oracle/diag/clients:
      user_oracle/
      
      oradiag_oracle/diag/clients/user_oracle:
      host_2263549305_22/
      
      oradiag_oracle/diag/clients/user_oracle/host_2263549305_22:
      alert/     cdump/     incident/  incpkg/    lck/       metadata/  stage/     sweep/     trace/
      
      oradiag_oracle/diag/clients/user_oracle/host_2263549305_22/alert:
      log.xml
      
      oradiag_oracle/diag/clients/user_oracle/host_2263549305_22/cdump:
      
      oradiag_oracle/diag/clients/user_oracle/host_2263549305_22/incident:
      
      oradiag_oracle/diag/clients/user_oracle/host_2263549305_22/incpkg:
      
      oradiag_oracle/diag/clients/user_oracle/host_2263549305_22/lck:
      AM_4096102193_3466045376.lck   AM_4096102262_3454619329.lck   AM_9744645641_3661997533.lck   AM_3216666543_3129272966.lck
      
      oradiag_oracle/diag/clients/user_oracle/host_2263549305_22/metadata:
      ADR_CONTROL.ams          ADR_INVALIDATION.ams     INC_METER_IMPT_DEF.ams   INC_METER_PK_IMPTS.ams
      
      oradiag_oracle/diag/clients/user_oracle/host_2263549305_22/stage:
      
      oradiag_oracle/diag/clients/user_oracle/host_2263549305_22/sweep:
      
      oradiag_oracle/diag/clients/user_oracle/host_2263549305_22/trace:
      sqlnet.log
        • 1. Re: DIAGNOSTIC_DEST directory getting created in $HOME of  oracle user accout
          user7110532
          It looks like this is for client tracing. I did not see it in 11.1.0.7.0, but am seeing it in 11.2.0.1.0. The directory gets created in your home directory when you make a client connection.

          logged in as oracle I get

          /oracle/oradiag_oracle

          when logged in as myself I get

          /home/jwalker/oradiag_jwalker.

          there is a note that explains how you can revert behavior back, but it requires making changes to several config files (not sure it is worth it). Doc ID:      454927.1 -> It references 11.1.0.6.0 but my 11.1 was 11.1.0.7.0 and I don't have this happen there, only on 11.2.