Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: custom OEM tcl scripts

RE: custom OEM tcl scripts

From: <>
Date: Thu, 10 Apr 2003 06:38:47 -0800
Message-ID: <>


You can create custom tcl jobs which act like events in that they can monitor something and raise/clear alerts on the event pane. Look up unsolicited events in the on-line help system. (I don't have the diagnostic pack, and don't have a file called alert_custom.tcl. I don't think the event system supports the level of customization that you're looking for, but I'm not sure.)

One of our tcl scripts monitors the alert log. When it discovers an error message, it displays an alert to the event pane (displays the actual error message to the event viewer log). OEM keeps a history of server errors until I clear them. I also have some proactive type SQL jobs that also write messages to the alert log (a trick I learned from this list), and those messages are also picked up and displayed by the tcl same tcl job.

Feel free to contact me directly if you'd like more info. chaim

"Baylis, John" <> on 04/09/2003 01:34:09 PM

Please respond to

Sent by:

To: Multiple recipients of list ORACLE-L <> cc:

Does anyone have any procedures or can explain how I can implement a custom tcl script for Oracle 9.i?

I would like to create a new alert using an event similar to the test available for 'database\Fault\alert'

The 'database\Fault\alert' uses the tcl script \ora92\network\agent\events\oracle\rdbms\fault\alert.tcl

I would like to use

alert_custom.tcl looks for specific messages in the alert log

How can I implement this? Is there a way to get it to appear in the 'create events\tests' window?

Any help would be appreciated

John Baylis
Database Administrator
Canadian Forest Products Ltd.
Vancouver B.C. Canada

(604) 697-6476 (Office)
(604) 313-6054 (Cell)

Please see the official ORACLE-L FAQ:

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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).
Received on Thu Apr 10 2003 - 09:38:47 CDT

Original text of this message