OpenVMS: How to delete or refresh/recycle a SQL*Net Listener log file while the Listener is active.
Last updated on SEPTEMBER 21, 2016
Applies to:Oracle Net Services - Version 188.8.131.52.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***
How can I recycle the listener log file without shutting down the listener.
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.
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