Brian Peasland wrote:
> Ben wrote:
>> Brian Peasland wrote:
>>>> If I delete the listener log, will it automatically be regenerated or
>>>> does the listener have to be restarted?
>>>>
>>> It will automatically be recreated.
>>>
>>> HTH,
>>> Brian
>>>
>>>
>>> --
>>> ===================================================================
>>>
>>> Brian Peasland
>>> dba_at_nospam.peasland.net
>>> http://www.peasland.net
>>>
>>> Remove the "nospam." from the email address to email me.
>>>
>>>
>>> "I can give it to you cheap, quick, and good.
>>> Now pick two out of the three" - Unknown
>>
>>
>> I just tried this on our test system and it didn't work. I moved the
>> log file out of the directory then through a client, I connected to a
>> database that was using that listener. I connected fine but the log
>> file wasn't there after I went back and checked for it.
>>
>
> Then instead of deleting the log, copy null to it:
>
> cp /dev/null listener.log
>
> This will zero out the log but will not remove it.
>
> HTH,
> Brian
If you want to do it from inside 10g you can use UTL_FILE.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Jul 28 2006 - 16:13:36 CDT
