11g warning log 1. obtain information about ADR by querying the v $ diag_info view. sys @ ora11g> select * from v $ diag_info; INST_ID name value ------- -------------------- metric 1 Diag Enabled TRUE 1 ADR Base/oracle/u01/app/oracle 1 ADR Home/oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g 1 Diag Trace/oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g/trace 1 Diag Alert/oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g /alert 1 Diag Incident/oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g/incident 1 Diag Cdump/oracle/u01/app/oracle/diag/rdbms/ora11g /ora11g/cdump 1 Health Monitor/oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g/hm 1 Default Trace File/oracle/u01/app/oracle/diag/ rdbms/ora11g/ora11g/trace/ora11g_ora_assist.trc 1 Active Problem Count 0 1 Active Incident Count 0 11 rows selected. 2. the directory corresponding to Diag Trace is a warning log in text format, and we often get used to using the log ora11g @ RHEL53/oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g/trace $ ls-l alert_ora11g.log-rw-r ----- 1 oracle oinstall 72513 Feb 27 alert_ora11g.log 3. the directory corresponding to Diag Alert is the warning log ora11g @ RHEL53/oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g/alert $ ls-l log in XML format. xml-rw-r ----- 1 oracle oinstall 327254 Feb 27 log. xml 4. I used to define the view warning log as the same name alert to view the ora11g @ RHEL53/home/oracle $ alias alertalias alert = 'Tail-200f $ ORACLE_BASE/diag/rdbms/$ ORACLE_SID/$ ORACLE_SID/trace/alert _ $ ORACLE_SID.log '5. use The same name to view ora11g @ RHEL53/home/oracle $ alert -- The End --