Automatic Diagnostic Repository
================================
ADR ( In Oracle 11g)
========
ADR (Automatic Diagnostic Repository) is part of the Oracle database's fault diagnosability
infrastructure, first introduced with Oracle 11g, to reduce time for resolving
problems (round trip time between DBA's and Oracle Support).
DBA's can change the ADR directory by changing the DIAGNOSTIC_DEST initialization parameter.
The following subdirectories are present in the ADR home directory:
alert - The XML formatted alert log file (called log.xml)
trace - files and text alert.log file
cdump - core files
cmd> ADRCI
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> show base
ADR base is "d:\oracle11g_app_upgrade\era-1"
adrci>
adrci>
adrci> show incdir
ADR Home = d:\oracle11g_app_upgrade\era-1\diag\rdbms\beftn\beftn:
*************************************************************************
adrci>
adrci> show report
DIA-48415: Syntax error found in string [show report
] at column [12]
adrci> show alert
ADR Home = d:\oracle11g_app_upgrade\era-1\diag\rdbms\beftn\beftn:
*************************************************************************
Output the results to file: c:\docume~1\era-1\locals~1\temp\alert_4316_3868_beft
n_1.ado
'vi' is not recognized as an internal or external command,
operable program or batch file.
adrci>
adrci>
adrci>
ADRCI :=
=============================
(Automatic Diagnostic Repository Command Interface) is a command line utility of ADR
that ships with the Oracle database software.
Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Sunday, June 6, 2010
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
-
4096 Columns3 weeks ago
-
-
-
-
-
-
Oracle Cloud & Third party tools4 years ago
-
-
-
Moving Sideways8 years ago
-
Upcoming Events...10 years ago
-
No comments:
Post a Comment