Examine the following values of the initialization parameters in the database having the SID ORCL:
BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump
USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump
CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump
DIAGNOSTIC_DEST=
The environment variables have the following value:
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
What is the location of the Automatic Diagnostic Repository (ADR) home?
A.
/u01/app/oracle/product/11.1.0/db_1
B.
/u01/app/oracle
C.
$ORACLE_HOME/bdump
D.
$ORACLE_HOME/log
Explanation:
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.
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.
This question was simply copied over from a pre 11g version, it is not relevant, nor is it accurate here.
B is correct. diagnostic_dest overrides deprecated values. if not specified it will use oracle_base..
Pre11g version (10g) did not have diagnostic_dest so i have no clue what are you trying to say Eamon.