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.

  1. Open the command prompt window.
  2. Enter the following command to connect to the listener console:
    lsnrctl
  3. Use the command below to stop logging listener activity:
    set log_status off
  4. Enter the following command to exit the listener console: exit

Option 2: Edit the Listener Configuration File.

  1. Open the listener configuration file listener.ora, which is usually located in the $ORACLE_HOME/network/admin directory.
  2. 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.
  3. 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.

Leave a Reply 0

Your email address will not be published. Required fields are marked *


广告
Closing in 10 seconds
bannerAds