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 APRIL 14, 2022
Applies to:Oracle Net Services - Version 220.127.116.11.0 to 10.2.0.4.0 [Release 8.1.7 to 10.2]
HP OpenVMS Itanium
HP OpenVMS Alpha
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document