ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Online Recycling the listener.log File

Online Recycling the listener.log File

原创 Linux操作系统 作者:annnnna 时间:2009-09-11 11:07:18 0 删除 编辑

As the  listener.log  file grows, the DBA will want to either remove or rename this log file. Most DBAs simply stop the TNS listener process, rename (or remove) the file, then restart the TNS listener process. This can, however, will stop users attempting to connect while the listener process is down.

 

Well, here is a solution for renaming (or removing) the  listener.log  file without having to stop and start the TNS listener process under either Windows or UNIX:

  

Windows

C:\> cd \oracle\ora92\network\log
C:\oracle\ora92\network\log> lsnrctl set log_status off
C:\oracle\ora92\network\log> rename listener.log listener.old
C:\oracle\ora92\network\log> lsnrctl set log_status on

 

UNIX

%  cd /u01/app/oracle/product/9.2.0/network/log
%  lsnrctl set log_status off
%  mv listener.log listener.old
%  lsnrctl set log_status on

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22473175/viewspace-614428/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 点名
请登录后发表评论 登录
全部评论

注册时间:2009-09-04

  • 博文量
    23
  • 访问量
    12448