advertisements
_____________________________________________________________________________________________________________________
Automatic Diagnostic Repository (ADR) is introduced in Oracle 11g. ADR is a common repository location for all logs and trace files etc.
- ADR_BASE_ListenerName: This parameter is to specify the ADR location for the database where listener generates the log and trace files to the directory. ADR location is specified in “diagnostic_dest” parameter of the database. The same parameter value can be specified for the ADR_BASE_listenerName or it can be different too. The value can be any valid directory which can be accessible by oracle.
SQL> show parameter diagnostic_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string /u01/app/oracle
Sample Listener would be like this.
DBLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_DBLISTENER = /u01/app/oracle
- DIAG_ADR_ENABLED_listener: This is another parameter which enables the listener tracing. This is also an ADR parameter. By default the value for this parameter is ON. If you use specifically OFF, then it takes the non-ADR file tracing.
DIAG_ADR_ENABLED_DBLISTENR=ON
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment