Exam 1z0-082 All QuestionsBrowse all questions from this exam
Question 62

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

    Correct Answer: C, D

    The Automatic Diagnostic Repository (ADR) supports diagnostics for Automatic Storage Management (ASM) and Oracle Clusterware. The ADR is a directory structure outside of the Oracle database schema, which stores diagnostic data for various Oracle components, including the database, ASM, listener, and Oracle Clusterware. The ADR base location depends on the DIAGNOSTIC_DEST parameter or ORACLE_BASE environment variable, not on $ORACLE_HOME/rdbms/admin or $ORACLE_HOME/dbs.

Discussion
elcaso34Options: CD

I think C D. The database, Oracle Automatic Storage Management (Oracle ASM), the listener, Oracle Clusterware, and other Oracle products or components store all diagnostic data in the ADR. https://docs.oracle.com/database/121/ADMIN/diag.htm#ADMIN11260

Ekos

i agree

Sharif1Options: CD

yes elcaso34 is correct, options C and D are correct.

brolemOptions: CD

A, B - Wrong: The ADR root directory is known as the ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows: If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to SORACLE_BASE. If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to SORACLE_HOME/log. C - Correct: For example, in an Oracle Real Application Clusters environment with Oracle ASM, each database instance, Oracle ASM instance, and listener has an ADR home. D - Correct: Oracle Clusterware uses ADR and has its own Oracle home and Oracle base. E - Wrong: The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down. From <https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/diagnosing-and-resolving-problems.html#GUID-951A06EE-DDF7-4C2A-B0BB-B24418BB2E33>

elbelgounetos

The ADR root directory is known as the ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows: If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST iS set to SORACLE_BASE. If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST iS set to SORACLE_HOME/log.

nautil2Options: CD

A - false; default value for DIAGNOSTIC_DEST: If $ORACLE_BASE is not set, then derived from ORACLE_BASE as set by the Oracle Universal Installer. If ORACLE_BASE is not set, then $ORACLE_HOME/rdbms/log is used. B - false; see answer A C - true; Beginning with Oracle Database 11g and later releases, Oracle Automatic Storage Management (Oracle ASM), and other Oracle Database products or components store all diagnostic data in the ADR. D - true; Review this content to understand clusterware-specific aspects of how Oracle Clusterware uses ADR. E - false; data are not held inside an Oracle database schema Sources: A, B - Oracle documentation: 1.108 DIAGNOSTIC_DEST C - Oracle documentation: 21.2 Definitions for Oracle Database ADRC D - Oracle documentation: J Troubleshooting Oracle Clusterware

Oracle2020Options: AE

The correct answers are: A, E If this parameter is omitted or left null, then the database sets DIAGNOSTIC_DEST upon startup as follows: If environment variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE. If environment variable ORACLE_BASE is not set, then DIAGNOSTIC_DEST is set to ORACLE_HOME/log Following the url indicated by the correct answer of exam topic. We understand this is the same for Oracle 19

auwiaOptions: CD

By exclusion: A and B are wrong because the default path is ORACLE_HOME/log for this case: The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows: - If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE. - If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log. E is wrong because: The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down. ref. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/managing-diagnostic-data.html#GUID-C78CCAD4-732B-4B14-9C6B-D47AC2A99E30

RaNik69Options: CD

answer is CD

mikimiki01Options: CD

answer is C and D

danitoOptions: AD

I think A D