In oracle listener log file has been increasing day by day it will effect on the performance of database.
We can stop listener logging , follow the below steps
$lsnrctl
lsnrctl> set log_status off
The above command will stop the logging temporarly upto listener restart, when you restart listener then it will start logging, for permenantly stop listener logging
place LISTENER_LOGGING = OFF in listener.ora file
listener logfile location in oracle 10g : $ORACLE_HOME/network/log/listener.log
listener logfile location in oracle 11g : /u01/app/oracle/diag/tnslsnr//listener/trace/listener.log
We can stop listener logging , follow the below steps
$lsnrctl
lsnrctl> set log_status off
The above command will stop the logging temporarly upto listener restart, when you restart listener then it will start logging, for permenantly stop listener logging
place LISTENER_LOGGING = OFF in listener.ora file
listener logfile location in oracle 10g : $ORACLE_HOME/network/log/listener.log
listener logfile location in oracle 11g : /u01/app/oracle/diag/tnslsnr//listener/trace/listener.log
No comments:
Post a Comment