What is the method to disable listener log in Oracle 11g?
To disable the listener log in Oracle 11g, you can use one of the following two methods:
Option 1: Utilize the lsnrctl command line tool.
- Open the command prompt window.
- Enter the following command to connect to the listener console:
lsnrctl - Use the command below to stop logging listener activity:
set log_status off - Enter the following command to exit the listener console: exit
Option 2: Edit the Listener Configuration File.
- Open the listener configuration file listener.ora, which is usually located in the $ORACLE_HOME/network/admin directory.
- Locate the following line: LOG_FILE_
=listener.log. Comment out or delete that line, or change its value to a non-existent file path, for example: #LOG_FILE_ =listener.log. - Save the file and close it.
No matter which method is used, once the listener log is closed, the listener activity log will no longer be recorded.