Hi,
I'm behind a troubleshooting in a 11.2.0.1 DB, and for it I enabled sqlnet trace level 16 for both server and client (since the issue is related with Nagios connections running on the same server). [So, this is my first time testing with traces]
I'm also familiarized with ADR structure and adrci commands so I wanted to keep it, but no for sqlnet client traces generated by root user.
This is my configuration. I move adr/traces to a separate volume, so I wont scary if they growth too much:
- parameter diagnostic_dest=/mnt/tracesvol/ADR/
- $ORACLE_HOME/network/admin/sqlnet.ora
TRACE_LEVEL_CLIENT=16
TRACE_LEVEL_SERVER=16 - /root/.sqlnet.ora
DIAG_ADR_ENABLED = off
TRACE_LEVEL_CLIENT = 16
LOG_DIRECTORY_CLIENT = /mnt/tracesvol/client/
TRACE_DIRECTORY_CLIENT = /mnt/tracesvol/client/
TRACE_TIMESTAMP_CLIENT = on
This configuration writes all the server traces in the new ADR repository destination, and sqlnet client traces by root user in /mnt/tracesvol/client/ folder without ADR (cli_*.trc trace files). Trace files were generating on them as expected.
The problem is that our sysadmin found the folder /root/oradiag_root/diag/clients/user_root/host_486939793_76/ with several trace files. In its subdir ./alert/, the log.xml said that $ORACLE_HOME/log/diag does not exist. So, we created that folder (but I dont know why he was looking for this folder. As I see on Parameters for the sqlnet.ora File he only looks for this folder if ADR is enabled and no $ORACLE_BASE variable is defined [but I've disabled ADR in /root/.sqlnet.ora]).
After that , we found that the folder $ORACLE_HOME/log/diag/clients/user_root/host_486939793_76/ were generating new trace files, with the format ora_*_*.trc, but they dont content the same traces as /mnt/tracesvol/client/cli_*.trc has
What is this folder and all these traces, and who generate them?
Regards