Thinking Out Loud

September 12, 2007

Oracle 11gR1 Listener Log Location

Filed under: oracle — mdinh @ 10:42 pm

I am just getting my feet wet with 11gR1.

When I executed lsnrctl status, I get the following:

<click image to enlarge>

l1

The Listener Log File is in XML format.

Where’s the regular listener.log file?

It is located one directory above under trace.

<click image to enlarge>

l2.jpg

This all relates to the new parameter DIAGNOSTIC_DEST in 11g.

REFERENCE:

Oracle® Database Reference 11g Release 1 (11.1)

Advertisements

4 Comments »

  1. Hi,

    11g logs now reside on %ORACLE_HOME%\diag directory. The regular listener log is in %ORACLE_HOME%\diag\tnslsnr\listener\….

    Frankly, I really hate 11g’s new log dir configuration under 11g, but you can change the location of the log by specifying the LISTENER_LOG=c:\ora11g\network\log in the listener.ora and restart the Listener.

    The same applies to the alert log with DIAGNOSTIC_DEST parameter in the init.ora file, but the directory structure is still cumbersome as compared to 10g. In this case, Oracle does make it harder for DBAs.

    Hope this helps.

    Tam

    Comment by Tam Nguyen — March 16, 2009 @ 6:00 pm | Reply

  2. Tam Nguygen’s advice for the listener is wrong. When ADR is on you can not change the listener logging parameters. If you don’t want to use ADR for the listener then add

    DIAG_ADR_ENABLED_listener_name=off

    into your listener.ora and then restart the listener. The log will go back to the old location either in $OH/network/log or the directory you set with LOG_DIRECTORY_listener_name

    Comment by BC — May 27, 2009 @ 2:21 pm | Reply

    • Thank you for the clarification.

      Comment by mdinh — May 28, 2009 @ 11:55 am | Reply

  3. Just wanted to provide an update and share listener.ora configuration for 2 listeners on the same box with different ports. 1 listener is listening for 2 databases.

    LISTENER_DB01 =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS=(PROTOCOL=tcp)(HOST=bumblebee)(PORT=1531)(SEND_BUF_SIZE=11625000)(RECV_BUF_SIZE=11625000))
    )
    )
    )

    LISTENER_DB02 =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS=(PROTOCOL=tcp)(HOST=bumblebee)(PORT=1532)(SEND_BUF_SIZE=11625000)(RECV_BUF_SIZE=11625000))
    )
    )
    )

    SID_LIST_LISTENER_DB01 =
    (SID_LIST =
    (SID_DESC =
    (SDU=32767)
    (SID_NAME = DB01)
    (ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1)
    )
    )

    SID_LIST_LISTENER_DB02 =
    (SID_LIST =
    (SID_DESC =
    (SDU=32767)
    (SID_NAME = DB02)
    (ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1)
    )
    (SID_DESC =
    (SDU=32767)
    (SID_NAME = DB03)
    (ORACLE_HOME=/u01/app/oracle/product/11.2.0.2/dbhome_1)
    )
    )

    SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER_DB01=OFF
    SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER_DB02=OFF
    LOGGING_LISTENER_DB01=OFF
    LOGGING_LISTENER_DB02=OFF
    LOG_DIRECTORY_LISTENER_DB01=/home/oracle/tnslsnr
    LOG_DIRECTORY_LISTENER_DB02=/home/oracle/tnslsnr
    DIAG_ADR_ENABLED_LISTENER_DB01=OFF
    DIAG_ADR_ENABLED_LISTENER_DB02=OFF
    INBOUND_CONNECT_TIMEOUT_LISTENER_DB01=120
    INBOUND_CONNECT_TIMEOUT_LISTENER_DB02=120

    Comment by mdinh — October 10, 2012 @ 3:05 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: