RE: Alert Log & SQL

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Tue, 19 Sep 2000 14:05:35 -0400
Message-Id: <10624.117372@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C02264.354EB780
Content-Type: text/plain;

charset="iso-8859-1"

I do not know about any V$ view that can help you but you can use utl_file package to read alert.log file from pl/sql procedure or anonimous bloc.

Alex Hillman

-----Original Message-----
From: Mark Leith [mailto:mark_at_cool-tools.co.uk] Sent: Tuesday, September 19, 2000 1:16 PM To: Multiple recipients of list ORACLE-L Subject: RE: Alert Log & SQL

Thanks for the reply Ruth, but I need (would like anyway:) to do this through SQL if at all possible. The request is by a user of the tool in "Virtual" mode, who wants to know about any new entries to the alert log. They check this every morning on 39 databases across 20 servers manually, but once they have done that any new alerts after say 9:30am - after they have finished - will be missed until the next day..

So if an error does occur on one of these systems, is there anyway via SQL for me to know?

-----Original Message-----
Gramolini
Sent: 19 September 2000 16:36
To: Multiple recipients of list ORACLE-L

You can download a free package called AlertView from www.zephyrus.com which will allow you to view messages that you select for viewing. It works very well. It runs on a PC.

HTH,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, September 19, 2000 11:10 AM

> Gurus,
>
> Is it possible to establish whether there has been any new entries, or in
> fact just read the Oracle alert log with SQL?
>
> The reason - We have a tool that can monitor the alert log when it has an
> agent which is local to the instance, and will in fact alert on any new
> entries. If the tool does not have a local agent though, this function
> becomes invalid.
>
> We can however set up a User Defined Collection to monitor this if we can
> return some value with SQL. Does Oracle store anywhere that it has written
> to the file? If so what does it store, and how can I query the database?
>
> All help appreciated..
>
> Mark Leith
> =================
> Cool Tools UK Ltd
> +44 1905 330 281
> mark_at_cool-tools.co.uk
>
>

--
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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: ListGuru_at_fatcity.com (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).

-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

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: ListGuru_at_fatcity.com (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).

------_=_NextPart_001_01C02264.354EB780
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: Alert Log &amp; SQL</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>I do not know about any V$ view that can help you but =
you can use utl_file package to read alert.log file from pl/sql =
procedure or anonimous bloc.</FONT></P>

<P><FONT SIZE=3D2>Alex Hillman</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Mark Leith [<A =
HREF=3D"mailto:mark_at_cool-tools.co.uk">mailto:mark_at_cool-tools.co.uk</A>]<=
/FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, September 19, 2000 1:16 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: RE: Alert Log &amp; SQL</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Thanks for the reply Ruth, but I need (would like =
anyway:) to do this</FONT>
<BR><FONT SIZE=3D2>through SQL if at all possible. The request is by a =
user of the tool in</FONT>
<BR><FONT SIZE=3D2>&quot;Virtual&quot; mode, who wants to know about =
any new entries to the alert log.</FONT>
<BR><FONT SIZE=3D2>They check this every morning on 39 databases across =
20 servers manually,</FONT>
<BR><FONT SIZE=3D2>but once they have done that any new alerts after =
say 9:30am - after they</FONT>
<BR><FONT SIZE=3D2>have finished - will be missed until the next =
day..</FONT>
</P>

<P><FONT SIZE=3D2>So if an error does occur on one of these systems, is =
there anyway via SQL</FONT>
<BR><FONT SIZE=3D2>for me to know?</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>Gramolini</FONT>
<BR><FONT SIZE=3D2>Sent: 19 September 2000 16:36</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>You can download a free package called AlertView from =
www.zephyrus.com which</FONT>
<BR><FONT SIZE=3D2>will allow you to view messages that you select for =
viewing.&nbsp; It works very</FONT>
<BR><FONT SIZE=3D2>well. It runs on a PC.</FONT>
</P>

<P><FONT SIZE=3D2>HTH,</FONT>
<BR><FONT SIZE=3D2>Ruth</FONT>
<BR><FONT SIZE=3D2>----- Original Message -----</FONT>
<BR><FONT SIZE=3D2>To: &quot;Multiple recipients of list ORACLE-L&quot; =
&lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, September 19, 2000 11:10 AM</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>&gt; Gurus,</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Is it possible to establish whether there has =
been any new entries, or in</FONT>
<BR><FONT SIZE=3D2>&gt; fact just read the Oracle alert log with =
SQL?</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; The reason - We have a tool that can monitor =
the alert log when it has an</FONT>
<BR><FONT SIZE=3D2>&gt; agent which is local to the instance, and will =
in fact alert on any new</FONT>
<BR><FONT SIZE=3D2>&gt; entries. If the tool does not have a local =
agent though, this function</FONT>
<BR><FONT SIZE=3D2>&gt; becomes invalid.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; We can however set up a User Defined Collection =
to monitor this if we can</FONT>
<BR><FONT SIZE=3D2>&gt; return some value with SQL. Does Oracle store =
anywhere that it has written</FONT>
<BR><FONT SIZE=3D2>&gt; to the file? If so what does it store, and how =
can I query the database?</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; All help appreciated..</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Mark Leith</FONT>
<BR><FONT SIZE=3D2>&gt; =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2>&gt; Cool Tools UK Ltd</FONT>
<BR><FONT SIZE=3D2>&gt; +44 1905 330 281</FONT>
<BR><FONT SIZE=3D2>&gt; mark_at_cool-tools.co.uk</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
</P>

<P><FONT SIZE=3D2>--</FONT>
<BR><FONT SIZE=3D2>Author: Ruth Gramolini</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: rgramolini_at_tax.state.vt.us</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from).&nbsp; You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing).</FONT>
</P>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Mark Leith</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: mark_at_cool-tools.co.uk</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =

Received on Tue Sep 19 2000 - 13:05:35 CDT