1Z0-182 practice question 15 of 15

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

Full set: 94 questions
Answer options
A: It is held inside an Oracle database schema.
B: The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set.
C: It supports diagnostics for Automatic Storage Management (ASM). Correct answer
D: It supports diagnostics for Oracle Clusterware. Correct answer
E: The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set.
Correct Answer:
C. It supports diagnostics for Automatic Storage Management (ASM).; D. It supports diagnostics for Oracle Clusterware.
Explanation

The Automatic Diagnostic Repository (ADR) is a unified, file-system-based repository for managing diagnostic data from various Oracle products and components. It is designed to be a central location for logs, traces, and other diagnostic information. Crucially, its scope extends beyond just the Oracle Database to include other key components of the Oracle stack, such as Automatic Storage Management (ASM) and Oracle Clusterware. This consolidation simplifies diagnostic data collection and analysis across the entire environment.

Why Incorrect

A. ADR is a directory structure in the server's file system, not a schema or object within the Oracle database itself.
B. If DIAGNOSTICDEST and ORACLEBASE are not set, the ADR base defaults to $ORACLEHOME/log, not $ORACLEHOME/rdbms/admin.
E. If DIAGNOSTICDEST and ORACLEBASE are not set, the ADR base defaults to $ORACLEHOME/log, not $ORACLEHOME/dbs.

References

Oracle Database Administrator's Guide 23ai, Chapter 19: Managing Diagnostic Data, Section: "About the Automatic Diagnostic Repository". It states, "The database, Oracle Automatic Storage Management (Oracle ASM), Oracle Clusterware, Oracle GoldenGate, and other Oracle products or components store all diagnostic data in the ADR." This confirms C and D.

Oracle Database Administrator's Guide 23ai, Chapter 19: Managing Diagnostic Data, Section: "ADR Location". It specifies the ADR base location logic: "If environment variable ORACLEBASE is not set, DIAGNOSTICDEST is set to $ORACLEHOME/log." This refutes B and E.

Scroll to Top