RE: Truncated Listener Log/backing up?

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 11 Jan 2007 10:11:06 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08A05@EXCNYSM0A1AJ.nysemail.nyenet>

J. Dex,

Look at the set log_file command in lsnrctl. You can rename the log file on the fly. What I did in the past (on NT) was something like:

Echo "set log_file lis.temp" > lsn.cmd

Lsnrctl < lsn.cmd

Rename listener.log listener_save.log

Echo "set log_file listener.log" > lsn1.cmd

Lsnrctl < lsn1.cmd

Good Luck!

Tom

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex Sent: Thursday, January 11, 2007 9:44 AM To: oracle-l_at_freelists.org
Subject: Truncated Listener Log/backing up?

Our listener log has grown too large and I want to back it up. It is my

understanding that it can't be truncated because it is an open file. What
are other people doing to resolve this issue? This is on a W2K server where the listener is password protected and security patches have been applied. I want to add whatever type of process can be used into a script.

Fixing up the home? Live Search can help http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&loca le=en-US&source=hmemailtaglinenov06&FORM=WLMTAG

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 11 2007 - 09:11:06 CST