Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle Automatic Diagnostic Repository (Automatic Diagnostic Repository, ADR)     - Linux PXE unattended installation PXE-E32: TFTP OPen timeout the solution (Linux)

- Ubuntu program using the Sound Recorder (Linux)

- How to use Evernote in the Linux command line (Linux)

- MySQL innodb_table_stats table does not exist solution (Database)

- To build Spring RestTemplate use HttpClient4 (Programming)

- Not safe procedure under Linux (Linux)

- Linux System Getting Started Learning: The Linux ac command (Linux)

- Summarize small problems encountered in the use Lua (Programming)

- MySQL backup tool to back up mydumper (Database)

- It is time to upgrade your gulp 4.0 (Programming)

- To install HDRMerge 0.4.3 under ubuntu (Linux)

- Vi / Vim prompt solutions do not have permission to save time (Linux)

- Java look and feel mode (Facade mode) (Programming)

- Ubuntu prevent arp attacks (Linux)

- Spring AOP (Programming)

- Access.log Apache access log analysis and how to import it into MySQL (Server)

- PF_RING 6.0.2 compiled and installed on Redhat 6.3 x86_64 (Linux)

- CentOS Nginx achieve 3 virtual machine load balancing (Server)

- Linux kernel RCU (Read Copy Update) lock Brief (Linux)

- PostgreSQL procedural language learning (Database)

 
         
  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
Syntax:
  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 11.1.0.6.0 - Beta on Fri Feb 27 15:23:52 2009

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

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

2. help show alert command help documentation
adrci> help

 HELP [topic]
  Available Topics:
        CREATE REPORT
        ECHO
        EXIT
        HELP
        HOST
        IPS
        PURGE
        RUN
        SET BASE
        SET BROWSER
        SET CONTROL
        SET ECHO
        SET EDITOR
        SET HOMES | HOME | HOMEPATH
        SET TERMOUT
        SHOW ALERT
        SHOW BASE
        SHOW CONTROL
        SHOW HM_RUN
        SHOW HOMES | HOME | HOMEPATH
        SHOW INCDIR
        SHOW INCIDENT
        SHOW PROBLEM
        SHOW REPORT
        SHOW TRACEFILE
        SPOOL

 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.

  Options:
    [-p < Predicate_string>]: The predicate string must be double quoted.
    The fields in the predicate are the fields:
        ORIGINATING_TIMESTAMP timestamp
        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)
        EXECUTION_CONTEXT_SEQUENCE number
        ERROR_INSTANCE_ID number
        ERROR_INSTANCE_SEQUENCE number
        MESSAGE_TEXT text (2049)
        MESSAGE_ARGUMENTS text (129)
        SUPPLEMENTAL_ATTRIBUTES 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

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

adrci>

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
Completed: ALTER DATABASE OPEN
2009-02-2714: 29: 59.158000 + 08: 00
Starting background process CJQ0
CJQ0 started with pid = 25, OS id = 3892
adrci>


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;
    NAME VALUE
    ------------------- ---------------------------
    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.
     
         
         
         
  More:      
 
- To install Git on Ubuntu systems (Server)
- Bash added to the Vi mode indicator (Linux)
- Ubuntu 15.10 / 14.04 install subtitling software Aegisub (Linux)
- ORA-04031 error appears in the solution 11.2.0.4 run utlrp.sql (Database)
- Use Aptik Battery Monitor monitoring Ubuntu laptop battery usage (Linux)
- CentOS 6.x Basic System Optimization after installation (Linux)
- How to install and configure in Ubuntu 14.10 'Weather Information Indicator' (Linux)
- C ++ free store and heap (Programming)
- Ubuntu prompt / lack of boot space solutions (Linux)
- Linux NFS FTP use (Server)
- xCAT Installation Kit (Linux)
- Some Linux networking tools you might not know (Linux)
- Zabbix configuration of SNMP (Server)
- Slow update statement Performance Analysis (Database)
- CentOS 6.5 upgrade to CentOS 7 (Linux)
- CentOS7 installation performance monitoring system (Server)
- pscp use Detailed Windows and Linux each file transfer tool (Linux)
- Use Python automatically cleared Android Engineering excess resources (Programming)
- Linux character device - a simple character device model (Linux)
- Oracle database NUMBER (x, y) data types (Database)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.