Database Networking (MOSC)

MOSC Banner

Listener Log: Manage the size of this log file to save time and trouble!

edited Feb 16, 2020 8:00AM in Database Networking (MOSC)

Add the maintenance of the listener log size (text, not XML) to the list of  your routine DBA tasks.

The XML formatted listener logs are conveniently rolled over at 10MB.  Unfortunately, the text file logs
grow (and grow) until they can cause serious issues.  Furthermore, when troubleshooting
a listener problem, uploading these logs to support can become virtually impossible.

Determine the location of the text or flat file logs by issuing lsnrctl status:

LSNRCTL>status <your listener name>

You'll see the XML log location in the status output similar to this:

$ORACLE_BASE/diag/tnslsnr/<your_host>/<listener_name>/alert/*.xml

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center