Re: Listener.log....writing to renamed file

MTS is quite stable from 8.0.5 up. One persistent limitation is the fact that SQL*Trace output for a session is scattered across the various shared server processes. Oracle's developers say that they eventually will provide a solution for this limitation, but it is not forthcoming in 9.x.

As of 8.0.x, PMON will periodically attempt to re-register dispatchers with listeners, so you don't have to restart the instance after restarting a listener. In 9.x, there is a "re-register right now" command (alter system ?) so that you don't have to wait around for PMON to get around to it.

As for the listener log, you can just truncate it (after copying the contents if you like) by catting the null device into the log file:

cat /dev/null > listener.log

This will result in a 0-byte file. There is definitely no need to restart the listener.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 24 May 2001, Gene Sais wrote:



> I think it is only safe to restart the listener when using dedicated not mts.  I 

>know on OpenVMS, you have to restart the db when restarting the listener using mts.  

>Never tested on unix.  I prefer dedicated, never use mts, too many problems.  Just 

>buy more RAM :).

>

> >>> ThaterW_at_telergy.net 05/24/01 10:15AM >>>

> On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon:

>

> ->As a regular maintainance work,I have moved the listener.log file to

> ->listener.log.old

> ->and 'touch'ed the listener.log, expecting the logging into this new file.

> ->But I am observing the logging being done to listener.log.old, instead.

> ->I could not recall any such previous experience.

> ->FYI, I cannot do any 'experiments' as far as this system is concerned as I

> ->have to deal with

> ->desupported HP-UX(10.01), Oracle (7.2.2.3).

> ->I have my logging being done to default path($ORACLE_HOME/network/log), as

> ->no parameter settings in listener.ora.

> ->Has anybody experienced this?

> ->

> The file handle listener is using is still pointed at the old file.  To fix this you 

>need to stop and start the listener.  This will not affect anybody who is already 

>connected.  I'm not sure if a reload will do the same thing.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).