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

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Net Services - Version 8.1.7.0.0 to 10.2.0.4.0 [Release 8.1.7 to 10.2]
HP OpenVMS Itanium
HP OpenVMS Alpha
***Checked for relevance on 18-Sep-2013***

Goal

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms