| General |
| Directory Structure |
 |
| Queries |
set linesize
121
col value format a75
SELECT *
FROM gv$diag_info; |
| |
| ADRCI |
Purpose |
The ADR Command Interpreter (ADRCI) is a command-line tool that you use to manage Oracle Database diagnostic data.
ADRCI is a command-line tool that is part of the fault diagnosability infrastructure introduced in Oracle Database Release 11g. ADRCI enables:
- Viewing diagnostic data within the Automatic Diagnostic Repository
(ADR).
- Viewing Health Monitor reports.
- Packaging of incident and problem information into a zip file for transmission to Oracle Support.
Diagnostic data includes incident and problem descriptions, trace files, dumps, health monitor reports, alert log entries, and more.
ADRCI has a rich command set, and can be used in interactive mode or within scripts. In addition, ADRCI can execute scripts of ADRCI commands in the same way that SQL*Plus executes scripts of SQL and PL/SQL commands.
ADR data is secured by operating system permissions on the ADR directories, hence there is no need to log in to ADRCI.
|
|
CREATE REPORT
|
create report <report_type> <report_id>
|
SELECT run_id, name, check_name, run_mode, status, error_number
FROM gv$hm_run;
adrci> set homepath diag\rdbms\orabase\orabase
adrci> create report hm_run HM_RUN_1
adrci> show report hm_run hm_run_1
|
|
ECHO
|
echo <ON | OFF>
|
ardci> echo on
ardci> echo off
|
|
EXIT
|
exit
|
$ ardrci
adrci> exit
|
|
HELP
|
help
|
|
adrci> help
|
|
HOST
|
host
|
$ ardrci
adrci> host
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
-- then exits back to the command prompt
|
|
IPS SHOW
|
ips show incidents package pkg_id
|
|
adrci> ips show incidents package 3
|
|
IPS UNPACK
|
ips unpack file file_name [into path]
|
adrci> ips unpack file /home/oracle/ORA603_20060906165316_COM_1.zip
into /tmp/newadr
|
|
PURGE
|
purge [[-i {id1 | start_id end_id}] [-age mins]
[-type {ALERT|INCIDENT|TRACE|CDUMP|HM}]
|
adrci> purge -i 123 456
adrci> purge -age 60 -type incident
|
|
QUIT
|
quit
|
$ ardrci
adrci> quit
|
RUN
|
run script_name
@ script_name
@@ script_name
|
-- need to create a demo script
here
adrci> run uwadrscript
|
|
SET BASE
|
set base base_str
|
|
adrci> set base
/apps/oracle/product
|
|
SET BROWSER
|
set browser browser_program
|
|
adrci> set browser
firefox
|
|
SET CONTROL
|
set control (<SHORTP_POLICY | LONGP_POLICY> = value, ...)
|
|
adrci> set control (SHORTP_POLICY = 360)
|
|
SET ECHO
|
set echo <ON | OFF>
|
|
adrci> set echo off
|
|
SET EDITOR
|
set editor editor_program
|
|
adrci> set editor vi
|
|
SET HOME
|
|
|
adrci> set home
|
|
SET HOMES
|
|
|
adrci> set homes
|
|
SET HOMEPATH
|
set homepath homepath_str1 [homepath_str2] [...]
|
adrci> show homepath
adrci> set homepath diag\rdbms\orabase\orabase
adrci> show homepath
|
|
SET TERMOUT
|
termout <ON | OFF>
|
adrci> set termout on
adrci> set termout off
|
SHOW ALERT
|
show alert [-p predicate_string] [-tail [num] [-f]] [-term]
[-file alert_file_name]
|
$ adrci exec="show homes; show incident"
adrci> show alert
Choose the alert log from the following homes to view:
1. diag\client\user_unknown\host_411310321_11
2. diag\rdbms\orabase\orabase
3. diag\tnslsnr\perrito2\listener
Q: to quit
Q
$ adrci
adrci> set home diag\rdbms\orabase\orabase
adrci> show alert
|
|
SHOW BASE
|
show base
|
adrci> show base
ADR base is "c:\oracle\product"
|
|
SHOW CONTROL
|
show control
|
adrci> set homepath diag\rdbms\orabase\orabase
adrci> show control
|
|
SHOW HM_RUN
|
show hm_run [-p predicate_string]
|
|
adrci> show hm_run
|
|
SHOW HOME
|
show home
|
|
adrci> show home
|
|
SHOW HOMES
|
show homes
|
|
adrci> show homes
|
|
SHOW HOMEPATH
|
show homepath
|
|
adrci> show homepath
|
|
SHOW INCDIR
|
show incdir [id | id_low id_high]
|
|
adrci> show incdir
|
|
SHOW INCIDENT
|
show incident -p predicate_string [-mode {BASIC|BRIEF|DETAIL}]
[-orderby field1, field2, ...] [ASC|DSC]
|
|
adrci> show incident
|
|
SHOW PROBLEM
|
show problem [-p predicate_string] [-last num | -all]
[-orderby field1, field2, ...] [ASC|DSC]]
|
|
adrci> show problem
|
|
SHOW REPORT
|
show report report_type run_name
|
-- need to define a single home
conn / as sysdba
SELECT run_id, name, check_name, run_mode, status, error_number
FROM gv$hm_run;
adrci> set homepath diag\rdbms\orabase\orabase
adrci> show report hm_run hm_run_1
|
|
SET TRACEFILE
|
show tracefile [file1 file2 ...] [-rt | -t] [-i inc1 inc2 ...]
[-path path1 path2 ...]
|
adrci> show tracefile %mmon%
-rt
adrci> show tracefile -i 1 4 -path diag/rdbms/orabase/orabase
|
|
SPOOL
|
SPOOL filename [[APPEND] | [OFF]]
spool file_name_and_path [<APPEND | OFF>]
|
adrci> spool c:\temp\test.txt
adrci> spool off
|
| |
| Demo |
|
ADRCI Demo
|
SQL> conn / as sysdba
SQL> desc gv$hm_run
SQL> select run_id, name, check_name, run_mode, status, error_number
from gv$hm_run;
|