RE: lsnrctl set_logging command

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 5 Oct 2006 09:15:04 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE0870A@EXCNYSM0A1AJ.nysemail.nyenet>

Joe,

As Alan said, you can use the "set log_file" command to temporarily create a new log file, rename your existing log file, and then another "set log_file" command to log back to the original log file. I did this on windows boxes to clear the file and release disk space.

Now, we set logging off on all of our servers. We turn it on when we are trying to debug a connection. To me, the listener log file is a waste - something that we rarely need to look at and just another maintenance task (renaming and archiving the files to release disk space) that I didn't want to deal with.

Hope this helps.

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 Sweetser, Joe Sent: Wednesday, October 04, 2006 5:01 PM To: oracle-l_at_freelists.org
Subject: lsnrctl set_logging command

Greetings -

Winders 2000, SP4
Oracle 8.1.7.4.1

I'm thinking about using the "lsnrctl set_logging OFF/ON" commands to rename/copy the listener.log file without taking the listener down. While researching, came across this little tidbit in Metalink Note:162675.1 (dated 11-May-2003):

Note: Disabling Oracle Net logging is not recommended and should only be

      used under particular circumstances and/or under instruction by
      Oracle Support.

Has anyone used this command and had their listener crash or know of any other reason they would say this? I don't mind not logging accesses for the minute or less it might take to copy the file somewhere else. No SOX worries on this particular database/server.

Thanks,
-joe

http://www.peaceaday.com
--

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

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 05 2006 - 08:15:04 CDT