QUESTION 6

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.

Oracle OCP认证考试题库解析052-6_Oracle 11g OCP题库解析 

 

What is the location of the alert_orcl.log file?

 

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

 

Correct Answer: F

 

Explanation/Reference:

 

ADR目录规范: $ORACLE_BASE/diag/rdbms/db_name/SID/

 

可通过数据字典v$diag_info查询:

 

SYS@ENMOEDU> select name,value from v$diag_info;

 

NAME             VALUE

---------------------  ---------------------------------------------------------------------------------------------------

Diag Enabled    TRUE

 

ADR Base       /u01/app/oracle

 

ADR Home      /u01/app/oracle/diag/rdbms/enmoedu/ENMOEDU

 

Diag Trace         /u01/app/oracle/diag/rdbms/enmoedu/ENMOEDU/trace

 

Diag Alert         /u01/app/oracle/diag/rdbms/enmoedu/ENMOEDU/alert

 

Diag Incident      /u01/app/oracle/diag/rdbms/enmoedu/ENMOEDU/incident

 

Diag Cdump       /u01/app/oracle/diag/rdbms/enmoedu/ENMOEDU/cdump

 

Health Monitor    /u01/app/oracle/diag/rdbms/enmoedu/ENMOEDU/hm

 

Default Trace File   /u01/app/oracle/diag/rdbms/enmoedu/ENMOEDU/trace/

                 /ENMOEDU_ora_3482.trc

 

Active Problem Count   0

 

Active Incident Count    0

 

更多题库解析,敬请关注:http://ke.qq.com/cgi-bin/courseDetail?course_id=36323