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: 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).