11g warning log

Source: Internet
Author: User

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 --

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.