tag:blogger.com,1999:blog-2530682427657016426.post2911284602662144957..comments2024-03-18T22:59:35.401+01:00Comments on Marko Sutic's Database Blog: Truncating, Rotating, Flushing Listener.log fileMarko Sutichttp://www.blogger.com/profile/08926232581329666732noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-2530682427657016426.post-88108988938971988352018-10-12T09:43:50.481+02:002018-10-12T09:43:50.481+02:00Thanks for Sharing this, very useful , especially ...Thanks for Sharing this, very useful , especially all possible solution in one post :) <br /><br />Amitnoreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-71492371209257153322017-03-24T19:26:49.424+01:002017-03-24T19:26:49.424+01:00FYI, I compressed the listener.log and it went dow...FYI, I compressed the listener.log and it went down from 1 gb to 60 Mb... so it's a nice solution. thanks.jcho360https://www.blogger.com/profile/16889639256130925370noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-30480571184101478982015-02-14T11:07:19.752+01:002015-02-14T11:07:19.752+01:00Hello Steve,
you're solution also solves this...Hello Steve,<br /><br />you're solution also solves this problem.<br /><br />Now create script and automate this task - you won't have to worry about listener.log any more ;-)<br /><br />Regards,<br />MarkoMarko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-30226463685244562932015-02-13T22:12:38.053+01:002015-02-13T22:12:38.053+01:00Here is my low tech solution (for Linux) that reta...Here is my low tech solution (for Linux) that retains 500000 lines of the original file:<br /><br />tail -n 500000 listener.log >lastbit.log<br />cat lastbit.log >listener.log<br />rm lastbit.log<br /><br />In my case the file went down from 4G to 68Mb.Steve Johnsonhttps://www.blogger.com/profile/06495537241012524996noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-83584412280285187122014-10-17T23:40:35.825+02:002014-10-17T23:40:35.825+02:00Brilliant post! Hats off :)Brilliant post! Hats off :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-45610891362144479762014-08-09T10:09:36.330+02:002014-08-09T10:09:36.330+02:00Hello Peter,
do you have "ADMIN_RESTRICTIONS...Hello Peter,<br /><br />do you have "ADMIN_RESTRICTIONS_LISTENER = ON" parameter enabled in listener.ora file?<br /><br />If yes, disable it and you'll be able to execute admin commands like set_log.<br /><br />Regards,<br />MarkoMarko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-27233573453750476342014-08-08T09:36:31.624+02:002014-08-08T09:36:31.624+02:00Hi, I hate so much Oracle, it does not work for me...Hi, I hate so much Oracle, it does not work for me.. set log_file doesn't work<br /><br />LSNRCTL> set log_file listener_tmp.log<br />TNS-12508: TNS:listener could not resolve the COMMAND givenAnonymoushttps://www.blogger.com/profile/15090459115859931676noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-8752389987481073572014-05-20T23:49:29.752+02:002014-05-20T23:49:29.752+02:00Yes thank you for the information had unable to co...Yes thank you for the information had unable to connect to the oracle listener and to this log file hitting this 4gb threshold. We renamed the file and boom able to connect. Now looking for the maintenance to keep it under control. <br /><br />I can also confirm that in windows it is possible to rename the log without restarting the listener service (if your in between writes to the log of course)<br />Jamienoreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-10924315282543785382014-03-12T02:41:15.589+01:002014-03-12T02:41:15.589+01:00Very useful information.. thanksVery useful information.. thanksPankaj Hatekarhttps://www.blogger.com/profile/02268730477814883930noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-34057371410984076992013-12-11T22:39:38.718+01:002013-12-11T22:39:38.718+01:00ThanksThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-3560126508529126642013-09-11T13:13:02.574+02:002013-09-11T13:13:02.574+02:00excellent post, I found it very useful - thanksexcellent post, I found it very useful - thanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-82119071946784892852013-06-20T08:00:24.342+02:002013-06-20T08:00:24.342+02:00Hi I found your post really helpful. =)Hi I found your post really helpful. =)Anonymoushttps://www.blogger.com/profile/06451616334577316130noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-68665589046949921032013-05-03T15:50:28.443+02:002013-05-03T15:50:28.443+02:00Solution 1 works fine for me on unix systems.
Tha...Solution 1 works fine for me on unix systems.<br /><br />Thanks !Dr. Schleswig-Holsteinhttp://www.nervich.denoreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-44660971239484946572012-08-11T12:42:27.132+02:002012-08-11T12:42:27.132+02:00I have not tested flushing listener.log in Windows...I have not tested flushing listener.log in Windows environment.<br /><br />Thanks for comment ;)<br /><br />Regards,<br />MarkoMarko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-6085598192755671832012-07-31T23:16:12.988+02:002012-07-31T23:16:12.988+02:00in windows 11g you can just rename the file and or...in windows 11g you can just rename the file and oralce will create a new file. Then delete the old file. :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-42042373343515593012012-01-17T01:43:14.826+01:002012-01-17T01:43:14.826+01:00thanks - coming up first when googling "how t...thanks - coming up first when googling "how to rotate listener logs in oracle" - hello from NZAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-867597494112726732010-06-15T15:35:54.658+02:002010-06-15T15:35:54.658+02:00Hi Jack,
smart thing to do is to test everything ...Hi Jack,<br /><br />smart thing to do is to test everything before playing in production environment.<br /><br />btw, this action shouldn't impact on running Oracle processes...<br /><br />but test, test, test ;)Marko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-59332735839275838792010-06-14T12:51:59.117+02:002010-06-14T12:51:59.117+02:00Can I ask a small question : If we do the Second s...Can I ask a small question : If we do the Second solution - using LSNRCTL utility, will it impact to any Oracle process are running on the system or not ?<br />Sorry, because i'm the newcomer with Oracle database, but really need to solve this problems !Jack Võhttps://www.blogger.com/profile/13643650643637905802noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-53559897390968598372010-03-29T15:55:20.039+02:002010-03-29T15:55:20.039+02:00You're welcome Jung ;)
Best regards,
MarkoYou're welcome Jung ;)<br /><br />Best regards,<br />MarkoMarko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-68930702623317163122010-03-28T18:32:39.517+02:002010-03-28T18:32:39.517+02:00Hello!
My name is Jung Yun Han.
I've just re...Hello!<br /><br />My name is Jung Yun Han.<br /><br />I've just read this post and it's<br /><br />absolutely useful to me.<br /><br />Thanks~Daniel Hanhttps://www.blogger.com/profile/12813837986712688308noreply@blogger.com