What is the location of the alert_orcl.log file?

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?
See the Exhibit:

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?
See the Exhibit:

A.
ORACLE_HOME/dbs

B.
ORACEL_HOME/rdbms

C.
/u01/app/oracle/admin/orcl/adump

D.
/u01/app/oracle/flash_recovery_area

E.
ORACLE_BASE/diag/rdbms/orcl/alert

F.
ORACLE_BASE/diag/rdbms/orcl/orcl/trace

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

Prince

Prince

Exhibit not showing

Reply

jean

jean

Typical installations will have the ADR_BASE set to the ORACLE_BASE. For example, a database called “orcl” might have a structure like the following.

/u01/app/oracle/diag/rdbms/orcl/orcl/alert
/u01/app/oracle/diag/rdbms/orcl/orcl/cdump
/u01/app/oracle/diag/rdbms/orcl/orcl/hm
/u01/app/oracle/diag/rdbms/orcl/orcl/incident
/u01/app/oracle/diag/rdbms/orcl/orcl/trace

the flash recovery area feature lets you set up a location on disk where the database can create and manage a variety of backup and recovery-related files on your behalf.

Reply

ahmed

ahmed

Oracle will write the alert.log file to the directory as specified by the BACKGROUND_DUMP_DEST parameter. If this parameter is not set, the alert.log will be created in a directory below the value of the DIAGNOSTIC_DEST parameter: DIAGNOSTIC_DEST/diag/rdbms/DB_NAME/ORACLE_SID/trace. If this later parameter is not set, the alert.log file is created in the ORACLE_HOME/rdbms/trace directory.

source : orafaq

Reply