RE: Alert Log & SQL

Is your user using the client version of SQL*Plus or the SQL*Plus that is installed on the server that the database is on?? If they are using the one that is on the server that the database is on, they could use the HOST command from within SQL*Plus to issue the host operating system commands and do a TAIL on the alert_sid.log file.

HTH -::BOB::-
<)))><

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