OpenVMS: How to delete or refresh/recycle a SQL*Net Listener log file while the Listener is active. (Doc ID 739530.1)

How can I recycle the listener log file without shutting down the listener.

Background:

Over time, a listener log file will grow in size.

Left alone, it will grow to 2GB on OpenVMS (4GB on other platforms)

Once this file size has been reached, no additional records will be written to the log file.

While this does not impact SQL*Net connections, it can hinder research into SQL*Net related problems.

Even if the Listener log file has not reached its maximum size of 2GB, when problems are encountered, reviewing a large log file presents its own problems.

Regularly refreshing the log file (say once per month) resolves all of the above issues.

This document provides two methods that can be used to refresh the Listener log file without stopping the listener and hence without service interruption.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.