QUESTION NO: 394
Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?
A. The default value is the value of the environment variable $ORACLE_HOME; if $ORACLE_HOME isn't set,then the default is set to $ORACLE_BASE.
B. The default value is the value of the environment variable$ORACLE_BASE; if $ORACLE_BASE isn't set,then it is set to $ORACLE_HOME.
C. DIAGNOSTIC_DEST is always equal to $ORACLE_HOME.
D. DIAGNOSTIC_DEST is always equal to $ORACLE_BASE.
【题目示意】
此题考查有关于DIAGNOSTIC_DEST的相关知识。
【解析】
DIAGNOSTIC_DEST
Property | Description |
Parameter type | String |
Syntax | DIAGNOSTIC_DEST = { pathname | directory } |
Default value | Derived from the value of the $ORACLE_BASE environment variable. If $ORACLE_BASE is not set, then derived fromORACLE_BASE as set by the Oracle Universal Installer. If ORACLE_BASE is not set, then $ORACLE_HOME/rdbms/log is used. |
Modifiable | ALTER SYSTEM |
Basic | No |
Oracle RAC | This parameter can be set on each instance. Oracle recommends that each instance in a cluster specify aDIAGNOSTIC_DEST directory location that is located on shared disk and that the same value for DIAGNOSTIC_DEST be specified for each instance. |
【实验】
1)在有环境变量$ORACLE_BASE时:
SYS@ENMOEDU > show parameter DIAGNOSTIC_DEST
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string /u01/app/oracle
这个参数的缺省值和环境变量ORACLE_BASE有关:
如果设置了 ORACLE_BASE 则 DIAGNOSTIC_DEST = $ORACLE_BASE
如果未设置 ORACLE_BASE ,则 DIAGNOSTIC_DEST = $ORACLE_HOME/rdbms/log
【小结】
环境变量设置了ORACLE_BASE,则DIAGNOSTIC_DEST的默认值就是ORACLE_BASE,因此选择B
【答案】 B
相关参考
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams078.htm#REFRN10280
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29435844/viewspace-1078505/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29435844/viewspace-1078505/