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, a Georgia Tech graduate Senior Database Engineer/Data Architect based in Atlanta, USA, is an Oracle OCP DBA and Developer, Certified Cloud Architect Professional, and OCI Autonomous Database Specialist. With extensive expertise in database design, configuration, tuning, capacity planning, RAC, DG, scripting, Python, APEX, and PL/SQL, he combines technical mastery with a passion for innovation. Notably, Halim secured 16th place worldwide in PL/SQL Challenge Cup Playoff on the year 2010.
Sunday, June 6, 2010
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
ASSM states3 weeks ago
-
UKOUG Discover 20241 month ago
-
-
-
-
-
-
-
-
Moving Sideways8 years ago
-
-
Upcoming Events...11 years ago
-
No comments:
Post a Comment