RE: ADR files causing space issues

From: Laurent, Vincent <Vince_Laurent_at_ssmhc.com>
Date: Tue, 10 Jan 2012 09:05:57 -0600
Message-ID: <EF763CC31BB89B47B435AE02FE42263F04744C066F_at_S009-APEXM05.ds.ad.ssmhc.com>



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_at_gmail.com] Sent: Tuesday, January 10, 2012 8:59 AM
To: Laurent, Vincent
Cc: oracle-l_at_freelists.org
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_at_ssmhc.com<mailto:Vince_Laurent_at_ssmhc.com>> 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.
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 10 2012 - 09:05:57 CST

Original text of this message