RE: ADR files causing space issues
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