listener.log parsing utility
Is there such a utility on the 'net somewhere? I would like to parse the log automatically, and get summaries of connection attempts, rejected connections, errors (if any), who connects, for how long. I have auditing set up in our db and can get some of that info, but I would like to monitor the contents of listener.log as well. Just curious. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: listener.log parsing utility
Patrice, I wrote the enclosed awk script to check the listener log and count the number of connections from each target. I am sure it could be adapted to suit your needs The first few line of output looks like Service :Host :User :tcp:ip address :No of Connections === service1 :C :\Oracle\Ora901\b:xxx:dedicated24 service2 :xxx :SMITHL1 :tcp:xx.xx.xxx.xxx47 /u00/oracle/john 227$ cat a.sh Script starts here echo Service :Host :User :tcp:ip address echo === grep CONNECT listener.log |\ awk -F= '{print $3 :1: $6 :2: $7 :3: $9 :4: $10 :5: $11}' |\ sed 's/).*:1:/:/' | \ sed 's/).*:2:/:/' | \ sed 's/).*:3:/:/' | \ sed 's/).*:4:/:/' | \ sed 's/).*:5:/:/' | \ sed 's/).*$//' | \ awk -F: '{printf(%-8.8s:%-16.16s:%-16.16s:%-3.3s:%-10.15s\n, \ $1,$2,$3,$4,$5)}' | sort /tmp/j.lis grep -v PROGRAM /tmp/j.lis /tmp/j1.lis cat /tmp/j1.lis | awk '{if (data[$0]++ == 0)lines[++count] = $0}\ END{for (i = 1; i = count; i++)print lines[i],\tdata[lines[i]]}'\ |sort -n +4 rm /tmp/j.lis rm /tmp/j1.lis script ends here HTH John -Original Message- Sent: 14 November 2002 13:09 To: Multiple recipients of list ORACLE-L Is there such a utility on the 'net somewhere? I would like to parse the log automatically, and get summaries of connection attempts, rejected connections, errors (if any), who connects, for how long. I have auditing set up in our db and can get some of that info, but I would like to monitor the contents of listener.log as well. Just curious. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: listener.log parsing utility
Patrice - In case you don't get a reply, it sounds to me like an easy project for Perl. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 14, 2002 7:09 AM To: Multiple recipients of list ORACLE-L Is there such a utility on the 'net somewhere? I would like to parse the log automatically, and get summaries of connection attempts, rejected connections, errors (if any), who connects, for how long. I have auditing set up in our db and can get some of that info, but I would like to monitor the contents of listener.log as well. Just curious. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Maintenance of listener.log files
Thank you for the ideas on maintaining a reasonable size listener.log file. I am trying out the scripts now in development to see which one works the best for me. Bryan -Original Message- Sent: Saturday, August 24, 2002 12:03 PM To: Multiple recipients of list ORACLE-L You can do it online. I have a CRON job which periodically truncates the file to the last X (e.g. 2) lines. In this code, I've added your requirement to archive and preserve the log. e.g #!/usr/bin/sh set `date` ORACLE_HOME=/u01/app/oracle/product/8.1.7;export ORACLE_HOME cd $ORACLE_HOME/network/log find . -name 'listener.log.preserve*' -mtime +15 -exec rm {} \; cp listener.log listener.log.preserve.$1$2 touch to_overwrite #optional : keep the last 2 lines of the logfile #tail -2 listener.log to_overwrite cat to_overwrite listener.log Test the script before you use it. Essentially, you can overwrite the listener.log online -- but you should not try to rm or mv it . Hemant At 08:53 AM 23-08-02 -0800, you wrote: Hello all, I have an 8.1.7.4 database on 11.0 HP-UX server with a listener.log file and it records information as long as the listener is up. The problem is that the listener is always up and the file is getting larger and larger. I am looking for a way to periodically copy the data from the listener.log to another file (that would be around for two weeks and then purged) without having to bring the listener down. It seems like one of those tricks of replacing a tire on a car while it is still being driven. TIA, Bryan Rodrigues DBA Elcom, Inc. Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Maintenance of listener.log files
'set log_status on|off' on lsnrctl will start/stop logging of the listener without taking the listener down. Alon On Fri, Aug 23, 2002 at 08:53:34AM -0800, Rodrigues, Bryan wrote: Hello all, I have an 8.1.7.4 database on 11.0 HP-UX server with a listener.log file and it records information as long as the listener is up. The problem is that the listener is always up and the file is getting larger and larger. I am looking for a way to periodically copy the data from the listener.log to another file (that would be around for two weeks and then purged) without having to bring the listener down. It seems like one of those tricks of replacing a tire on a car while it is still being driven. TIA, Bryan Rodrigues DBA Elcom, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alon Shalita INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: SIMPLE QUESTION (truncating listener.log)
Hi, You can truncate the listener.log without stopping the listener by doing this: cat /dev/null listener.log It won't interrupt the flow of information into the file because it maintains the same inode value. Regards, Mike Hately PS notice how truncating listener.log is more meaningful than SIMPLE QUESTION. =) -Original Message- Sent: Wednesday, May 01, 2002 6:54 PM To: Multiple recipients of list ORACLE-L Hamid, Ignore my e-mail, as I had alert_log in the brain, not listener. As for the listener, for most versions, you would have to stop the listener, remove it, then restart it. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 01, 2002 1:18 PM To: Multiple recipients of list ORACLE-L HI AGAIN, JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY TO RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD ONE IS USING BY ORACLE. HOW CAN I TRUNCATE THE LISTENER.LOG OR CAN I JUST SIMPLY DELETE IT OR NOT? THANKS FOR HELP. Hamid Alavi Office 818 737-0526 Cell818 402-1987 This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: SIMPLE QUESTION (truncating listener.log)
Oops! I forgot about that..RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 01, 2002 2:28 PM Hi, You can truncate the listener.log without stopping the listener by doing this: cat /dev/null listener.log It won't interrupt the flow of information into the file because it maintains the same inode value. Regards, Mike Hately PS notice how truncating listener.log is more meaningful than SIMPLE QUESTION. =) -Original Message- Sent: Wednesday, May 01, 2002 6:54 PM To: Multiple recipients of list ORACLE-L Hamid, Ignore my e-mail, as I had alert_log in the brain, not listener. As for the listener, for most versions, you would have to stop the listener, remove it, then restart it. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 01, 2002 1:18 PM To: Multiple recipients of list ORACLE-L HI AGAIN, JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY TO RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD ONE IS USING BY ORACLE. HOW CAN I TRUNCATE THE LISTENER.LOG OR CAN I JUST SIMPLY DELETE IT OR NOT? THANKS FOR HELP. Hamid Alavi Office 818 737-0526 Cell818 402-1987 This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Listener.log Errors
Anyone know what patterns are typically recognized as errors in the listener.log file? ORA-, error etc...? Thanks, Ethan Post -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
stopiing write to listener.log
Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu
RE: stopiing write to listener.log
Lee, I really don't think that's what he was after. However he does ask an Alice (IWL) and Cheshire cat question. Although yes I did resist the temptation to reply with such flair. Peter -Message d'origine-De: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 7 février 2002 12:33À: Multiple recipients of list ORACLE-LObjet: RE: stopiing write to listener.log Stop the listener !! -Original Message-From: Shibu [mailto:[EMAIL PROTECTED]]Sent: 07 February 2002 10:38To: Multiple recipients of list ORACLE-LSubject: stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibuThe information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
Re: stopiing write to listener.log
Shibu , IF you type LSNRCTL HELP YOU WILL SEE THE SET OPTION THEN TYPE HELP SET you will see the log_status action .. type show log_status . and be sure that it is ON. Then try to make it OFF with the SET command ... Bunyamin - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 1:58 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days. User Failing to connect like Microsoft Transaction Server Look on the metalink "Establish a grant to DBA_PENDING_TRANSACTIONS" HTH Peter -Message d'origine-De: Shibu [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 7 février 2002 11:38À: Multiple recipients of list ORACLE-LObjet: stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu
RE: stopiing write to listener.log
Stop the listener !! -Original Message-From: Shibu [mailto:[EMAIL PROTECTED]]Sent: 07 February 2002 10:38To: Multiple recipients of list ORACLE-LSubject: stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
Re: stopiing write to listener.log
Shibu, To stop listener from writing into listener.log put the following into listener configuration file listener.ora: LOGGING_LISTENER = OFF then stop/start listener to use modified configuration file. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Shibu To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 5:38 AM Subject: stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu
Re: stopiing write to listener.log
Hi peter I have thousands of connection in my dband listener.log is growing very fastly. I want to flush it manaually every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ? regards, shibu - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 5:28 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days. User Failing to connect like Microsoft Transaction Server Look on the metalink "Establish a grant to DBA_PENDING_TRANSACTIONS" HTH Peter -Message d'origine-De: Shibu [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 7 février 2002 11:38À: Multiple recipients of list ORACLE-LObjet: stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu
Re[2]: stopiing write to listener.log
Shibu, To get the listener to stop logging immediately without having to bounce it: lsnrctl set log_status = off exit Now to get that to stay forever set logging_listener = off in the listener.ora. Now delete the log file your done. For normal day to day operations the log file is absolutely useless. Actually I think the default log_status should be off. Dick Goulet Reply Separator Author: Shibu [EMAIL PROTECTED] Date: 2/7/2002 5:14 AM Hi peter I have thousands of connection in my db and listener.log is growing very fastly. I want to flush it manaually every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ? regards, shibu - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 5:28 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days. User Failing to connect like Microsoft Transaction Server Look on the metalink Establish a grant to DBA_PENDING_TRANSACTIONS HTH Peter -Message d'origine- De : Shibu [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 11:38 A : Multiple recipients of list ORACLE-L Objet : stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 6.00.2600.0 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2Hi peter /FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2I have thousands of connection in mynbsp; dbnbsp;andnbsp; listener.log is growing very fastly. Inbsp; wantnbsp; to flush it manauallynbsp; every time/FONT/DIV DIVFONT face=Arial size=2I want to either stop it or flush it automatically .My db is 8.1.7 on win2k/FONT/DIV DIVFONT face=Arial size=2Do u h ave any solution for this ?/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2regards,/FONT/DIV DIVFONT face=Arial size=2shibu/FONT/DIV BLOCKQUOTE dir=ltr style=PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #00 2px solid; MARGIN-RIGHT: 0px DIV style=FONT: 10pt arial- Original Message - /DIV DIV style=BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: blackBFrom:/B A [EMAIL PROTECTED] href=mailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/A /DIV DIV style=FONT: 10pt arialBTo:/B A [EMAIL PROTECTED] href=mailto:[EMAIL PROTECTED];Multiple recipients of list ORACLE-L/A /DIV DIV style=FONT: 10pt arialBSent:/B Thursday, February 07, 2002 5:28 PM/DIV DIV style=FONT: 10pt arialBSubject:/B RE: stopiing write to listener.log/DIV DIVBR/DIV DIVSPAN class=843013411-07022002FONT face=Arial color=#ff size=2Shibu,/FONT/SPAN/DIV DIVSPAN class=843013411-07022002FONT face=Arial color=#ff size=2What do you really want?/FONT/SPAN/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log/SPAN/FONT/FONT/F ONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002You could redivert this to /dev/null however this defeats the point./SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002You can rename it every day and archive off after 14 days./SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002/SPAN/FONT/FONT/FONTnbsp;/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002User Failing to connect like/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Microsoft Transaction Server/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Look on the metalink/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Establish a grant to DBA_PENDING_TRANSACTIONS/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002HTH/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Peter/SPAN/FONT/FONT/FONT/DIV DIVSPAN class=843013411-07022002/SPANFONT face=Tahoma size=2-Message d'origine-BRBDenbsp;:/B Shibu [mailto:[EMAIL PROTECTED]]BRBEnvoyénbsp;:/B jeudi 7 février 2002 11:38BRBAnbsp;:/B Multiple recipients of list ORACLE-LBRBObjetnbsp;:/B
RE: Re[2]: stopiing write to listener.log
erm. to Shibu. I forgot the smiley. It was only a joke !!! -Original Message- Sent: 07 February 2002 13:56 To: Multiple recipients of list ORACLE-L Shibu, To get the listener to stop logging immediately without having to bounce it: lsnrctl set log_status = off exit Now to get that to stay forever set logging_listener = off in the listener.ora. Now delete the log file your done. For normal day to day operations the log file is absolutely useless. Actually I think the default log_status should be off. Dick Goulet Reply Separator Author: Shibu [EMAIL PROTECTED] Date: 2/7/2002 5:14 AM Hi peter I have thousands of connection in my db and listener.log is growing very fastly. I want to flush it manaually every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ? regards, shibu - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 5:28 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days. User Failing to connect like Microsoft Transaction Server Look on the metalink Establish a grant to DBA_PENDING_TRANSACTIONS HTH Peter -Message d'origine- De : Shibu [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 11:38 A : Multiple recipients of list ORACLE-L Objet : stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 6.00.2600.0 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2Hi peter /FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2I have thousands of connection in mynbsp;d bnbsp;andnbsp; listener.log is growing very fastly. Inbsp; wantnbsp; to flush it manauallynbsp; every time/FONT/DIV DIVFONT face=Arial size=2I want to either stop it or flush it automatically .My db is 8.1.7 on win2k/FONT/DIV DIVFONT face=Arial size=2Do u h ave any solution for this ?/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2regards,/FONT/DIV DIVFONT face=Arial size=2shibu/FONT/DIV BLOCKQUOTE dir=ltr style=PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #00 2px solid; MARGIN-RIGHT: 0px DIV style=FONT: 10pt arial- Original Message - /DIV DIV style=BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: blackBFrom:/B A [EMAIL PROTECTED] href=mailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/A /DIV DIV style=FONT: 10pt arialBTo:/B A [EMAIL PROTECTED] href=mailto:[EMAIL PROTECTED];Multiple recipients of list ORACLE-L/A /DIV DIV style=FONT: 10pt arialBSent:/B Thursday, February 07, 2002 5:28 PM/DIV DIV style=FONT: 10pt arialBSubject:/B RE: stopiing write to listener.log/DIV DIVBR/DIV DIVSPAN class=843013411-07022002FONT face=Arial color=#ff size=2Shibu,/FONT/SPAN/DIV DIVSPAN class=843013411-07022002FONT face=Arial color=#ff size=2What do you really want?/FONT/SPAN/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log/SPAN/FONT/FONT /F ONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002You could redivert this to /dev/null however this defeats the point./SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002You can rename it every day and archive off after 14 days./SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002/SPAN/FONT/FONT/FONTnbsp;/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002User Failing to connect like/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Microsoft Transaction Server/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Look on the metalink/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Establish a grant to DBA_PENDING_TRANSACTIONS/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002HTH/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Peter/SPAN/FONT/FONT/FONT/DIV DIVSPAN class=843013411-07022002/SPANFONT face=Tahoma size=2-Message d'origine
RE: Re[2]: stopiing write to listener.log
Nice one, although the pipe still sounds interesting. Peter -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 14:56 À : Multiple recipients of list ORACLE-L Objet : Re[2]: stopiing write to listener.log Shibu, To get the listener to stop logging immediately without having to bounce it: lsnrctl set log_status = off exit Now to get that to stay forever set logging_listener = off in the listener.ora. Now delete the log file your done. For normal day to day operations the log file is absolutely useless. Actually I think the default log_status should be off. Dick Goulet Reply Separator Author: Shibu [EMAIL PROTECTED] Date: 2/7/2002 5:14 AM Hi peter I have thousands of connection in my db and listener.log is growing very fastly. I want to flush it manaually every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ? regards, shibu - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 5:28 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days. User Failing to connect like Microsoft Transaction Server Look on the metalink Establish a grant to DBA_PENDING_TRANSACTIONS HTH Peter -Message d'origine- De : Shibu [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 11:38 A : Multiple recipients of list ORACLE-L Objet : stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-1 META content=MSHTML 6.00.2600.0 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2Hi peter /FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2I have thousands of connection in mynbsp; dbnbsp;andnbsp; listener.log is growing very fastly. Inbsp; wantnbsp; to flush it manauallynbsp; every time/FONT/DIV DIVFONT face=Arial size=2I want to either stop it or flush it automatically .My db is 8.1.7 on win2k/FONT/DIV DIVFONT face=Arial size=2Do u h ave any solution for this ?/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2regards,/FONT/DIV DIVFONT face=Arial size=2shibu/FONT/DIV BLOCKQUOTE dir=ltr style=PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #00 2px solid; MARGIN-RIGHT: 0px DIV style=FONT: 10pt arial- Original Message - /DIV DIV style=BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: blackBFrom:/B A [EMAIL PROTECTED] href=mailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/A /DIV DIV style=FONT: 10pt arialBTo:/B A [EMAIL PROTECTED] href=mailto:[EMAIL PROTECTED];Multiple recipients of list ORACLE-L/A /DIV DIV style=FONT: 10pt arialBSent:/B Thursday, February 07, 2002 5:28 PM/DIV DIV style=FONT: 10pt arialBSubject:/B RE: stopiing write to listener.log/DIV DIVBR/DIV DIVSPAN class=843013411-07022002FONT face=Arial color=#ff size=2Shibu,/FONT/SPAN/DIV DIVSPAN class=843013411-07022002FONT face=Arial color=#ff size=2What do you really want?/FONT/SPAN/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log/SPAN/FONT/FONT /F ONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002You could redivert this to /dev/null however this defeats the point./SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002You can rename it every day and archive off after 14 days./SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002/SPAN/FONT/FONT/FONTnbsp;/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002User Failing to connect like/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Microsoft Transaction Server/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Look on the metalink/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Establish a grant to DBA_PENDING_TRANSACTIONS/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002HTH/SPAN/FONT/FONT/FONT/DIV DIVFONT face=ArialFONT size=2FONT color=#ffSPAN class=843013411-07022002Peter/SPAN/FONT/FONT
RE: stopiing write to listener.log
Peter, How do you set the 'Log Rotation' ? From command line utility 'lsnrctl' or is there any parameter for listener.ora ? Another thing: How do I track the exact SQLs being sent to the Oracle server ? I remember somebody on this list gave some hints in this direction. I just don't remember now the parameter name that I have to set in the listener.ora (some levl=16 or something like that ?) thanks Santi -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 07, 2002 6:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: stopiing write to listener.log Shibu, OK so I now understand a little better your need. Of course there is listener OFF (logging_listener=off) As I said this really does defeat the point. Their are two approaches that spring to mind. Log Rotation or writing to a pipe. Log Rotation: Every x hours stop the listener, rename the file, start the listener You can then do stats on normal connections and save just the error and startups et al ... Writing to a pipe: Would mean that you create a pipe alert_SID.ora and have a process that would read from the pipe everything but normal connections. The disadvantages are - that you may not be able to do this on your NT box. - you lose all your stats of cnxs Peter -Message d'origine-De: Shibu [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 7 février 2002 14:15À: Multiple recipients of list ORACLE-LObjet: Re: stopiing write to listener.log Hi peter I have thousands of connection in my dband listener.log is growing very fastly. I want to flush it manaually every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ? regards, shibu - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 5:28 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days. User Failing to connect like Microsoft Transaction Server Look on the metalink "Establish a grant to DBA_PENDING_TRANSACTIONS" HTH Peter -Message d'origine-De: Shibu [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 7 février 2002 11:38À: Multiple recipients of list ORACLE-LObjet: stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu
RE: stopiing write to listener.log
1) lsnrctl stop RENAME %ORACLE_HOME%\NETWORK\LOG\LISTENER.LOG OLD.LOG lsnrctl start 2) see the sample in network\admin\sample. use trace_level=user (IMHO). Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Prakriteswar Santikary [SMTP:[EMAIL PROTECTED]] Sent: Thu, February 07, 2002 5:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: stopiing write to listener.log Peter, How do you set the 'Log Rotation' ? From command line utility 'lsnrctl' or is there any parameter for listener.ora ? Another thing: How do I track the exact SQLs being sent to the Oracle server ? I remember somebody on this list gave some hints in this direction. I just don't remember now the parameter name that I have to set in the listener.ora (some levl=16 or something like that ?) thanks Santi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 6:44 AM To: Multiple recipients of list ORACLE-L Subject: RE: stopiing write to listener.log Shibu, OK so I now understand a little better your need. Of course there is listener OFF (logging_listener=off) As I said this really does defeat the point. Their are two approaches that spring to mind. Log Rotation or writing to a pipe. Log Rotation: Every x hours stop the listener, rename the file, start the listener You can then do stats on normal connections and save just the error and startups et al ... Writing to a pipe: Would mean that you create a pipe alert_SID.ora and have a process that would read from the pipe everything but normal connections. The disadvantages are - that you may not be able to do this on your NT box. - you lose all your stats of cnxs Peter -Message d'origine- De : Shibu [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 14:15 À : Multiple recipients of list ORACLE-L Objet : Re: stopiing write to listener.log Hi peter I have thousands of connection in my db and listener.log is growing very fastly. I want to flush it manaually every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ? regards, shibu - Original Message - From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Thursday, February 07, 2002 5:28 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days. User Failing to connect like Microsoft Transaction Server Look on the metalink Establish a grant to DBA_PENDING_TRANSACTIONS HTH Peter -Message d'origine- De : Shibu [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 11:38 À : Multiple recipients of list ORACLE-L Objet : stopiing write to listener.log Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?àãø_éçéàì? INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: stopiing write to listener.log
SHibu, In lsnrctl, set log_status=off. Chuan Oracle DBA Transact Communication, Ltd. -Original Message- Sent: Thursday, 7 February 2002 9:38 PM To: Multiple recipients of list ORACLE-L Hi How Can i stop Oracle from writing to the file listener.log?? regards, shibu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Load listener.log via sqlldr
Friends, Has anyone developed a sqlldr control file to load listener.log? I have a requirement to trap the IP addresses of failed connection attempts; this info is not trapped as an IP address in DBA_AUDIT_TRAIL or AUD$. If you have already accomplished this, let me know so I don't reinvent the wheel. Many thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Scott INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: flushing listener.log
% rem Renames the most recent listener log rem if exist %LISTENER_LOG%.log rename %LISTENER_LOG%.log %LISTENER_LOG_NAME%_01.log rem Builds second listener command file rem --- echo set current_listener %LISTENER_NAME% %SCRIPT_DIR%\listener_log_rename_2.lsnr echo set log_file %LISTENER_LOG_NAME% %SCRIPT_DIR%\listener_log_rename_2.lsnr rem Executes second listener command file rem These listener commands reset the listener log back to its original name rem type %SCRIPT_DIR%\listener_log_rename_2.lsnr | %LISTENER_CONTROL% rem Deletes temporary files rem --- del %LISTENER_LOG_DIR%\%LISTENER_TEMP%.log del %SCRIPT_DIR%\listener_log_rename_1.lsnr del %SCRIPT_DIR%\listener_log_rename_2.lsnr -Original Message- Sent: Wednesday, September 26, 2001 4:15 AM To: LazyDBA.com Discussion Just do this listener.log Sinardy -Original Message- Sent: Wednesday, 26 September 2001 3:27 PM To: LazyDBA.com Discussion Hi salman Environment is Oracle 8.1.5 in win NT rgds, shibu - Original Message - To: shibu [EMAIL PROTECTED] Sent: Wednesday, September 26, 2001 12:49 PM which o/s you are using?? shibu [EMAIL PROTECTED] on 09/26/2001 12:11:58 PM To: LazyDBA.com Discussion [EMAIL PROTECTED] cc: Subject: flushing listener.log Hi all My listener.log has grown to size of 1.5 gb? Now i am not able to open it and delete it . How can? i reduce the size without taking database down? How often do u guys flush it? rgds, shibu Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
listener.log
I have a listener.log that is rather large. I want to archive the current one and create a new one. From what I can tell is that I have two options. 1) -Shut down the listener service (8.1.7 on NT 4.0) -rename the current log -startup the listener service again and this will create a new log listener.log or 2) -at a dos prompt type -MSDOS lsnrctl set log_file listener1.log -This can be done without stopping the listener service Am I correct about these two methods? Just want to check before I mess things up. I have renamed my SIDAlert.log before but never my listener. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: listener.log
Dave, This came from the list a few weeks ago. I amended it slightly but it still all works. John #!/bin/ksh # Script to copy out listener.log and compress it. ORACLE_BASE=/u01/app/oracle export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/8.1.6 export ORACLE_HOME PATH=$ORACLE_HOME/bin:/usr/local/bin:/bin:/usr/bin export PATH COMPRESSED_FILE=/u01/app/oracle/product/8.1.6/network/log/listener`date +%Y%m%d%H%M`.log lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener2.log mv /u01/app/oracle/product/8.1.6/network/log/listener.log $COMPRESSED_FILE mv /u01/app/oracle/product/8.1.6/network/log/listener2.log /u01/app/oracle/product/8.1.6/network/log/listener.log lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener.log compress $COMPRESSED_FILE # # now remove all compressed listener logs older than 10 days # find /u01/app/oracle/product/8.1.6/network/log/list*.Z -mtime +10 -print -exec rm {} \; A suitable crontab entry for the oracle account would be 00 19 * * * /home/oracle/tidy_listener_log.sh /home/oracle/tidy_listener_log.log 21 -Original Message- Sent: 27 June 01 14:36 To: Multiple recipients of list ORACLE-L I have a listener.log that is rather large. I want to archive the current one and create a new one. From what I can tell is that I have two options. 1) -Shut down the listener service (8.1.7 on NT 4.0) -rename the current log -startup the listener service again and this will create a new log listener.log or 2) -at a dos prompt type -MSDOS lsnrctl set log_file listener1.log -This can be done without stopping the listener service Am I correct about these two methods? Just want to check before I mess things up. I have renamed my SIDAlert.log before but never my listener. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hallas John INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: listener.log
All, Can someone explain to me if there is anything wrong with the following as I don't issue the lsnrctl set log_file command. I seem to remember someone saying in the original thread that this can cause problems. I have been running the following method for months with no ill effects. cp the current file to archive area (this is then written to tape and removed) cat /dev/null to the current one This appears to work, my first entry in the newly truncated listener log file is 1 minute past midnight (the job runs at midnight on the first day of the month). Regards Lee -Original Message- Sent: 27 June 2001 15:55 To: Multiple recipients of list ORACLE-L Dave, This came from the list a few weeks ago. I amended it slightly but it still all works. John #!/bin/ksh # Script to copy out listener.log and compress it. ORACLE_BASE=/u01/app/oracle export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/8.1.6 export ORACLE_HOME PATH=$ORACLE_HOME/bin:/usr/local/bin:/bin:/usr/bin export PATH COMPRESSED_FILE=/u01/app/oracle/product/8.1.6/network/log/listener`date +%Y%m%d%H%M`.log lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener2.log mv /u01/app/oracle/product/8.1.6/network/log/listener.log $COMPRESSED_FILE mv /u01/app/oracle/product/8.1.6/network/log/listener2.log /u01/app/oracle/product/8.1.6/network/log/listener.log lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener.log compress $COMPRESSED_FILE # # now remove all compressed listener logs older than 10 days # find /u01/app/oracle/product/8.1.6/network/log/list*.Z -mtime +10 -print -exec rm {} \; A suitable crontab entry for the oracle account would be 00 19 * * * /home/oracle/tidy_listener_log.sh /home/oracle/tidy_listener_log.log 21 The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
LISTENER.LOG file compress
Hi My Listener.log file big.I want to rename the listener.log file.Can you please suggest the steps. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: LISTENER.LOG file compress
Look in the thread just opened, and answered called listener.log answered by John Hallas. -Original Message- Sent: Wednesday, June 27, 2001 04:36 To: Multiple recipients of list ORACLE-L Hi My Listener.log file big.I want to rename the listener.log file.Can you please suggest the steps. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: listener.log
won't LSNRCTL RELOAD do this trick? -Original Message- Sent: Wednesday, June 27, 2001 9:36 AM To: Multiple recipients of list ORACLE-L I have a listener.log that is rather large. I want to archive the current one and create a new one. From what I can tell is that I have two options. 1) -Shut down the listener service (8.1.7 on NT 4.0) -rename the current log -startup the listener service again and this will create a new log listener.log or 2) -at a dos prompt type -MSDOS lsnrctl set log_file listener1.log -This can be done without stopping the listener service Am I correct about these two methods? Just want to check before I mess things up. I have renamed my SIDAlert.log before but never my listener. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: LISTENER.LOG file compress
Seema, I just posted a question on this earlier today. If you are on unix I was given this suggestion from John. #!/bin/ksh # Script to copy out listener.log and compress it. ORACLE_BASE=/u01/app/oracle export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/8.1.6 export ORACLE_HOME PATH=$ORACLE_HOME/bin:/usr/local/bin:/bin:/usr/bin export PATH COMPRESSED_FILE=/u01/app/oracle/product/8.1.6/network/log/listener`date +%Y%m%d%H%M`.log lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener2.log mv /u01/app/oracle/product/8.1.6/network/log/listener.log $COMPRESSED_FILE mv /u01/app/oracle/product/8.1.6/network/log/listener2.log /u01/app/oracle/product/8.1.6/network/log/listener.log lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener.log compress $COMPRESSED_FILE # # now remove all compressed listener logs older than 10 days # find /u01/app/oracle/product/8.1.6/network/log/list*.Z -mtime +10 -print -exec rm {} \; A suitable crontab entry for the oracle account would be 00 19 * * * /home/oracle/tidy_listener_log.sh /home/oracle/tidy_listener_log.log 21 ** I am on NT but I believe you can use on of these two methods. 1) -Shut down the listener service (8.1.7 on NT 4.0) -rename the current log -startup the listener service again and this will create a new log listener.log or 2) -at a dos prompt type -MSDOS lsnrctl set log_file listener1.log -This can be done without stopping the listener service Dave So many cats...So few recipes!! -Original Message- Sent: Wednesday, June 27, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Hi My Listener.log file big.I want to rename the listener.log file.Can you please suggest the steps. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: LISTENER.LOG file compress
To rename the listener.log, try this(on Unix) 1) cp listener.log listener.log.bu 2) cat /dev/null listener.log OR you can have the following shell script submitted to cron to rename log file at regular intervals. === DT=`date +%m%d%y%H%M` cp listener.log listener.log.$DT cat /dev/null listener.log === Suren, Consultant DBA, Sony -Original Message- Sent: Wednesday, June 27, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Hi My Listener.log file big.I want to rename the listener.log file.Can you please suggest the steps. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Listener.log....writing to renamed file
Title: RE: Listener.logwriting to renamed file You should bounce the listener. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: Li, Xiangli [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 2:58 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Listener.logwriting to renamed file May I know how to clear the content of listener.log without restart listener on NT platform ? thanks. Li -Original Message- From: Brian MacLean [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 1:42 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener.logwriting to renamed file Reload doesn't close/reopen the file. Here is a couple solutions How's about a fast cat/clear solution: #!/bin/kshcat listener.log listener.log.histex listener.log EOF1,\$dwqEOF Or if you wish to purge 90% of the file: #!/bin/kshwc -l listener.log | read v_lines junkv_keep=$(($((${v_lines} * 10)) / 100))v_purge=$((${v_lines} - ${v_keep}))ex listener.log EOF1,${v_purge}dwqEOF -Original Message-From: Thater, William [ mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 7:15 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Listener.logwriting to renamed file On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon: -Hi List,-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?--TIA,--Suren-Oracle DBA-Sony Electronics Ltd.--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. --Bill Thater Certifiable ORACLE DBATelergy, Inc. [EMAIL PROTECTED]~~You gotta program like you don't need the money,You gotta compile like you'll never get hurt,You gotta run like there's nobody watching,It's gotta come from the heart if you want it to work.~~No program done by an undergrad will work after she graduates. --Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
REP: writing to renamed Listener.log file
Actually, I just talked to Worldwide Support about this issue. They recommend using the set log_file command to rename the file to another file name (templisten.log for example)- for the life of the listener session. After that, you can reset/delete/purge the listener.log file safely. Then bounce the listener and it will begin writing to listener.log file again. LSNRCTL help set log_file set|show log_{ } [value]: set|show log parameters of current listener On Tue, 29 May 2001 07:35:27 Christopher Spence wrote: You should bounce the listener. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Thursday, May 24, 2001 2:58 PM To: Multiple recipients of list ORACLE-L May I know how to clear the content of listener.log without restart listener on NT platform ? thanks. Li -Original Message- Sent: Thursday, May 24, 2001 1:42 PM To: Multiple recipients of list ORACLE-L Reload doesn't close/reopen the file. Here is a couple solutions How's about a fast cat/clear solution: #!/bin/ksh cat listener.log listener.log.hist ex listener.log EOF 1,\$d wq EOF Or if you wish to purge 90% of the file: #!/bin/ksh wc -l listener.log | read v_lines junk v_keep=$(($((${v_lines} * 10)) / 100)) v_purge=$((${v_lines} - ${v_keep})) ex listener.log EOF 1,${v_purge}d wq EOF -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, May 24, 2001 7:15 AM To: Multiple recipients of list ORACLE-L On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon: -Hi List, -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? - -TIA, - -Suren -Oracle DBA -Sony Electronics Ltd. - - 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. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: REP: writing to renamed Listener.log file
Well, bouncing the listener is not needed. We do the same at our place here lsnrctl set log_file $ORACLE_HOME/network/log/listener1.log mv $ORACLE_HOME/network/log/listener.log \ $ORACLE_HOME/network/log/listener.log.$QUALIFIER lsnrctl set log_file $ORACLE_HOME/network/log/listener.log where $QUALIFIER is the date stamp. Satish IyerDBACCSS Team 684-3016 [EMAIL PROTECTED] 05/29/01 01:15PM lsnrctl set log_file $ORACLE_HOME/network/log/listener1.logActually, I just talked to Worldwide Support about this issue. They recommend using the set log_file command to rename the file to another file name ("templisten.log" for example)- for the life of the listener session. After that, you can reset/delete/purge the listener.log file safely. Then bounce the listener and it will begin writing to listener.log file again.LSNRCTL help set log_fileset|show log_{ } [value]: set|show log parameters of current listener On Tue, 29 May 2001 07:35:27 Christopher Spence wrote:You should bounce the listener. "Walking on water and developing software from a specification are easy ifboth are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-Sent: Thursday, May 24, 2001 2:58 PMTo: Multiple recipients of list ORACLE-LMay I know how to clear the content of listener.log without restart listeneron NT platform ? thanks. Li -Original Message- Sent: Thursday, May 24, 2001 1:42 PM To: Multiple recipients of list ORACLE-L Reload doesn't close/reopen the file. Here is a couple solutions How's about a fast cat/clear solution: #!/bin/kshcat listener.log listener.log.histex listener.log EOF1,\$dwqEOF Or if you wish to purge 90% of the file: #!/bin/kshwc -l listener.log | read v_lines junkv_keep=$(($((${v_lines} * 10)) / 100))v_purge=$((${v_lines} - ${v_keep}))ex listener.log EOF1,${v_purge}dwqEOF -Original Message-mailto:[EMAIL PROTECTED] ]Sent: Thursday, May 24, 2001 7:15 AMTo: Multiple recipients of list ORACLE-L On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall inglitter crayon: -Hi List,-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?--TIA,--Suren-Oracle DBA-Sony Electronics Ltd.--The file handle listener is using is still pointed at the old file. To fixthis you need to stop and start the listener. This will not affect anybodywho is already connected. I'm not sure if a reload will do the same thing. --Bill Thater Certifiable ORACLE DBATelergy, Inc. [EMAIL PROTECTED]Get 250 color business cards for FREE!http://businesscards.lycos.com/vp/fastpath/-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: The Oracle DBA INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Listener.log....writing to renamed file
Title: RE: Listener.logwriting to renamed file Thanks all. Very clear and it works. rgds, Li -Original Message- From: Reardon, Bruce (CALBBAY) [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 11:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener.logwriting to renamed file On NT, if you don't want to lose any listener.log entries and you want to keep using the same logfile name then you will need to use set log_file twice. Also, under NT (at least with 815 and 817) don't specify an extension for the log file - it automatically gets .log appended. For example (something like the following untested code): lsnrctl set log_file temp1 ren listener.log listener_tmp.log lsnrctl set log_file listener copy /b listener_tmp.log + temp1.log listener-date.log del listener_tmp.log del temp1.log You could put the date into the archived listener log using the for command to process output of date/t and time/t. Note that using set log_file requires the listener password to be entered. This can be automated under NT by using something like: rem create the temp file echo set password %lnrpwd% %lnrstart_file% echo stop %1 %lnrstart_file% echo exit %lnrstart_file% echo. %lnrstart_file% rem feed it into lsnrctl lsnrctl %lnrstart_file% Regards, Bruce -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, 25 May 2001 5:53 To: Multiple recipients of list ORACLE-L Issue the SET LOG_FILE command using lsnrctl, then move/delete/whatever the old file. -Original Message- Sent: Thursday, May 24, 2001 1:58 PM To: ORACLE-L; Xiangli.Li May I know how to clear the content of listener.log without restart listener on NT platform ? thanks. Li -Original Message- From: Brian MacLean [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 1:42 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener.logwriting to renamed file Reload doesn't close/reopen the file. Here is a couple solutions How's about a fast cat/clear solution: #!/bin/ksh cat listener.log listener.log.hist ex listener.log EOF 1,$d wq EOF Or if you wish to purge 90% of the file: #!/bin/ksh wc -l listener.log | read v_lines junk v_keep=$(($(($v_lines * 10)) / 100)) v_purge=$(($v_lines - $v_keep)) ex listener.log EOF 1,$v_purged wq EOF -Original Message- Sent: Thursday, May 24, 2001 7:15 AM To: Multiple recipients of list ORACLE-L On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon: -Hi List, -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? - -TIA, - -Suren -Oracle DBA -Sony Electronics Ltd. - - 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. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc. [EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ No program done by an undergrad will work after she graduates. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED
Listener.log....writing to renamed file
Hi List, 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? TIA, Suren Oracle DBA Sony Electronics Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Listener.log....writing to renamed file
On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon: -Hi List, -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? - -TIA, - -Suren -Oracle DBA -Sony Electronics Ltd. - - 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. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ No program done by an undergrad will work after she graduates. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Listener.log....writing to renamed file
On Thu, 24 May 2001,Gene Sais scribbled on the wall in glitter crayon: -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 :). On UNIX I just stop and start the listener MTS or no. I used to do the same on VMS as well, but that was long long ago in a galaxy far far away.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ No program done by an undergrad will work after she graduates. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Listener.log....writing to renamed file
FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. Try the following which is a slightly amended version of a script that was mentioned on here several weeks ago (I am sorry I forget who contributed it) # Script to copy out listener.log and compress it. ORACLE_BASE=/u01/app/oracle export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/8.1.6 export ORACLE_HOME PATH=$ORACLE_HOME/bin:/usr/local/bin:/bin:/usr/bin export PATH COMPRESSED_FILE=/u01/app/oracle/product/8.1.6/network/log/listener`date +%Y%m%d%H%M`.log lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener2.log mv /u01/app/oracle/product/8.1.6/network/log/listener.log $COMPRESSED_FILE mv /u01/app/oracle/product/8.1.6/network/log/listener2.log /u01/app/oracle/product/8.1.6/network/log/listener.log lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener.log compress $COMPRESSED_FILE # # now remove all compressed listener logs older than 10 days # find /u01/app/oracle/product/8.1.6/network/log/list*.Z -mtime +10 -print -exec rm {} \; John Hallas *+44 (0) 115 945 6643 * +44 (0) 115 945 6774 -Original Message- From: Tirumala, Surendra [mailto:[EMAIL PROTECTED]] Sent: 24 May 2001 15:07 To: Multiple recipients of list ORACLE-L Subject:Listener.logwriting to renamed file Hi List, 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? TIA, Suren Oracle DBA Sony Electronics Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). This e-mail and any files transmitted with it, are confidential to Logica and are intended solely for the use of the individual or entity to whom they are addressed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hallas, John INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 :). [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Listener.log....writing to renamed file
Title: RE: Listener.logwriting to renamed file Reload doesn't close/reopen the file. Here is a couple solutions How's about a fast cat/clear solution: #!/bin/ksh cat listener.log listener.log.hist ex listener.log EOF 1,\$d wq EOF Or if you wish to purge 90% of the file: #!/bin/ksh wc -l listener.log | read v_lines junk v_keep=$(($((${v_lines} * 10)) / 100)) v_purge=$((${v_lines} - ${v_keep})) ex listener.log EOF 1,${v_purge}d wq EOF -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 7:15 AM To: Multiple recipients of list ORACLE-L Subject: Re: Listener.logwriting to renamed file On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon: -Hi List, -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? - -TIA, - -Suren -Oracle DBA -Sony Electronics Ltd. - - 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. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc. [EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ No program done by an undergrad will work after she graduates. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Re: Listener.log....writing to renamed file
A coworker of mine discovered this a few weeks ago on a Sun box. No difference there! -Original Message- From: Gsais [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 11:36 AM To: ORACLE-L Cc: Gsais Subject: Re: Listener.logwriting to renamed file 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 :).
RE: Listener.log....writing to renamed file
Title: RE: Listener.logwriting to renamed file May I know how to clear the content of listener.log without restart listener on NT platform ? thanks. Li -Original Message- From: Brian MacLean [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 1:42 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener.logwriting to renamed file Reload doesn't close/reopen the file. Here is a couple solutions How's about a fast cat/clear solution: #!/bin/ksh cat listener.log listener.log.hist ex listener.log EOF 1,\$d wq EOF Or if you wish to purge 90% of the file: #!/bin/ksh wc -l listener.log | read v_lines junk v_keep=$(($((${v_lines} * 10)) / 100)) v_purge=$((${v_lines} - ${v_keep})) ex listener.log EOF 1,${v_purge}d wq EOF -Original Message- From: Thater, William [ mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 7:15 AM To: Multiple recipients of list ORACLE-L Subject: Re: Listener.logwriting to renamed file On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon: -Hi List, -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? - -TIA, - -Suren -Oracle DBA -Sony Electronics Ltd. - - 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. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc. [EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ No program done by an undergrad will work after she graduates. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Listener.log....writing to renamed file
Brain, thank you very much , your scripts worked well. Also thanks to all who responded/responding to my question. Suren -Original Message- Sent: Thursday, May 24, 2001 1:42 PM To: Multiple recipients of list ORACLE-L Reload doesn't close/reopen the file. Here is a couple solutions How's about a fast cat/clear solution: #!/bin/ksh cat listener.log listener.log.hist ex listener.log EOF 1,\$d wq EOF Or if you wish to purge 90% of the file: #!/bin/ksh wc -l listener.log | read v_lines junk v_keep=$(($((${v_lines} * 10)) / 100)) v_purge=$((${v_lines} - ${v_keep})) ex listener.log EOF 1,${v_purge}d wq EOF -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, May 24, 2001 7:15 AM To: Multiple recipients of list ORACLE-L On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon: -Hi List, -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? - -TIA, - -Suren -Oracle DBA -Sony Electronics Ltd. - - 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. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ No program done by an undergrad will work after she graduates. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Listener.log....writing to renamed file
On NT, if you don't want to lose any listener.log entries and you want to keep using the same logfile name then you will need to use set log_file twice. Also, under NT (at least with 815 and 817) don't specify an extension for the log file - it automatically gets .log appended. For example (something like the following untested code): lsnrctl set log_file temp1 ren listener.log listener_tmp.log lsnrctl set log_file listener copy /b listener_tmp.log + temp1.log listener-date.log del listener_tmp.log del temp1.log You could put the date into the archived listener log using the for command to process output of date/t and time/t. Note that using set log_file requires the listener password to be entered. This can be automated under NT by using something like: rem create the temp file echo set password %lnrpwd% %lnrstart_file% echo stop %1 %lnrstart_file% echo exit%lnrstart_file% echo. %lnrstart_file% rem feed it into lsnrctl lsnrctl %lnrstart_file% Regards, Bruce -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, 25 May 2001 5:53 To: Multiple recipients of list ORACLE-L Issue the SET LOG_FILE command using lsnrctl, then move/delete/whatever the old file. -Original Message- Sent: Thursday, May 24, 2001 1:58 PM To: ORACLE-L; Xiangli.Li May I know how to clear the content of listener.log without restart listener on NT platform ? thanks. Li -Original Message- From: Brian MacLean [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 1:42 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener.logwriting to renamed file Reload doesn't close/reopen the file. Here is a couple solutions How's about a fast cat/clear solution: #!/bin/ksh cat listener.log listener.log.hist ex listener.log EOF 1,$d wq EOF Or if you wish to purge 90% of the file: #!/bin/ksh wc -l listener.log | read v_lines junk v_keep=$(($(($v_lines * 10)) / 100)) v_purge=$(($v_lines - $v_keep)) ex listener.log EOF 1,$v_purged wq EOF -Original Message- Sent: Thursday, May 24, 2001 7:15 AM To: Multiple recipients of list ORACLE-L On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon: -Hi List, -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? - -TIA, - -Suren -Oracle DBA -Sony Electronics Ltd. - - 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. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc. [EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ No program done by an undergrad will work after she graduates. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
Truncate listener.log how?
Gurus I want to truncate listener.log file.I am using oracle 8.1.5 and 8.1.7 on solaris 8.Plese suggest.As I understand go to listener.log file directory copy listener.log listener.old tail -10 listener.log Thanks in advance. -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Truncate listener.log how?
Hi seema, you can do: echo '' listener.log On Thu, 17 May 2001, Seema Singh wrote: Gurus I want to truncate listener.log file.I am using oracle 8.1.5 and 8.1.7 on solaris 8.Plese suggest.As I understand go to listener.log file directory copy listener.log listener.old tail -10 listener.log Thanks in advance. -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Lucy Lin Oracle DBA condenet.com 212-286-3852 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lucy Lin INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: monitoring listener.log
Title: monitoring listener.log Hi and thanks to" Danisment Gazi Unal (what does it mean ?)" Here is the script : #!/bin/sh # This script make 2 things : # 1- archive alert files # 2- search "ORA-" in alert.log file # if error is found , send an email to adresses passed in parameters # # Entry parameters : # 1- SID # 2- list of emails separated by a space # Ex : % ALTERTCHECK ORCL [EMAIL PROTECTED] [EMAIL PROTECTED] # --- SCRIPT_DIR=/home/ORCL/script ORACLE_SID=$1 shift EMAIL=$* # Set ALERT_DIR and ALERT_FILE # -- ALERT_DIR=/app/oracle/admin/$ORACLE_SID/bdump ALERT_FILE=alert_$ORACLE_SID.log ALERT_LOG=$ALERT_DIR/$ALERT_FILE ERRFILE=$SCRIPT_DIR/ALERT_ERRORS.TXT SUBJECT="Error in alert file of $ORACLE_SID" # Remove the alert file #30 # if [ -f $ALERT_LOG.30 ] then /bin/rm $ALERT_LOG.30 fi # Renanme the alert file, ex: 29 to 30, 28 to 29, .., 01 to 02, etc. # -- i=29 while [ $i -ge 1 ] ; do j=`expr $i + 1` if [ -f $ALERT_LOG.$i ] then mv $ALERT_LOG.$i $ALERT_LOG.$j fi i=`expr $i - 1` done # Rename the current alert log file to #1 # - if [ -f $ALERT_LOG ] then mv $ALERT_LOG $ALERT_LOG.1 fi # Create a new alert file, not mandotory (Oracle will do this) # touch $ALERT_LOG chmod 777 $ALERT_LOG # Remove the error file # --- if [ -f $ERRFILE ] then /bin/rm $ERRFILE fi # Searching for ORA- in the alert log #1 # if error, send mail to adresses in parameters # --- cat $ALERT_LOG.1 |grep '\ORA-' $ERRFILE if [ -s $ERRFILE ] then cat $ERRFILE | mailx -s "$SUBJECT" $EMAIL fi -Message d'origine-De: Saurabh Sharma [mailto:[EMAIL PROTECTED]]Date: vendredi 27 avril 2001 12:12À: Multiple recipients of list ORACLE-LObjet: Re: monitoring listener.log hey can u elaborate how do u scan each log file, and convert it in email msg. how do u do this.. saurabh sharma dba - Original Message - From: NGUYEN Philippe (Cetelem) To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 25, 2001 9:10 PM Subject: monitoring listener.log Hi list, We have a script wich monitor the alert.log for each database. This script scan the alert.log file and send an email if an ORA-xxx error occured Now, we want to write a script monitoring the listener.log file : wich kind of message or variable indicate a network problem (ORA-xxx, ...) ? ...then we 'll have the same question for the log file made by OEM ! TIA
Re: monitoring listener.log
Hi again, Note that listener is only used while creating shadow processes on server side. Once shadow processes are created by listener, listener is never used. in other words, listener process is not a bridge between user process and server process during data transmissions. So, scanning listener.log only is not a good way to catch sql*net errors. to catch sql*net errors after connections are established, set sql*net server trace. then scan them. But, it's not be efficient. there will be a lot of trace files. rgrds... "Danisment Gazi Unal (Unal Bilisim)" wrote: Hi, Typical errors in sql*net traces are like this: nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=533, nt[1]=57, nt[2]=0 Means: You get protocol error 57. If you are using TCP/IP, check winsock errors, if I'm not wrong it should be 20057 or 10057. This error causes sql*net 533 error. 533,12560 and 12571 are result. Saurabh Sharma wrote: hey can u elaborate how do u scan each log file, and convert it in email msg.how do u do this.. saurabh sharmadba - Original Message - From:NGUYEN Philippe (Cetelem) To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 25, 2001 9:10 PM Subject: monitoring listener.log Hi list, We have a script wich monitor the alert.log for each database. This script scan the alert.log file and send an email if an ORA-xxx error occured Now, we want to write a script monitoring the listener.log file : wich kind of message or variable indicate a network problem (ORA-xxx, ...) ? ...then we 'll have the same question for the log file made by OEM ! TIA
Re: monitoring listener.log
Title: monitoring listener.log hey can u elaborate how do u scan each log file, and convert it in email msg. how do u do this.. saurabh sharma dba - Original Message - From: NGUYEN Philippe (Cetelem) To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 25, 2001 9:10 PM Subject: monitoring listener.log Hi list, We have a script wich monitor the alert.log for each database. This script scan the alert.log file and send an email if an ORA-xxx error occured Now, we want to write a script monitoring the listener.log file : wich kind of message or variable indicate a network problem (ORA-xxx, ...) ? ...then we 'll have the same question for the log file made by OEM ! TIA
Re: monitoring listener.log
Hi, Typical errors in sql*net traces are like this: nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=533, nt[1]=57, nt[2]=0 Means: You get protocol error 57. If you are using TCP/IP, check winsock errors, if I'm not wrong it should be 20057 or 10057. This error causes sql*net 533 error. 533,12560 and 12571 are result. Saurabh Sharma wrote: hey can u elaborate how do u scan each log file, and convert it in email msg.how do u do this..saurabh sharmadba - Original Message - From: NGUYEN Philippe (Cetelem) To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 25, 2001 9:10 PM Subject: monitoring listener.log Hi list, We have a script wich monitor the alert.log for each database. This script scan the alert.log file and send an email if an ORA-xxx error occured Now, we want to write a script monitoring the listener.log file : wich kind of message or variable indicate a network problem (ORA-xxx, ...) ? ...then we 'll have the same question for the log file made by OEM ! TIA
Re: Listener.log
Hello, Thank you very much for your responses. What i wanted to do was compressing the listener.log. It works fine as below : cp listener.log listener.log.$(date +%y%d%m) cat /dev/null listener.log compress listener.log.$(date +%y%d%m) Regards, Nguyen Thanh-truc - Original Message - From: John Carlson To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 25, 2001 1:45 AM Subject: RE: Listener.log For those of you who did not see my response in the thread of "Perl DBA Tools" I will repeat it here, it answers this thread as well. Also, there is no need to shutdown the database to bounce the listener. How about wrapping this in a script of your choice: ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log lsnrctl set log_file listener2.logmv listener.log $ARCHIVE_LISTENER_FILENAMEmv listener2.log listener.loglsnrctl set log_file listener.loggzip $ARCHIVE_LISTENER_FILENAME This way, you don't have to stop the listener and you don't loose anything. Remember, in Unix, when you rename a file, any program that has it open still points to it. Regards, John
RE: Listener.log
Thank you, John.The best solution. Vadim -Original Message-From: John Carlson [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 7:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Listener.log For those of you who did not see my response in the thread of "Perl DBA Tools" I will repeat it here, it answers this thread as well. Also, there is no need to shutdown the database to bounce the listener. How about wrapping this in a script of your choice: ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log lsnrctl set log_file listener2.logmv listener.log $ARCHIVE_LISTENER_FILENAMEmv listener2.log listener.loglsnrctl set log_file listener.loggzip $ARCHIVE_LISTENER_FILENAME This way, you don't have to stop the listener and you don't loose anything. Remember, in Unix, when you rename a file, any program that has it open still points to it. Regards, John [EMAIL PROTECTED] 04/24/01 02:28PM You can shutdown/start the Database and start listener would solve ur problem.-SeemaFrom: "Adams, Matthew (GEA, 088130)" [EMAIL PROTECTED]Reply-To: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Subject: RE: Listener.logDate: Tue, 24 Apr 2001 11:16:49 -0800No, you do not have to restart the listener.touch the listener.log file (we do a 'cp /dev/null$ORACLE_HOME/network/log/listener.log)and the listener will start writing to it again.R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger.-Original Message-Sent: Tuesday, April 24, 2001 12:28 PMTo: Multiple recipients of list ORACLE-LHello,You have to restart your listener. It continues to write to "invisible" file(inode without any reference from directories). Welcome to UNIX.HTHVadim GorbounovOracle DBA-Original Message-Sent: Tuesday, April 24, 2001 11:47 AMTo: Multiple recipients of list ORACLE-LHello everyone,After moving the listener.log and compressed, there is no more log for thelistener. Could anyone help me please ? Thanks.Nguyen_Get your FREE download of MSN Explorer at http://explorer.msn.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Seema Singh INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
monitoring listener.log
Title: monitoring listener.log Hi list, We have a script wich monitor the alert.log for each database. This script scan the alert.log file and send an email if an ORA-xxx error occured Now, we want to write a script monitoring the listener.log file : wich kind of message or variable indicate a network problem (ORA-xxx, ...) ? ...then we 'll have the same question for the log file made by OEM ! TIA
Re: Listener.log
reboot listener with LSNRCTL |+ || Ruth Gramolini | || [EMAIL PROTECTED]| || ate.vt.us| ||| || 04/24/01 01:55 PM | || Please respond to | || ORACLE-L | ||| |+ ---| | | | To: Multiple recipients of list ORACLE-L| | [EMAIL PROTECTED] | | cc: (bcc: William Dong/New York Life| | Asset Management) | | Subject: Re: Listener.log | ---| When the listener needs to make a log entry he will create a new log. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 11:47 AM Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Dong INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Listener.log
Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen
RE: Listener.log
Moving the listenet.log file will not stop the listener to stop writing to this file (like the alertSID.log), you will either need to start stop the listener (if you get a chance to) or there is another lsnrctl command; something like: lsnrctl listener_name reload, which will reload the listener and force it to create a new log file in its proper directory. HTH Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Nguyen Thanh-trucSent: Tuesday, April 24, 2001 04:47To: Multiple recipients of list ORACLE-LSubject: Listener.log Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen
RE: Listener.log
touch $ORACLE_HOME/network/log/listener.log -Original Message- Sent: Tuesday, April 24, 2001 11:47 AM To: Multiple recipients of list ORACLE-L Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Listener.log
Don't worry. Everything will be all right. The listener.log is still cached in memory. The next time you bounce (cleanly) Oracle it will start a new one listener.log. ..tom -Original Message- From: Nguyen Thanh-truc [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 11:47 AM To: Multiple recipients of list ORACLE-L Subject: Listener.log Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Listener.log
Hello, You have to restart your listener. It continues towrite to "invisible" file (inode without any reference from directories). Welcome to UNIX. HTH Vadim Gorbounov Oracle DBA -Original Message-From: Nguyen Thanh-truc [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 11:47 AMTo: Multiple recipients of list ORACLE-LSubject: Listener.log Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen
Re: Listener.log
When the listener needs to make a log entry he will create a new log. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 11:47 AM Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Listener.log
Only if the listener has been restarted after moving or removing the listener.log Patricia -Original Message- Sent: Tuesday, April 24, 2001 10:56 AM To: Multiple recipients of list ORACLE-L When the listener needs to make a log entry he will create a new log. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 11:47 AM Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Patricia Ashe INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Listener.log
Okay, you moved the old one. Perhaps you haven't had any activity that would cause an entry to be generated for the log? Or have you changed any of the parameters in your listener.ora file? Regards, David A. Barbour Oracle DBA Nguyen Thanh-truc wrote: Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Listener.log
You have to reload or stop/start the listener to create a new log. -Original Message- Sent: Tuesday, April 24, 2001 8:47 AM To: Multiple recipients of list ORACLE-L Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Patricia Ashe INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Listener.log
No, you do not have to restart the listener. touch the listener.log file (we do a 'cp /dev/null $ORACLE_HOME/network/log/listener.log) and the listener will start writing to it again. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message-From: Vadim Gorbounov [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 12:28 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Listener.log Hello, You have to restart your listener. It continues towrite to "invisible" file (inode without any reference from directories). Welcome to UNIX. HTH Vadim Gorbounov Oracle DBA -Original Message-From: Nguyen Thanh-truc [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 11:47 AMTo: Multiple recipients of list ORACLE-LSubject: Listener.log Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen
Recall: Listener.log
Title: Recall: Listener.log Adams, Matthew (GEA, 088130) would like to recall the message, Listener.log.
RE: Recall: Listener.log
Title: Recall: Listener.log Doesn't work, amigo. -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 4:06 PMTo: Multiple recipients of list ORACLE-LSubject: Recall: Listener.log Adams, Matthew (GEA, 088130) would like to recall the message, "Listener.log".
RE: Recall: Listener.log
Title: Recall: Listener.log Adams, Matthew (GEA, 088130) would like to recall the message, "Listener.log". Matt, No need to recall...we don't bite!! Ed
RE: Listener.log
We do something similar, running a weekly script that copies the listener.log to a file with a date extension, rms any files over a month old, and then copies /dev/null over the listener.log. That way we always have a month's worth of listener log entries in the unlikely event we want to look at them :). -Original Message- Sent: Tuesday, April 24, 2001 3:17 PM To: Multiple recipients of list ORACLE-L No, you do not have to restart the listener. touch the listener.log file (we do a 'cp /dev/null $ORACLE_HOME/network/log/listener.log) and the listener will start writing to it again. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- Sent: Tuesday, April 24, 2001 12:28 PM To: Multiple recipients of list ORACLE-L Hello, You have to restart your listener. It continues to write to invisible file (inode without any reference from directories). Welcome to UNIX. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, April 24, 2001 11:47 AM To: Multiple recipients of list ORACLE-L Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Recall: Listener.log
On Tue, 24 Apr 2001,[EMAIL PROTECTED] scribbled on the wall in...: - - -Adams, Matthew (GEA, 088130) would like to recall the message, -Listener.log. - - -Matt, - -No need to recall...we don't bite!! wel... only if you ask nice.;-) -- Bill Thater Certifieable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ I would be very ashamed of my civilization if we did not try to find out if there is life in outer space. - Carl Sagan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Listener.log
You can shutdown/start the Database and start listener would solve ur problem. -Seema From: Adams, Matthew (GEA, 088130) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Listener.log Date: Tue, 24 Apr 2001 11:16:49 -0800 No, you do not have to restart the listener. touch the listener.log file (we do a 'cp /dev/null $ORACLE_HOME/network/log/listener.log) and the listener will start writing to it again. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- Sent: Tuesday, April 24, 2001 12:28 PM To: Multiple recipients of list ORACLE-L Hello, You have to restart your listener. It continues to write to invisible file (inode without any reference from directories). Welcome to UNIX. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, April 24, 2001 11:47 AM To: Multiple recipients of list ORACLE-L Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Recall: Listener.log
Title: Recall: Listener.log Right after I pressed send I realized the original poster has said 'moved' the file, not copied. oh well. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 5:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Recall: Listener.log Adams, Matthew (GEA, 088130) would like to recall the message, "Listener.log". Matt, No need to recall...we don't bite!! Ed
RE: Listener.log
For those of you who did not see my response in the thread of "Perl DBA Tools" I will repeat it here, it answers this thread as well. Also, there is no need to shutdown the database to bounce the listener. How about wrapping this in a script of your choice: ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log lsnrctl set log_file listener2.logmv listener.log $ARCHIVE_LISTENER_FILENAMEmv listener2.log listener.loglsnrctl set log_file listener.loggzip $ARCHIVE_LISTENER_FILENAME This way, you don't have to stop the listener and you don't loose anything. Remember, in Unix, when you rename a file, any program that has it open still points to it. Regards, John [EMAIL PROTECTED] 04/24/01 02:28PM You can shutdown/start the Database and start listener would solve ur problem.-SeemaFrom: "Adams, Matthew (GEA, 088130)" [EMAIL PROTECTED]Reply-To: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Subject: RE: Listener.logDate: Tue, 24 Apr 2001 11:16:49 -0800No, you do not have to restart the listener.touch the listener.log file (we do a 'cp /dev/null$ORACLE_HOME/network/log/listener.log)and the listener will start writing to it again.R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger.-Original Message-Sent: Tuesday, April 24, 2001 12:28 PMTo: Multiple recipients of list ORACLE-LHello,You have to restart your listener. It continues to write to "invisible" file(inode without any reference from directories). Welcome to UNIX.HTHVadim GorbounovOracle DBA-Original Message-Sent: Tuesday, April 24, 2001 11:47 AMTo: Multiple recipients of list ORACLE-LHello everyone,After moving the listener.log and compressed, there is no more log for thelistener. Could anyone help me please ? Thanks.Nguyen_Get your FREE download of MSN Explorer at http://explorer.msn.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Seema Singh INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).