listener.log parsing utility

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

RE: listener.log parsing utility

=== 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

RE: listener.log parsing 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

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

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

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

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

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

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

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

Re: stopiing write to listener.log

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

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

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

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

Re[2]: stopiing write to listener.log

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

RE: Re[2]: stopiing write to listener.log

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

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

RE: stopiing write to listener.log

: 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

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

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

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

RE: flushing listener.log

--- 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

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

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

RE: listener.log

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

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

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

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

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

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

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 [mai

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

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

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.log

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Re: monitoring listener.log

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 err

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

Re: monitoring listener.log

, 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

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

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

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

Re: Listener.log

| | [EMAIL PROTECTED] | | cc: (bcc: William Dong/New York Life| | Asset Management) | | Subject: Re: Listener.log | ---| When the listener needs

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

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

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

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

RE: Listener.log

, 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

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

Re: Listener.log

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

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

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

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

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

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

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

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

RE: Listener.log

R_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