Home » RDBMS Server » Server Administration » multiple log.xml files (Oracle 11g on HP-UX11.31)
multiple log.xml files [message #538975] Tue, 10 January 2012 10:46
vincel
Messages: 6
Registered: January 2010
Location: St Louis
Junior Member
My ADR information is filling up my root directory instead of where I thought it should be going. Actually it is going to two places.

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>

Yes, I have bounced the listener (and the database many times).
Actually, as I dig I find more copies:
(root@sapsnd)# find . -name log.xml -exec ls -al {} \;
-rw-rw---- 1 orasnd dba 40169 Jan 10 00:35 ./var/tmp/oradiag_orasnd/diag/clients/user_orasnd/host_4049645707_80/alert/log.xml
-rw-r----- 1 orasnd dba 9096322 Jan 10 10:40 ./oracle/SND/saptrace/diag/tnslsnr/sapsnd/listener/alert/log.xml
-rw-r----- 1 orasnd dba 5665759 Jan 10 10:40 ./oracle/SND/saptrace/diag/rdbms/snd_sapsnd/SND/alert/log.xml
-rw-rw---- 1 root sys 7362276 Jan 10 10:44 ./root/oradiag_root/diag/clients/user_root/host_4049645707_80/alert/log.xml

What is creating these other ones?
Previous Topic: Index rebulding
Next Topic: Invalid component on 10.2 database(2 Merged)
Goto Forum:
  


Current Time: Thu Mar 28 11:42:45 CDT 2024