Purpose of ADR_BASE_Listener & DIAG_ADR_ENABLED_listener : Oracle 11gR1 Listener ADR Parameter

Automatic Diagnostic Repository (ADR) is introduced in Oracle 11g. ADR is a common repository location for all logs and trace files etc. 

  1. 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


  1. 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.

DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google