Purging of Listener log file in Oracle Database

Introduction :

The listener is a separate database server process that runs locally on the database server or remotely on the Oracle RAC environment. When a request from the client is received, the listener first receives it and then establishes a connection between the client and the database instance.

The listener.ora file is the configuration file for a listener. It can include the protocol addresses it is accepting connection requests on, a list of the database and other services it is listening for, and control parameters used by the listener. The configuration of the listeners used by Oracle Clusterware and Oracle RAC can be modified with Server Control Utility (SRVCTL) commands or by using NETCA.

Purging of Listener log file in Oracle Database :

There are different ways to purge the listener log file in the Oracle database.  The below mentioned could be followed.

Solution 1 :

First find the location of listener log file.

Go the listener log file location and execute the below commands.

Solution 2 :

LSNRCTL>
LSNRCTL> set current_listener <listenername>
LSNRCTL> set log_status off

Login into another window and rename the log file and then return to the previous window

LSNRCTL> set log_status on

The above command will create a new and empty listener.log file which will continue logging.