This content has been marked as final. Show 4 replies
What have you actually put in the alert log filter? Cut and paste exactly please.
Note the bottom of 405396.1:
"If you define the Warning or Critical Threshold for the metric "Generic Alert Log Error Status" with just ORA- without any pattern behind, then the full ORA error number will be displayed in the alert (or in the notification if set). You will get for example:
"Message=ORA-error stack (00942) logged in <full path and name of the alert.log file>"
However in that case, as you did not specify any filter you will be alerted for all ORA- error messages recorded in the alert.log file. This must be kept in mind."
This is exactly your scenario.
Generic Alert Log Error Matches ORA-*
Generic Alert Log Error Status > 0
The above are the settings under Metric and Policy Settings
Can anyone just simply tell me how do I setup in grid control to get the details (from email) alert like below:
ORA-1653: unable to extend table ADM.PSGPUBDATA by 8192 in tablespace PIMAGE
other than the current setting of my grid control which just send me a email said: 'Hi you got a 1653 error, go to check your alert file for details'
Message was edited by:
You can't modify the settings of a email message of any type of ALERT . This is an action not supported because the code are embebed and it's not possible to edit.
You can do it two thinks:
If you create a UDM (User Define Metric) you can to edit the text of the SUBJECT in the alert mail, but only this.
Also, you can change the format of message. There are two options:
- Large Format
- Short Format
For this you must edit the emoms.properties in the sysman/config directory
Go to your database target.
On the home tab, on the left hand side under Diagnostic Summary, you'll see a clickable date link next to where it says 'Alert Log'. Click on that.
next click on Generic Alert Log Error Monitoring Configuration (its at the bottom)
In the alert thresholds put:
I believe that will pick anything up but experiment, its only perl.
If you want to test this use the DBMS_System.ksdwrt package but I would advise you only do so on a test database. If you've never heard of it, google it. Its a way of writing to your alert log.
Make sure you have your emails sent to long format as well.