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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
?
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
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
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
|
| [EMAIL PROTECTED] |
| cc: (bcc: William Dong/New York Life|
| Asset Management) |
| Subject: Re: Listener.log |
---|
When the listener needs
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
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.
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
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,
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
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
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
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
,
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 "invi
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
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
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:
34 matches
Mail list logo