RE: ADR files causing space issues

  • From: "Laurent, Vincent" <Vince_Laurent@xxxxxxxxx>
  • To: LS Cheng <exriscer@xxxxxxxxx>
  • Date: Tue, 10 Jan 2012 09:05:57 -0600

From the initSND.ora:
*.local_listener='LISTENER_SND'
From lsnrctl status:
STATUS of the LISTENER
------------------------
Alias                     LISTENER

From tnsnames.ora:
LISTENER_SND.WORLD   (ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = 
<port>))

From: LS Cheng [mailto:exriscer@xxxxxxxxx]
Sent: Tuesday, January 10, 2012 8:59 AM
To: Laurent, Vincent
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: ADR files causing space issues

what is your listener name?

--
LSC

On Mon, Jan 9, 2012 at 5:29 PM, Laurent, Vincent 
<Vince_Laurent@xxxxxxxxx<mailto:Vince_Laurent@xxxxxxxxx>> wrote:
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:

ADR_BASE_LISTENER=/oracle/SND/saptrace

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            
/oracle/SND/saptrace/diag/rdbms/snd_sapsnd/SND/trace
        1 Diag Alert            
/oracle/SND/saptrace/diag/rdbms/snd_sapsnd/SND/alert
        1 Diag Incident         
/oracle/SND/saptrace/diag/rdbms/snd_sapsnd/SND/incident
        1 Diag Cdump            
/oracle/SND/saptrace/diag/rdbms/snd_sapsnd/SND/cdump
        1 Health Monitor        
/oracle/SND/saptrace/diag/rdbms/snd_sapsnd/SND/hm
        1 Default Trace File    
/oracle/SND/saptrace/diag/rdbms/snd_sapsnd/SND/trace/SND_ora_26527.trc
        1 Active Problem Count  0
        1 Active Incident Count 0

But it looks like it is all going here:

/root/oradiag_root/

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] 
[/oracle/SND/112_64/log/diag/clients]
</txt>
</msg>


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.
--
//www.freelists.org/webpage/oracle-l



--
//www.freelists.org/webpage/oracle-l


Other related posts: