Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail From: "nirav" Newsgroups: comp.databases.oracle.server Subject: Recycling the listener.. Date: 8 Aug 2005 00:13:02 -0700 Organization: http://groups.google.com Lines: 31 Message-ID: <1123485182.453361.275260@g14g2000cwa.googlegroups.com> NNTP-Posting-Host: 203.197.254.126 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1123485188 15080 127.0.0.1 (8 Aug 2005 07:13:08 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 8 Aug 2005 07:13:08 +0000 (UTC) User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: g14g2000cwa.googlegroups.com; posting-host=203.197.254.126; posting-account=EIIp9Q0AAABx3TtORI4efSnWEZQGHNCc Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249063 Hi Experts, I have oracle 9.2.0.6 on Solaris 8. My listener log file has grown to 15 mb. I needto recycle the listener but not sure of its steps: Are they as follows: 1) Stop the listener. 2) rename the listener log file to the name of the backup file (thus the file is renamed) 3) Start the listener. Is this correct?- I mean after restarting does the server CREATE the log file and start writing to it? Also I read about the other alternative which does not require stopping the listener: it is : % lsnrctl set log_status off % mv listener.log listener.old % lsnrctl set log_status on Are both techniques correct? We have j2ee based project talking to oracle database with app. server etc involved. Is it possible to get some connection error if I do it online? Should I have first the app. servers stopped before I do this? Pl. advice.. Nirav