Location of alert logs in Oracle 11g

Oracle 11g Alert Log location Oracle 11g Alert Log location 1. Obtain ADR-related information by querying the v $ diag_info View

ADR(Automatic Diagnostic Repository)--> A a file-based hierarchical data store for managing diagnostic information, including network tracing and logging.

 

Code:

sys@ora11g>select * from v$diag_info;INST_ID NAME VALUE------- ---------------------- ----------------------------------------------1 Diag Enabled TRUE1 ADR Base /oracle/u01/app/oracle1 ADR Home /oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g1 Diag Trace /oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g/trace1 Diag Alert /oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g/alert1 Diag Incident /oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g/incident1 Diag Cdump /oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g/cdump1 Health Monitor /oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g/hm1 Default Trace File /oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g/trace/ora11g_ora_3968.trc1 Active Problem Count 01 Active Incident Count 011 rows selected.

 

2. The directory corresponding to Diag Trace is warning logs in text format, and the log code we often use:

ora11g@RHEL53 /oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g/trace$ls -l alert_ora11g.log-rw-r----- 1 oracle oinstall 72513 Feb 27 14:29 alert_ora11g.log

 

3. The directory corresponding to Diag Alert is the warning Log Code in XML format:

ora11g@RHEL53 /oracle/u01/app/oracle/diag/rdbms/ora11g/ora11g/alert$ls -l log.xml-rw-r----- 1 oracle oinstall 327254 Feb 27 14:29 log.xml

 

4. I used to define the view warning log as the same name as alert and directly view the code on the operating system:

ora11g@RHEL53 /home/oracle$alias alertalias alert='tail -200f $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace/alert_$ORACLE_SID.log'

 

5. view the Code with the same name:

ora11g@RHEL53 /home/oracle$alert