Yesterday, wereceived the below message in our alert log.
Normally, we do not see such messages in an alert log.It might be a
spurious message since in the associated trace file it first says: FATAL
ERROR IN TWO-TASK SERVER: error = 12571 which is a networking error.
Maybe just had
Yesterday, wereceived the below message in our alert log.
Normally, we do not see such messages in an alert log.It might be a
spurious message since in the associated trace file it first says: FATAL
ERROR IN TWO-TASK SERVER: error = 12571 which is a networking error.
Maybe just had
recipients of list ORACLE-LSubject:
ora-942 message in alert log
Yesterday, wereceived the below message in our alert log.
Normally, we do not see such messages in an alert log.It might be
a spurious message since in the associated trace file it first says:
FATAL ERROR IN TWO-TASK
Hi List
My database is taking vert long time to startup. so I just wanted to check alert log
file. But I don't see Alert log in either background_dump_dest or user_dump_dest.
Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all directory).
SQL show parameter dump
NAME
database is taking vert long time to startup. so I just wanted to check
alert log file. But I don't see Alert log in either background_dump_dest or
user_dump_dest.
Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all
directory).
SQL show parameter dump
NAME
just wanted to check alert log
file. But I don't see Alert log in either background_dump_dest or user_dump_dest.
Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all
directory).
SQL show parameter dump
NAME TYPEVALUE
. Alert files should be
deleted or archived periodically.
HTH
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 9:05 AM
To: Multiple recipients of list ORACLE-L
Hi List
My database is taking vert long time to startup. so I just wanted to check alert log
file. But I don't
long time to startup. so I just wanted to check
alert log file. But I don't see Alert log in either background_dump_dest or
user_dump_dest.
Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all
directory).
SQL show parameter dump
NAME TYPE
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 08, 2003 5:04 PM
Hi List
My database is taking vert long time to startup. so I just wanted to check
alert log file. But I don't see Alert log in either background_dump_dest
when i get a failure and oracle writes to my alert log, the job number does not match
to the one in dba_jobs.
any way to map these two different numbers? other than figuring it out from the error
message and the 'what' in dba_jobs?
--
Please see the official ORACLE-L FAQ: http
I've created a physical standby database that seems to be performing
properly, but there's no alert log in user_dump_dest, nor anywhere else
on the machine. Is there no alert log until/unless the standby
undergoes a role transition?
TIA
=
Paul Baumgartel
Transcentive, Inc
This seems strange to me, because things are written to the alert log file when the
instance starts, even when the database is not opened.
It should have been background_dump_dest (not user_dump_dest) and sometimes stuff is
written to $ORACLE_HOME/rdbms/log.
If you have looked for the file
Unless they have radically changed how they handle physical standby
databases, you should have an alert log for that database.
Have you logged in as sysdba and checked the location of the
background_dump_dest in v$parameter?
--- Paul Baumgartel [EMAIL PROTECTED] wrote:
I've created a physical
they have radically changed how they handle physical standby
databases, you should have an alert log for that database.
Have you logged in as sysdba and checked the location of the
background_dump_dest in v$parameter?
--- Paul Baumgartel [EMAIL PROTECTED] wrote:
I've created a physical standby
Can we setup a physical standby on a different OS (Win 2003) than the
primary db (Win 2000).
Thanks in advance.
Murali.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Murali_Pavuloori/[EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
not according to the oracle documentation. A physical standby has to be
on the same platform/same operating system (including patches)/same
database release
logical standby databases do not have to conform to that restriction
--- Murali_Pavuloori/[EMAIL PROTECTED] wrote:
Can we setup a
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/27/2003 03:44 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Alert log
Be careful of grepping for ^ORA-, I occasionally getORA- (spaces)
when I use this. Anjo
check http://www.dba-village.com/dba/village/dvp_scripts.ScriptDetails?ScrId=993
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, August 27, 2003 10:44
PM
Subject: perl/shell script for alert
log
I am sure you guys
I am sure you guys might have some nice
perl/shell script to analyze alert log for errors or potential problem . Can you
share it with me /list .
Ohh thanks in advance guys .
-ak
HTH
#!/bin/sh
# This Script search for Oracle error messages in last
100 lines in the alert log file ,
# keep log to a file.
# You should pass name of ORACLE_SID as a parameter.
#!/usr/bin/sh
#
# Comments: Script checks last 100 lines of
# the alert log for specific
# Oracle errors, e-mails
http://www.oracledba.co.uk/
Check out the alert log script in the admin section. Doesn't
repeatedly check the same segment of the alert log file.
- Ethan
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 12:14
PMTo: Multiple
AK - Go to Google and search on oracle alert log monitor script. This will
give you an array to select from. What you want will depend to a large
extent on your requirements:
- Something you can easily modify?
- What platforms should it run on?
- Email you alerts?
- Which errors do you wish
Roger Xu [EMAIL PROTECTED]
for the guy that asked for writing the the alert.log
file:
dbms_system.ksdwrt(2,'Test line...');
Will write the text to the alert log.
Use 1 instead of 2 to write to the trace file
Use 3 to write to both.
HTH
JL
__
Do you Yahoo
When I grep something from the alert log,
it never tell me the date and time of the error.
Is there a setting for appending a timestamp on each error?
-Original Message-
Sent: Wednesday, August 27, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L
HTH
#!/bin/sh
# This Script search
to every script is to configure the a SERVERERROR
trigger to throw certain errors out to the alert log. ORA-1555 is one that
will show up at the session level but not at the database level. Out of
TEMP space is another that is frequent at the session level but not the
database level. This way you know
the a SERVERERROR
trigger to throw certain errors out to the alert log. ORA-1555 is one that
will show up at the session level but not at the database level. Out of
TEMP space is another that is frequent at the session level but not the
database level. This way you know who is causing some
Hi!
I would add a check for Checkpoint not complete in alert just in case as
well.
Tanel.
One enhancement I suggest to every script is to configure the a
SERVERERROR
trigger to throw certain errors out to the alert log. ORA-1555 is one
that
will show up at the session level
Hey, awesome tip! Been here, lurking. Does that generate a trace file with
more than just session id and serial# in it? Nice thing about SERVERERROR
is I can get machinename, username, osuser etc and stuff it in alert log
so I see who caused the error when I get the email, but your way
-Original Message-
Sent: Wednesday, August 27, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
Roger Xu [EMAIL PROTECTED]
for the guy that asked for writing the the alert.log
file:
dbms_system.ksdwrt(2,'Test line...');
Will write the text to the alert log.
Use 1 instead of 2 to write
.
It also sends everything through a filter of known patterns and anything
that is not recognized falls out. I call this the paranoid switch -p.
One best practice I recommend is to automate control file backups anytime a
ALTER TABLESPACE, ALTER DATABASE etc...is in the alert log.
-Original Message
Title: Location of trace files and alert log
How do I locate where all trace files and alert log are saved? There is no parameter setup in init.ora file.
Thanks,
David
Title: Location of trace files and alert log
SQLshow parameter background_dump_dest
SQLshow parameter user_dump_dest
-Original Message-From: Nguyen, David M
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 10, 2003 11:44
AMTo: Multiple recipients of list ORACLE-LSubject
query v$parameter?
joe
Nguyen, David M wrote:
How do I locate where all trace files and alert log are saved? There
is no parameter setup in init.ora file.
Thanks,
David
--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
--
Please see
Title: Location of trace files and alert log
Yes thereare ...
Originally called ... SAVE_ALERT_LOGFILE_DIR and SAVE_USER_TRACEFILE_DIR
... but they were replaced with various *_DUMP_DEST parameters ... because the
committee who certifies and performs code reviews didn't have sense of
humor
Here is a good one:
create or replace directory bdump as
'/oracle/admin/o9i/bdump' / grant read on directory bdump to
public / create table alert_log_ext ( line varchar2(2000) )
organization external ( type oracle_loader default directory
bdump access parameters
(
records
And load 'em to CLOBs as well and use InterMedia Text to index them ;)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, July 11, 2003 12:59 AM
Here is a good one:
create or replace directory bdump as
'/oracle/admin/o9i/bdump'
If you have more databases, there are synonyms, views and db-links.
That is classic DBA patchwork. The funniest siutations arise when
you have a circle of synonyms and db-links pointing to each other,
just like perpetuum mobile. What is impossible in thermodynamics, is
possible in oracle. It
Thanx Mladen.
i have got some scripts now.
i have to try one by one and find out which suits my need.
thanx u all.
Jp.
10-07-2003 09:09:24, Mladen Gogala [EMAIL PROTECTED] wrote:
Here is a good one:
create or replace directory bdump as '/oracle/admin/o9i/bdump'
/
grant read on directory bdump
])
# ([EMAIL PROTECTED])
#
# Description : Script checks last 200 lines of
# : the alert log for specific
# : Oracle errors, then pages or e-mails depending #on the
error.
#
# Parameter : ORACLE_SID#
#
# Format
([EMAIL PROTECTED])
# ([EMAIL PROTECTED])
#
# Description : Script checks last 200 lines of
# : the alert log for specific
# : Oracle errors, then pages or e-mails depending #on the
error.
#
# Parameter : ORACLE_SID#
#
# Format
Thanx Gudmundur,Ranganath,Peter and Johnfor the scripts.
now i have to test the scritps on windows :(
Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Yep, it's called ALORS (Alert LOg Repository System) and is cool (but will
get better). Now, I'm not sure, but you could try this address:
http://ip14.ds1-ba.adsl.cybercity.dk:8080/alors/
- let me know if it doesn't work.
Mogens
Gudmundur Bjarni Josepsson wrote:
I need a parse
Guys,
I need a parse alert log and mail me if there is any error.
Hope u guys would have some script for the same.
i have 8i and 9i instances spread across windows 2000 network.
even if u guys have script for unix,just pass it on to me.
let me modify and try it.
Thanks and Regards,
Jp
sorry guys...there was some TYPO in my previous mail.
I need to parse alert log and mail me if there is any error.
Hope u guys would have some script for the same.
i have 8i and 9i instances spread across windows 2000 network.
even if u guys have script for unix,just pass it on to me.
let me
to scan $logfile
fi
done
-Original Message-
Sent: 07 July 2003 10:39
To: Multiple recipients of list ORACLE-L
Guys,
I need a parse alert log and mail me if there is any error.
Hope u guys would have some script for the same.
i have 8i and 9i instances spread across windows 2000
]
(B Sent: 07 July 2003 10:39
(B To: Multiple recipients of list ORACLE-L
(B Subject: any script to parse alert log ?!
(B
(B
(B Guys,
(B
(B I need a parse alert log and mail me if there is any error.
(B Hope u guys would have some script for the same.
(B
(B i have 8i and 9i instan
I need a parse alert log and mail me if there is any error.
I know Mogens (pronounced moans) and the guys at Miracle are working on GAPALPART
(Generic All-Powerful Alert Log Parser And Reporting Tool). That could be something
that you could use. I also know of a tool called MONO which
for one of the db over here alert log
is biggg .Looks like its never been truncated or backup .
Is it a problem if i just move this alert log file
to another directory , will oracle create a new alert log file ?
Do I need to bounce db ?
btw its 8.1.6 ( hp-ux )
-ak
just backup it ( cp alertDBSID.log backupalert.old) and empty it (echo
/dev/null alertDBSID.log) no need to bounce DB
rui
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 4:54
PMTo: Multiple recipients of list ORACLE-LSubject: alert
log file
for one
Title: Message
No problems, just move it. No need to shutdown, Oracle will just
create a new file next time it needs to write to it.
Moving the alert log should be something you do on a regular
basis.
Pete
"Controlling
developers is like herding cats."
Kevin
Loney, Oracle DB
You
can rename the alert log or move it. Oracle will create a new one the next
time it has to write to it. You don't need to bounce the
DB.
Dave
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 9:54
AMTo: Multiple recipients of list ORACLE
rename it, Oracle will create a new alert log file when it needs to
write to the alert log again
--- AK [EMAIL PROTECTED] wrote:
for one of the db over here alert log is biggg .Looks like its
never been truncated or backup .
Is it a problem if i just move this alert log file to another
If you move the alert log to another directory, Oracle will create a new
one in its place. There is no need to bounce the DB.
-Scott
At 07:54 AM 3/31/03 -0800, you wrote:
for one of the
db over here alert log is biggg .Looks like its never been
truncated or backup .
Is it a problem if i
Copy the alert log to the desired location and then
CAT /dev/null into the alert log.
CAT /dev/null alert.log
This will zero out the alert log and allow you to keep the old data.
Ron
[EMAIL PROTECTED] 03/31/03 10:53AM
for one of the db over here alert log is biggg .Looks like its
never
then
that
log line may be lost. As I said, it hasn't happened - yet -
that
I know of - but YMMV.
Cheers,
Mike
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 7:54
AMTo: Multiple recipients of list ORACLE-LSubject: alert
log file
for one
Title: RE: alert log file
We compress ours which makes them much smaller for storage. Oracle will create a new alert log file and there is no need to bounce the db.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From
thanks,
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 31, 2003 8:53 AM
rename it, Oracle will create a new alert log file when it needs to
write to the alert log again
--- AK [EMAIL PROTECTED] wrote:
for one of the db over
Hi all,
I am writing a script that can grep ORA- from alert log.
I think it will be good if I can grep the time of the error occur, can you please help
me?
If you are lazy to type please introduce me any related unix function, I will do man
the function myself.
Thanks
Sinardy
--
Please
Hi all,
I am writing a script that can grep ORA- from
alert log.
I think it will be good if I can grep the time of
the error occur, can you please help me?
If you are lazy to type please introduce me any
related unix function, I will do man the function
myself.
Thanks
Sinardy
Sinardy
provide some sense of the timing of the errors...
Hope this helps...
-Tim
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 1:33 AM
Hi all,
I am writing a script that can grep ORA- from alert log.
I think
Title: RE: Alert Log reporting question
Checkout http://www.zephyrus.com ... it is a very nice tool ...
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts
Xing [EMAIL PROTECTED] wrote:
Hi all,
I am writing a script that can grep ORA- from
alert log.
I think it will be good if I can grep the time of
the error occur, can you please help me?
If you are lazy to type please introduce me any
related unix function, I will do man the function
Has anyone ever seen a similar message to the following showing up in the
alert log and creating dump/trace files:
Mon Jan 13 09:45:22 2003
found dead shared server 'S000', pid = (9, 13)
Mon Jan 13 10:13:46 2003
Errors in file /u01/app/oracle/admin/ndi/bdump/ndi_s000_3556.trc:
ORA-07445
The EXTENT_MANAGEMENT column tells you if they are
locally managed or not. If they are local, then the
ALLOCATION_TYPE will be either UNIFORM, SYSTEM or
USER. The latter means it was originally a dictionary
managed tspace that has been converted to lmt.
But in any event, the coalesce is just
Title: alert log suppression
Is it possible to suppress successful DDL within the alter log?
For example, I have a cron job that coalesces 300+ tablespaces
which creates a couple line entry for each. I would like to
get feedback only if the DDL has actually failed.
TIA
The obvious question being why you are coalescing
tablespaces
--- Markham, Richard [EMAIL PROTECTED]
wrote: Is it possible to suppress successful DDL
within the
alter log?
For example, I have a cron job that coalesces 300+
tablespaces
which creates a couple line entry for each. I would
Title: RE: alert log suppression
ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and
I believe that SMON requires PCTINCREASE 0 to do routine
coalescing.perhaps you have further to add to your post.
-Original Message-
From: Connor McDonald [mailto:[EMAIL
Title: RE: alert log suppression
Richard,
If you are using UNIFORM extents (which is usually the best
option),you don't need to do any coalescing on LMTs.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Markham, Richard
To: Multiple recipients of list
Title: RE: alert log suppression
Coalescing LMTs is unnecessary !
-
Kirti
-Original Message-From: Markham, Richard
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002
12:00 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: alert log suppression
ok. They are LMT's
: Monday, December 16, 2002
1:30 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: alert log suppression
Richard,
If you are using UNIFORM extents (which is usually the best
option),you don't need to do any coalescing on LMTs.
Igor Neyman, OCP DBA[EMAIL PROTECTED
Title: RE: alert log suppression
If it
is LMT, coalescing is ignored.
-Original Message-From: Deshpande, Kirti
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002
10:34 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: alert log suppression
Coalescing LMTs
ry
managed tablespaces.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Markham, Richard
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 16, 2002 2:09
PM
Subject: RE: alert log suppression
Thanks for the info Igor. In addition
and NEXT_EXTENT;
they should be same.
HTH.
Arup
- Original Message -
From:
Markham, Richard
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 16, 2002 2:09
PM
Subject: RE: alert log suppression
Thanks for the info Igor. In addition to thisI am
of list ORACLE-LSubject:
Re: alert log suppression
Richard,
I have here versions 8.1.5 and 9.2.
Both show allocation type "UNIFORM" for LMTs with uniform
extent size (exceptLM SYSTEM and UNDO tablespaces in 9.2 , for which
"SYSTEM" allocation type is shown),
Hi
List,
Checking the alert
log file I found this error
ARC2: Completed archiving log# 3 seq# 736Mon
Mar 11 07:46:18 2002Thread 1 advanced to log sequence 738Mon Mar 11
07:46:18 2002ARC1: Beginning to archive log# 2 seq# 737Mon Mar 11
07:46:18 2002 Current log# 1 seq# 738 mem# 0:
D
the alert log file I found this error
ARC2: Completed archiving log# 3 seq# 736
Mon Mar 11 07:46:18 2002
Thread 1 advanced to log sequence 738
Mon Mar 11 07:46:18 2002
ARC1: Beginning to archive log# 2 seq# 737
Mon Mar 11 07:46:18 2002
Current log# 1 seq# 738 mem# 0: D:\ORACLE\REDO01.LOG
Current log
While the script approach is excellent, and you have gotten several
good answers on how to use it, might I suggest looking into event
triggers? If you are running 8i or above (not 8.1.5, it's buggy on
this), you can create a database level trigger ON ERROR. If you
have Java turned on for your
from
the latest entry, it writes that line and the remainder of the alert log file
to a mail message which gets sent to me.
I had a daemon process running that looked for changes in the file size, but
I didn't have a good mechanism for guaranteeing that the daemon was always
running other than
and the remainder of the alert log
file
to a mail message which gets sent to me.
I had a daemon process running that looked for changes in the file size, but
I didn't have a good mechanism for guaranteeing that the daemon was always
running other than using a cron job to check and restart
, it writes that line and the remainder of the alert log
file
to a mail message which gets sent to me.
I had a daemon process running that looked for changes in the file size, but
I didn't have a good mechanism for guaranteeing that the daemon was always
running other than using a cron job to check
. Every 15 minutes, it checks the file mod time against the current
time. If the file changed within the last 15 minutes, I open the file and
readlines checking the timestamp tags in the file. When it find the tag
from
the latest entry, it writes that line and the remainder of the alert log
Regarding alert log monitor...I have been using a highly adapted version of
Connor McDonald's, uses the dd command to clip off new sections of the alert
log. Here are a few of the features of my script.
* Will run from a single copy in a single NFS mounted directory.
* Can process oratab
Hi All,
Currently I am the only DBA for the 15 productin databases in our company.
I have written shell scripts on all database servers to parse the alert.log
file and look for Oracle errors and send page/E-mail if problems are found.
While this works it is sometimes painful to maintain - if I
-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L
Subject: Centralized Alert Log Monitoring
Hi All,
Currently I am the only DBA for the 15 productin databases in our company.
I have written shell
in SID names, etc.
Alert log monitoring is one of the scripts in this directory.
HTH,
Cherie Machler
Oracle DBA
Gelco Information Network
[EMAIL PROTECTED
Try AlertView, it's free, a gui tool for monitoring as many database
alert.logs as you want. Go to www.zephyrus.com to download it.
HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, January 07, 2002 1:57 PM
Hi All,
Currently I am
[EMAIL PROTECTED] wrote:
Hi All,
Currently I am the only DBA for the 15 productin databases in our company.
I have written shell scripts on all database servers to parse the alert.log
file and look for Oracle errors and send page/E-mail if problems are found.
While this works it is
Dennis,
I'm not sure if you have any NT boxes or not, but for the unix side have
you considered setting up an NFS share? You could store one copy of the
script there and mount that share on the db servers. Then just schedule it
like you normally would (cron,at). Depending how your script
[EMAIL PROTECTED]
riend.com cc:
Sent by: Subject: Re: Centralized Alert Log
Monitoring
[EMAIL PROTECTED
by: Subject: Re: Centralized Alert Log
Monitoring
[EMAIL PROTECTED
recipients
of list ORACLE-L [EMAIL PROTECTED]
riend.com cc:
Sent by: Subject: Re: Centralized
Alert Log Monitoring
[EMAIL PROTECTED]
01/07/02 01:27 PM
Please
.
Well, it never hurts to cast about for ideas on how to do it.
The cleanest way to me would be to have a daemon/Service
( one per database, unix or Win32 ) on the db server side that
monitors the alert log. All it would do is read the alert log, and
ship off new lines that appear ( via TCP socket
.
'Why even mention it?' you ask.
Well, it never hurts to cast about for ideas on how to do it.
The cleanest way to me would be to have a daemon/Service
( one per database, unix or Win32 ) on the db server side that
monitors the alert log. All it would do is read the alert log, and
ship off new
-8328
Ruth Gramolini
[EMAIL PROTECTED]To: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
ate.vt.uscc:
Sent by: Subject: Re: Centralized
Alert Log Monitoring
I hadn't really considered centralizing my monitoring scripts, for fear of
actually having to learn about TCP via perl. What I do have is a perl
daemon for each instance that monitors the alert log using tail -f flnm|.
I search each line as it is written for troubling errors. If any major
errors
Dennis:
I read an article in Oracle Magazine about a technique called
'Do-it-yourself
Views' (called DIY$ views in the article). The article is at
http://www.oracle.com/oramag/webcolumns/2001/index.html?diy_dynamic.html.
If you have 8i or above this would work for you. Basically, it allows
I like your plan a lot. I'd like to hear about you accomplish step 2.
I already use a centralized monitoring database to store statistical data
and use Excel to graph the results (or I was doing this last time I worked
with Oracle - still looking for my next position!).
Randy
-Original
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
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 Remote client
Nirmal,
Perhaps
: 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.
Any ideas pls.
Regards,
Nirmal.
--
Please see the official
1 - 100 of 170 matches
Mail list logo