Being DBA we all are aware that Oracle Database makes a connection with a client with the help of listener. Oracle provides the facility to have look over the status of Oracle listen. Being a part of IT we must be aware that 24*7 We require database live but due to some unfortunate conditions database lose its connection. It happens lots of time to clear the old entries of the old listener.
In this blog, we are going to have look how to purge listener log data.


How to Purge Listener Log Data?

Solution 1:

Solution 2:

If you want to change the current listener then execute the following command:

From another window rename the log file, then return to the previous window.

This will create a new and empty listener.log file which will continue logging.

Today’s thought

When you innovate, you’ve got to be prepared for everyone telling you you’re nuts. Larry Ellison


About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.