1Z0-082 practice question 13 of 25

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

Full set: 142 questions
Answer options
A: The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
B: The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
C: It supports diagnostics for Automatic Storage Management (ASM) Correct answer
D: It supports diagnostics for Oracle Clusterware Correct answer
E: It is held inside an Oracle database schema
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 system-wide, file-based repository for managing Oracle product diagnostic data. It is located outside of the database itself, enabling access for troubleshooting even when the database is unavailable. ADR provides a unified directory structure and tools for collecting and analyzing diagnostic data from multiple components. This includes the Oracle Database instance, Automatic Storage Management (ASM), and Oracle Clusterware. Each component instance has its own home directory within the ADR base location where it stores its diagnostic data, such as trace files, dumps, and the alert log.

Why Incorrect

A. The default ADR base is $ORACLEHOME/log if DIAGNOSTICDEST and ORACLEBASE are not set, not $ORACLEHOME/rdbms/admin.
B. The default ADR base is $ORACLEHOME/log if DIAGNOSTICDEST and ORACLEBASE are not set, not $ORACLEHOME/dbs.
E. ADR is a file-based repository on the operating system's file system, not a schema object within the Oracle database.

References

1. Oracle Database Administrator's Guide

19c

Chapter 10

"Managing Diagnostic Data"

Section "About the Automatic Diagnostic Repository". It states

"ADR is a file-based repository... It has a unified directory structure... for multiple instances and for multiple Oracle products... For example

in an Oracle Real Application Clusters environment with Oracle ASM

ADR can contain diagnostic data for a database instance

an Oracle ASM instance

and an Oracle Clusterware instance."

2. Oracle Database Concepts

19c

Chapter 8

"Oracle Database Architecture"

Section "Diagnosability Infrastructure". It specifies the ADR base location logic: DIAGNOSTICDEST parameter

then ORACLEBASE environment variable

and finally $ORACLEHOME/log if neither is set.

Scroll to Top