still free.
Tony
-Original Message-
Sent: Tuesday, September 25, 2001 6:15 AM
To: Multiple recipients of list ORACLE-L
Hi guru's
Suppose that, i'm managing serveral database from a single client.
In that case, how can i find out the alert log/trace files from the
client.
An
for the
various databases, as you said.
How can i?
Nirmal
> -Original Message-
> From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, September 26, 2001 2:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Alert log from Remot
Nirmal,
Perhaps the replies re AlertView have answered your question. AFAICR it
requires FTP service to be running. You did not specify your Operating
System. Do you simply want to view the Alert logs and Trace files for the
various databases or be alerted if an error appears in Alert Log or
ay, September 25, 2001 6:15 AM
> Hi guru's
>
> Suppose that, i'm managing serveral database from a single client.
>
> In that case, how can i find out the alert log/trace files from the
client.
>
> Any ideas pls.
>
> Regards,
> Nirmal.
>
>
>
Title: RE: Alert log from Remote client
Check out AlertView from http://www.zephyrus.com/html/products.html. It's a java utility that provides a GUI interface to remote alert.log files. I think it's still free.
Tony
-Original Message-
From: Nirmal Kumar Muthu Kumar
Hi guru's
Suppose that, i'm managing serveral database from a single client.
In that case, how can i find out the alert log/trace files from the client.
Any ideas pls.
Regards,
Nirmal.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Mut
Off Topic to this List !!
Hi,
I had a situation yesterday where a rogue process wrote millions of
error messages into the alert log. I was able to get rid of the process,
then delete the error messages out. But it would have been quicker to just
blow it away and create a new, empty one. I was
to this List !!
>
> Hi,
>
> I had a situation yesterday where a rogue process wrote millions of
> error messages into the alert log. I was able to get rid of the process,
> then delete the error messages out. But it would have been quicker to just
> blow it away and create a
ost Off Topic to this List
!!Hi, I had a situation yesterday where a
rogue process wrote millions oferror messages into the alert log. I was able
to get rid of the process,then delete the error messages out. But it would
have been quicker to justblow it away and create a new, empty one.
!! Please do not post Off Topic to this List !!
Oracle will automatically recreate the ALERT log file and begin writing to
it.
Ed
-Original Message-
Sent: Thursday, September 13, 2001 10:50 AM
To: Multiple recipients of list ORACLE-L
!! Please do not post Off Topic to this List
!! Please do not post Off Topic to this List !!
If you delete the alert log and Oracle needs to make an entry thereafter the
file will re-appear all by itself.
Dick Goulet
Reply Separator
Author: "Carle; William T (Bill); NLCIO" <[EMAIL PRO
tiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 10:50 AM
> !! Please do not post Off Topic to this List !!
>
> Hi,
>
> I had a situation yesterday where a rogue process wrote millions of
> error messages into the alert
Title: RE: What happens if you lose the alert log?
Bill,
IF the alert log suddenly disappears (you delete it), Oracle will create a new one without skipping a beat.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From
situation yesterday where a rogue process wrote millions of
error messages into the alert log. I was able to get rid of the process,
then delete the error messages out. But it would have been quicker to just
blow it away and create a new, empty one. I was concerned as to the effect
that would have
: Thursday, September 13, 2001 9:50 AM
To: Multiple recipients of list ORACLE-L
!! Please do not post Off Topic to this List !!
Hi,
I had a situation yesterday where a rogue process wrote millions of
error messages into the alert log. I was able to get rid of the process,
then delete the error
!! Please do not post Off Topic to this List !!
Hi,
I had a situation yesterday where a rogue process wrote millions of
error messages into the alert log. I was able to get rid of the process,
then delete the error messages out. But it would have been quicker to just
blow it away and create
ipients of list ORACLE-L
Ron,
thanks for the script, but what was the name of the book that taught you
this!
Rachel
>From: "Smith, Ron L." <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject:
ok.
>
> Thanks in Advance,
> Rajesh
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Okan CIMEN
> Sent: Tuesday, July 31, 2001 7:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Perl Script for Alert Log
>
&g
thanks!
>From: "Smith, Ron L." <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Perl Script for Alert Log
>Date: Tue, 31 Jul 2001 05:41:14 -0800
>
>The book is "Teach your
quot;Smith, Ron L." <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Perl Script for Alert Log
> >Date: Mon, 30 Jul 2001 13:50:29 -0800
> >
> >A few weeks ago I was looking f
TED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Perl Script for Alert Log
>Date: Mon, 30 Jul 2001 13:50:29 -0800
>
>A few weeks ago I was looking for a script that would combine the date
>records with the detail records on the Oracle alert_log.
>
Ron,
thanks for the script, but what was the name of the book that taught you
this!
Rachel
>From: "Smith, Ron L." <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Perl Script for Alert
A few weeks ago I was looking for a script that would combine the date
records with the detail records on the Oracle alert_log.
I didn't get any responses so I decided to do it myself. (I hate it when
that happens!). Anyway, everyone here tells me how great
Perl is at handling things like this so
On Thu, Jul 19, 2001 at 07:16:19AM -0800, Smith, Ron L. wrote:
> Does anyone have a Perl script that will concatenate the date records with
> the detail records from the alert log? I want to grep for error messages in
> the alert log but I want the date as part of the record.
--
great
Does anyone have a Perl script that will concatenate the date records with
the detail records from the alert log? I want to grep for error messages in
the alert log but I want the date as part of the record.
Thanks!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author
Thank you
John.
-Original Message-From: John Carlson
[mailto:[EMAIL PROTECTED]]Sent: Thursday, July 12, 2001 5:56
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
alert log is not capturing all errors
The alert log does not capture anything it considers
to be a
The alert log does not capture anything it considers to
be a user error.
HTH,
John
>>> [EMAIL PROTECTED] 07/12/01 12:35PM
>>>Hi List,I have encountered a little strange incident.
Here is a brief:I ran a package which runs every day early in the
morning. I create a
rocess through the spool
command.Today my package didn't run. It had an error saying 'ERROR
at line 1: ORA-04068: existing state of packages has been discarded'
. Anyway, not abig deal. I think I eliminated the
error.The thing that puzzles me is that error IS NOT in the
g state of packages has been discarded' . Anyway, not a
big deal. I think I eliminated the error.
The thing that puzzles me is that error IS NOT in the alert log. I had an
impression that alert log would capture ALL of the errors occurring on the
system. Isn't it the case?
Thank you for
or Solaris so this might just mean that the "feature" is
> Solaris specific, since people here are saying that they haven't seen it
on
> other platforms.
>
> We are on Solaris, but our scripts are written such that we don't rename
the
> alert log so I haven't b
that they haven't seen it
on
> other platforms.
>
> We are on Solaris, but our scripts are written such that we don't rename
the
> alert log so I haven't been able to prove it one way or another.
>
> Rachel
>
> Note:122401.1
> Type: BULLETIN
>
I think you might possibly lose messages. but I also think that the risk is
worth it if you don't want to do the delete.
>From: "Richard Ji" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>S
ultiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Rename alert log
>Date: Wed, 11 Jul 2001 06:30:26 -0800
>
>I knew you weren't crazy, Rachel. :)
>
>So far this "feature" hasn't worked for me. I have been moving
>the alert.log and let
-L <[EMAIL PROTECTED]>
>Subject: Re: Rename alert log
>Date: Wed, 11 Jul 2001 06:30:26 -0800
>
>I knew you weren't crazy, Rachel. :)
>
>So far this "feature" hasn't worked for me. I have been moving
>the alert.log and let Oracle create a new one since 8
MAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> >Subject: RE: Rename alert log
> >Date: Tue, 10 Jul 2001 11:05:39 -0800
> >
> >I am running 8.1.7 and just last week renamed my
>
as also a bug filed on it (which was closed as "not a bug") bug#
1388186
It was filed for Solaris so this might just mean that the "feature" is
Solaris specific, since people here are saying that they haven't seen it on
other platforms.
We are on Solaris, but our scrip
he "feature" is
Solaris specific, since people here are saying that they haven't seen it on
other platforms.
We are on Solaris, but our scripts are written such that we don't rename the
alert log so I haven't been able to prove it one way or another.
Rachel
Note:122401.1
T
ist ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Rename alert log
>Date: Tue, 10 Jul 2001 11:05:39 -0800
>
>I am running 8.1.7 and just last week renamed my alert.log while the
>database was up and everything seemed to work fine. It created a new alert
>log on the fly.
>
&g
Hi,
I have just found the email I posted earlier about this in the List
archives.
To find it search for "when it will need to delete the alert log
file"
I can't comment on the accuracy with respect to Unix as don't use it.
Under NT as others have said you can j
don't like this new rule that you have to copy it and then null the alert log
since those are two separate operations. I can loss a message or two if
there is a lag after the copying is done and before nulling the log file.
>>> [EMAIL PROTECTED] 07/10/01 01:26PM >>>
depend
way it handles the listener log file. So you will need
to do the same sort of tricks to the alert log as you have to do to the
listener log (make a copy then copy /dev/null to the
original)>From: "Smith, Ron L."
<[EMAIL PROTECTED]>>Reply-To: [EMAIL PROTECTED]>To:
Mu
Yup
-Original Message-
L.
Sent: Tuesday, July 10, 2001 03:57
To: Multiple recipients of list ORACLE-L
Can the alert log be renamed while the database is up and running?
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL
Title: RE: Rename alert log
same here.
jon
-Original Message-
From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 3:06 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Rename alert log
I am running 8.1.7 and just last week renamed my
fine. It created a new alert
log on the fly.
Dave
-Original Message-
Sent: Tuesday, July 10, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L
In 816 on NT, you can rename it any time you want.
is this changing in 817 Rachel?
Tom Mercadante
Oracle Certified Professional
I am running 8.1.7 and just last week renamed my alert.log while the
database was up and everything seemed to work fine. It created a new alert
log on the fly.
Dave
-Original Message-
Sent: Tuesday, July 10, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L
In 816 on NT, you can
Hmmm...in Oracle 7.3.4,, 7.3.5, 8.0.5, 8.0.6, 8.1.6, and 8.1.7 on HP/UX
10.20/11.0, a rename of the alert log causes a new one to be created with
the next message. My "AlertLogChecker" renames the alert log if it finds an
error in there. As I'm attempting to size parti
CTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Rename alert log
>Date: Tue, 10 Jul 2001 10:00:34 -0800
>
>In 816 on NT, you can rename it any time you want.
>
>is this changing in 817 Rachel?
will need to do the same sort of tricks to the alert log as you
have to do to the listener log (make a copy then copy /dev/null to the
original)
>From: "Smith, Ron L." <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL
Ron:
If you mean, "Can the alert log be renamed for archiving purposes
while the db is up?" the answer is yes. Oracle will just recreate
the alert log the next time it needs to write an entry to it.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
>--- Ori
Yes. Rename delete trimmedetc.
-Original Message-
Sent: Tuesday, July 10, 2001 9:57 AM
To: Multiple recipients of list ORACLE-L
Can the alert log be renamed while the database is up and running?
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Yes, it can. Just rename it and there will be new one created with an old
name at some point.
-Original Message-
Sent: Tuesday, July 10, 2001 10:57 AM
To: Multiple recipients of list ORACLE-L
Can the alert log be renamed while the database is up and running?
Ron
--
Please see the
Yes
-Original Message-
Sent: Tuesday, July 10, 2001 9:57 AM
To: Multiple recipients of list ORACLE-L
Can the alert log be renamed while the database is up and running?
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL
, similar to the way it handles the listener log
file. So you will need to do the same sort of tricks to the alert log as you
have to do to the listener log (make a copy then copy /dev/null to the
original)
>From: "Smith, Ron L." <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PR
rrupt block on an index. I run Analyze every
week which I found has been blowing up for some time due to the block
corruption. Since Analyze does not create a log I did not know the Analyze
was blowing up. Now I know that there are messages in the alert log that
would have told me I had problems
TH,
Mike
---
===
Michael P. Vergara | I've got a PBS mind in an MTV world
Oracle DBA |
Guidant Corporation |
-Original Message-
Sent: Tuesday, July 10, 2001 7:57 AM
To: Multiple recipients of list ORACLE-L
Can the alert log be renamed while
I run Analyze every
> week which I found has been blowing up for some time due to the block
> corruption. Since Analyze does not create a log I did not know the
Analyze
> was blowing up. Now I know that there are messages in the alert log that
> would have told me I had problems with th
Can the alert log be renamed while the database is up and running?
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
I believe that a dedicated window running
tail -f 10 /alert_log_filename
will keep an eye on the last 10 lines of the
alert log in Unix/Linux.
- jeremy donson
CateredComputing
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat
Last week I was bit by a corrupt block on an index. I run Analyze every
week which I found has been blowing up for some time due to the block
corruption. Since Analyze does not create a log I did not know the Analyze
was blowing up. Now I know that there are messages in the alert log that
bounced the database. We are also
investigating a possible 8.1.7 bug related to ORA-04031 errors.
My question is this: Why didn't we see any ORA-04031 errors in the
alert log? None registered in our alert log throughout that period.
Anybody know what the deal is?
T
Hello all,
What could be the size of alert log file,so that it will need to delete the
file in sun solaris UNIX,8.0.5.
Regards,
Saroj.
-OE³'ÌffbfZ[fW-
·ol: Jared Still [mailto:[EMAIL PROTECTED]]
'-M"úZz: Monday, May 28, 2001 PM 12:11
^¶æ: Multiple recipients o
Raj,
Nope, none that I know of. Yet another reason to
upgrade ;)
-- Anita
--- Raj Gopalan <[EMAIL PROTECTED]>
wrote:
> Hi
>
> I think this parameter is available from 8.1.6 where
> us I am in 8.1.5..Any
> idea how to control it in 8.1.5?
>
> Raj
>
> -Original Message-
> Sent: 12 May
Rafiq
But I want my db to be archived..
Raj
-Original Message-
Sent: 11 May 2001 21:46
To: Multiple recipients of list ORACLE-L
Your archiving is TRUE instead of false
Check for log_archive_start FALSE
change this parameter to false and rebounce your database.
Regards
Hi
I think this parameter is available from 8.1.6 where us I am in 8.1.5..Any
idea how to control it in 8.1.5?
Raj
-Original Message-
Sent: 12 May 2001 00:18
To: Multiple recipients of list ORACLE-L
Raj,
It's new archiving tracing introduced in 8i. If
you're on 8.1.6 or later you ca
Raj,
It's new archiving tracing introduced in 8i. If
you're on 8.1.6 or later you can control the level of
tracing with the LOG_ARCHIVE_TRACE parameter.
See the following docs:
Note 94055.1 "Init.ora Parameter "LOG_ARCHIVE_TRACE"
Reference Note"
Note 104405.1 "ARCH tracefile messages VALIDATE,
Your archiving is TRUE instead of false
Check for log_archive_start FALSE
change this parameter to false and rebounce your database.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 11 May 2001 08:46:06 -0800
DBA
DBAs
My alert.log is clogged with following message..
ARC0: received prod
ARC0: Beginning to archive log# 4 seq# 286600
ARC0: Completed archiving log# 4 seq# 286600
ARC0: re-scanning for new log files
ARC0: prodding the archiver
Fri May 11 16:10:01 2001
ARC1: received prod
Fri May 11 16:26:00 20
: Multiple recipients of list ORACLE-L
> Subject: RE: Ugly error in alert log
>
> Never seen it. If you are not doing manual archiving, and made in error
> while doing that, I guess there is a corruption. If this was for only one
> log, I would do a backup as soon as possi
I had the same error once. I never did figure out the exact cause.
What happened to cause this was a problem with creating a log file.
The file was created but the instance did not get the proper indication
that the file was created. So I had a number of error messages telling
me about that pro
apologies to everyone who I've led down a blind alley. The archive location
does have the SID in the directory structure. I removed it in the email as
it is the name of a client. Sorry for that !!!
> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: [EMAIL PROTECTED]
>
We usually put our archives in separate subdirectories per database, i.e.
\archives\sid name\.arc.
Also, are you naming your archives the same?
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204
>>>
Nope.
> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: [EMAIL PROTECTED]
>
-Original Message-
Sent: 22 February 2001 15:20
To: Multiple recipients of list ORACLE-L
Do you use the same location for your archivelog destination for 2
databases?
Ruth
- O
Do you use the same location for your archivelog destination for 2
databases?
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 4:20 AM
> All,
>
> Oracle 8.0.6.0.0
> Tru64 4.0f
>
> Anyone seen this before an d if s
Never seen it. If you are not doing manual archiving, and made in error
while doing that, I guess there is a corruption. If this was for only one
log, I would do a backup as soon as possible, as the previous backup may
very well not be usefull. Backup also control file to trace to see what it
is
All,
Oracle
8.0.6.0.0
Tru64
4.0f
Anyone seen this
before an d if so how did you solve it. Oracle have so far drawn a big fat blank
on this one.
Thu Feb 1
00:03:25 2001ARCH: Archival error occurred on a closed thread. Archiver
continuing.Thu Feb 1 00:03:25 2001ORACLE Instance
/usr/
s.
> Please check your code or degree of tables being
> used in your code.
>
> Regards
> Rafiq
>
>
>
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> Date: Tue, 06 Feb 2001 11:00:42 -0800
>
> Hi
gurus!
I am receiving the following bug in my Alert Log.
Oracle says it may be because of using PRO*C which
we are not using all.
Please review the contents and if someone has any idea
about it, the input will be appreciated.
Thu Jan 25 06:56:15 2001
Errors in file
/u01/app/oracle/admin/BPNEXT
Hi gurus!
I am receiving the following bug in my Alert Log.
Oracle says it may be because of using PRO*C which
we are not using all.
Please review the contents and if someone has any idea
about it, the input will be appreciated.
Thu Jan 25 06:56:15 2001
Errors in file
/u01/app/oracle/admin
101 - 178 of 178 matches
Mail list logo
