ADR files causing space issues

  • From: "Laurent, Vincent" <Vince_Laurent@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 9 Jan 2012 10:29:19 -0600

My ADR information is filling up my root directory instead of where I thought 
it should be going.
I have this set in my listener.ora file:


In my spfile I have the diagnostic directory set up:

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest                      string      /oracle/SND/saptrace

My v$diag_nfo even shows where it should be going:

   INST_ID NAME                  VALUE
---------- --------------------  
         1 Diag Enabled          TRUE
         1 ADR Base              /oracle/SND/saptrace
         1 ADR Home              /oracle/SND/saptrace/diag/rdbms/snd_sapsnd/SND
         1 Diag Trace            
         1 Diag Alert            
         1 Diag Incident         
         1 Diag Cdump            
         1 Health Monitor        
         1 Default Trace File    
         1 Active Problem Count  0
         1 Active Incident Count 0

But it looks like it is all going here:


Why is it NOT going where I aimed it?

Also, the messages are all like this.   What is generating this?

<msg time='2012-01-03T09:43:24.007-06:00' org_id='oracle' comp_id='clients'
type='UNKNOWN' level='16' host_id='sapsnd'
host_addr='x.x.x.x' version='1'>
<txt>Directory does not exist for read/write [/oracle/SND/112_64/log] 

Confidentiality Notice: This email message, including any
attachments, is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is prohibited.
If you are not the intended recipient, please contact the sender by
reply email and destroy all copies of the original message.

Other related posts: