Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Oracle Automatic Diagnostic Repository (Automatic Diagnostic Repository, ADR)     - RHEL 5.7 Yum configure local source [Errno 2] No such file or directory (Linux)

- MySQL DATE_FORMAT () function (Database)

- Linux CPU Monitoring Index (Linux)

- IPTABLES configuration steps under Linux (Linux)

- Ubuntu uses conky add desktop control (Linux)

- Linux 101 hack book reading notes (Linux)

- Ubuntu 14.04 running ASP.NET Configuration Mono + Jexus (Server)

- Linux serial debugging tools xgcom install (Linux)

- Linux virtual machine settings network, hostname ssh access (Linux)

- Comparison of one-time transaction and CTE insert data (Database)

- Linux, modify the hostname (Linux)

- Linux boot process and run level (Linux)

- grep command usage (Linux)

- Upgrading KDE Plasma 5.3 in Ubuntu 15.04 (Linux)

- Java and C / C ++ data conversion when network communication (Programming)

- Simple security measures to reinforce the Linux kernel (Linux)

- Android Studio Clear Project or Rebuild Project Error (Linux)

- Linux use additional rights (Linux)

- Axel install plug under CentOS 5/6 acceleration yum downloads (Linux)

- OpenSIPS offline messaging feature set (Server)

  Oracle Automatic Diagnostic Repository (Automatic Diagnostic Repository, ADR)
  Add Date : 2018-11-21      
  Oracle 11G in ADR description:

ADRCI the oracle Log Viewer

In Oracle's 11g version, the location alert file changes, while Oracle provides a command-line tool ADRCI, it can be very convenient to view the database anomalies occur. Use the following to show you what ADRCI (ADR Command Interface) to view the alert log method in Oracle 11g.

1. Go to the command line mode adrci
ora11g @ RHEL53 / home / oracle $ which adrci
/ Oracle / u01 / app / oracle / product / 1101 / db / bin / adrci
ora11g @ RHEL53 / home / oracle $ adrci -help
  adrci [-help] [script = script_filename]
        [Exec = "one_command [; one_command; ...]"]

Options Description (Default)
-------------------------------------------------- ----
script script. file name (None)
help help on the command options (None)
exec exec a set of commands (None)
-------------------------------------------------- ----

ora11g @ RHEL53 / home / oracle $ adrci

ADRCI: Release - Beta on Fri Feb 27 15:23:52 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ADR base = "/ oracle / u01 / app / oracle"

2. help show alert command help documentation
adrci> help

 HELP [topic]
  Available Topics:
        SET BASE
        SET ECHO
        SET EDITOR
        SHOW ALERT
        SHOW BASE
        SHOW HM_RUN

 There are other commands intended to be used directly by Oracle, type
 "HELP EXTENDED" to see the list

adrci> help show alert

  Usage: SHOW ALERT [-p < predicate_string>] [-term]
                    [[-tail [Num] [-f]] | [-file < alert_file_name>]]
  Purpose: Show alert messages.

    [-p < Predicate_string>]: The predicate string must be double quoted.
    The fields in the predicate are the fields:
        NORMALIZED_TIMESTAMP timestamp
        ORGANIZATION_ID text (65)
        COMPONENT_ID text (65)
        HOST_ID text (65)
        HOST_ADDRESS text (17)
        MESSAGE_TYPE number
        MESSAGE_LEVEL number
        MESSAGE_ID text (65)
        MESSAGE_GROUP text (65)
        CLIENT_ID text (65)
        MODULE_ID text (65)
        PROCESS_ID text (33)
        THREAD_ID text (65)
        USER_ID text (65)
        INSTANCE_ID text (65)
        DETAILED_LOCATION text (161)
        UPSTREAM_COMP_ID text (101)
        DOWNSTREAM_COMP_ID text (101)
        EXECUTION_CONTEXT_ID text (101)
        ERROR_INSTANCE_ID number
        MESSAGE_TEXT text (2049)
        MESSAGE_ARGUMENTS text (129)
        SUPPLEMENTAL_DETAILS text (129)
        PROBLEM_KEY text (65)

    [-tail [Num] [-f]]: Output last part of the alert messages and
    output latest messages as the alert log grows. If num is not specified,
    the last 10 messages are displayed. If "-f" is specified, new data
    will append at the end as new alert messages are generated.

    [-term]: Direct results to terminal If this option is not specified,.
    the results will be open in an editor.
    By default, it will open in emacs, but "set editor" can be used
    to set other editors.

    [-file < Alert_file_name>]: Allow users to specify an alert file which
    may not be in ADR. < alert_file_name> must be specified with full path.
    Note that this option can not be used with the -tail option

    show alert
    show alert -p "message_text like '% incident%'"
    show alert -tail 20


3. Use the show alert log directory lists each directory, enter the number 4, the system will automatically call the vi editor to view the database alert log
adrci> show alert

Choose the alert log from the following homes to view:

1: diag / tnslsnr / RHEL53 / listener
2: diag / clients / user_unknown / host_411310321_11
3: diag / clients / user_oracle / host_2175824367_11
4: diag / rdbms / ora11g / ora11g
Q: to quit

Please select option: 4

4. Another way to view that assign specific homepath then use the "show alert -tail 15" 15 row view corresponding to the log file after
adrci> show homepath
ADR Homes:
diag / tnslsnr / RHEL53 / listener
diag / clients / user_unknown / host_411310321_11
diag / clients / user_oracle / host_2175824367_11
diag / rdbms / ora11g / ora11g
adrci> set homepath diag / rdbms / ora11g / ora11g
adrci> show alert -tail 15
2009-02-2714: 25: 05.036000 + 08: 00
Starting background process SMCO
SMCO started with pid = 21, OS id = 3855
Starting background process FBDA
FBDA started with pid = 22, OS id = 3857
replication_dependency_tracking turned off (no async multimaster replication found)
2009-02-2714: 25: 07.246000 + 08: 00
Starting background process QMNC
QMNC started with pid = 23, OS id = 3859
2009-02-2714: 25: 17.325000 + 08: 00
db_recovery_file_dest_size of 4096 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
2009-02-2714: 25: 33.727000 + 08: 00
2009-02-2714: 29: 59.158000 + 08: 00
Starting background process CJQ0
CJQ0 started with pid = 25, OS id = 3892

ADR structures and locations:
  Diagnostic_dest initialization parameter specifies the root directory of ADR. Even if you ignore the initialization parameters. oracle will create ADR.
If you set the ORACLE_BASE environment variable is diagnostic_dest default is the directory. If you do not set the ORACLE_BASE variable, the parameter value is $ ORACLE_HOME / log directory.
  ADR store diagnostic data for all oracle products. ADR for each instance of a product and its oracle assign a separate home directory. It is therefore an ADR home directory contains multiple directories.
  Each ADR home directory is stored in a file for each diagnosis or other oracle database instance or product components. Its directory structure is as follows:
  ADR_base / diag / product_type / product_id / instance_id /
  For example, a diagnostic_dest initialization parameter is / u05 / app / oracle. So sid oracle database for a prod1 home directory would look like:
  / U05 / app / oracle / diag / rdbms / prod1 / prod1 /
  In a lot of the ADR home directory has a subdirectory:

      alert: an example of the alarm log file (xml format).
      cdump: core file.
      hm: Health inspection reports.
      incident: every event a subdirectory, which contains all the trace dump file.
      incpkg: Event package you create, oracle support for distributed use.
      ir: contains an instance of the event report.
      trace: the trace file is stored answer.
    You can query the directory and its location through the view v $ diag_info:
    SQL> select name, value from v $ diag_info;
    ------------------- ---------------------------
    Diag Enabled TRUE
    ADR Base / u01 / app / oracle
    ADR Home / 01 / app / oracle / diag / rdbms / prod / prod1
    Diag Trace / u01 / app / oracle / diag / rdbms / prod / prod1 / trace
    Diag Alert / u01 / app / oracle / diag / rdbms / prod / prod1 / alert
    Diag Incident / u01 / app / oracle / diag / rdbms / prod / prod1 / incident
    Diag Cdump / u01 / app / oracle / diag / rdbms / prod / prod1 / cdump
    Health Monitor / u01 / app / oracle / diag / rdbms / prod / prod1 / hm
    Default Trace File / u01 / app / oracle / diag / rdbms / prod / prod1 /
                            trace / eleven_ora_9417.trc
    Active Problem Count 3
    Active Incident Count 8

As you can see, the view v $ diag_info included in the number of issues and events.
For example, use the following command to view all ORA- errors:
adrci> set homepath diag / rdbms / rac / rac
adrci> set editor vi
adrci> show alert -p "message_text like '% ORA-%'"
ADR Home = / home / oracle / diag / rdbms / rac / rac:
************************************************** ***********************
Output the results to file: /tmp/alert_10191_1638_rac_1.ado

2012-03-2920: 56: 12.266000 + 08: 00
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL ...
2012-03-2920: 56: 27.810000 + 08: 00
Errors in file /home/oracle/diag/rdbms/rac/rac/trace/rac_ora_10453.trc:
ORA-00313: ??????? 1 (???? 1) ???
ORA-00312: ???? 1 ?? 1: '/home/oracle/oradata/rac/redo01.log'

After exiting the same as the vi editor, screen output results can be found in the file /tmp/alert_10191_1638_rac_1.ado in. For this analysis,
This shows that the characteristics and unix grep | ORA- command is very different, because the latter can only output error line, but the time line of the error has occurred can not be displayed, and show alert is displayed simultaneously errors occurred.

5. Summary
  Use ADRCI command can be good for each log file directory centralized view, can effectively improve work efficiency.
- Rely on IP chain established Linux firewall (Linux)
- Linux command line ten magic usage (Linux)
- CentOS installation of the ftp (Linux)
- How to find out a Unix system library files are 32-bit or 64-bit (Linux)
- Configuring Eclipse Note Templates (Linux)
- Install KVM on Ubuntu and build a virtual environment (Linux)
- Plasma 5.4 How to install on Kubuntu 15.04 (Linux)
- Share and show your code on GitHub (Linux)
- Android components series Activity (Programming)
- RedHat Linux 6.4 installation RTL8188CUS wireless network card driver (Linux)
- The official release method to upgrade to Ubuntu 15.04 (Linux)
- CentOS7 set boot directly into the command line interface (Linux)
- Linux module mechanism of (Programming)
- The ActiveMQ JMS installation and application examples for Linux (Linux)
- Zabbix using Omsa monitor hardware information of Dell server (Server)
- Docker study notes (Server)
- Ubuntu install VMware Workstation 11 tutorials at 14.04 / 14.10 (Linux)
- Tsung first test installation (Linux)
- Linux Programming memory mapping (Programming)
- Python basis: os module on the file / directory using methods commonly used functions (Programming)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.