1Z0-052 · Question #149
You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file. View the Exhibit and…
The correct answer is F. ORACLE_BASE/diag/rdbms/orcl/orcl/trace. In Oracle's Automatic Diagnostic Repository (ADR), the alert log is stored under ORACLE_BASE/diag/rdbms/<db_unique_name>/<instance_name>/trace/.
Question
You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file. View the Exhibit and check the commands executed. What is the location of the alert_orcl.log file?
Exhibit
Options
- AORACLE_HOME/dbs
- BORACEL_HOME/rdbms
- C/u01/app/oracle/admin/orcl/adump
- D/u01/app/oracle/flash_recovery_area
- EORACLE_BASE/diag/rdbms/orcl/alert
- FORACLE_BASE/diag/rdbms/orcl/orcl/trace
How the community answered
(42 responses)- C2% (1)
- D2% (1)
- E5% (2)
- F90% (38)
Why each option
In Oracle's Automatic Diagnostic Repository (ADR), the alert log is stored under ORACLE_BASE/diag/rdbms/<db_unique_name>/<instance_name>/trace/.
ORACLE_HOME/dbs stores initialization parameter files (init.ora, spfile) and password files, not diagnostic or alert logs.
ORACLE_HOME/rdbms contains Oracle executable binaries and shared libraries, not alert log files.
This path is the audit dump destination configured by AUDIT_FILE_DEST, not the ADR alert log location.
The flash_recovery_area is the Fast Recovery Area used for backups and archived redo logs, not for ADR diagnostic logs.
The correct ADR path requires both the db_unique_name and instance_name subdirectories followed by 'trace'; this option omits the instance subdirectory and 'trace' folder, making it an invalid path.
The ADR stores alert_orcl.log at ORACLE_BASE/diag/rdbms/<db_unique_name>/<instance_name>/trace/alert_<instance>.log. For the 'orcl' instance, this path resolves to ORACLE_BASE/diag/rdbms/orcl/orcl/trace, which is exactly option F.
Concept tested: Oracle ADR alert log file location
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/diagnosing-and-resolving-problems.html
Topics
Community Discussion
No community discussion yet for this question.
