| how to send tablespace alert to mail in oracle 10g [message #423664] |
Sat, 26 September 2009 03:58  |
|
|
Hi dears,
we have some creatical databases for those we need to enable email alert pariticularly for tablespaces usage space.
cau you guys help me to resolve this issue.
i tried using EM in 10g and able to send test mail but auto mail to send error is not sending.please help me.
thanks in advance.
regards,
sher khan
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: how to send tablespace alert to mail in oracle 10g [message #423696 is a reply to message #423689] |
Sat, 26 September 2009 12:21  |
|
|
Hi,
the whole process what i done is
when logon to EM.
i clicked on the setup and than provided the smtp server and my email .than i clicked on the testmail i reviced the test mail.
than i clicked on the preferences and provided database instances and host information.
than clicked to rule > there is already 4 -5 rules.> select the first one> and clicked the edit button
and set the tablespace usage%70 critical and other settings are default one.
than schedule this by same user (sys).
please guide me if there is step which i am missing .
i can recive test mail not critical or warning mail from database.
thanks & regard,
sher khan
|
|
|
|
|
|
| Re: how to send tablespace alert to mail in oracle 10g [message #423832 is a reply to message #423827] |
Mon, 28 September 2009 09:39 |
|
|
Hi dear,
when i connected with database > clicked on the preferences >
Notification Rules > there are 4 rules by default.
i am connected as user sys as sysdba.
clicked on the option button select the one existing one and than clicked on the edit button
Edit Notification Rule Agents unreachable.> select database instance > click Next
notification rules> selected up and down > clik NExt >
Metrics
sevrity states critical , warning,clear >
i select both critical and warnings and
selected tablespace space used(%)
than clicked Next>
it asking for tablespace name i selected all tablespaces.clicked Next>
checked mark send email check box and click next > clicked finished
showing preview.
now one question is how to schedule specific rule in the database. ( this may be error.)
i just select option button and clicked on the schedule > than edit schedule.>
than put my email.
but stil am not able to recive any mail from database although test mail i can recive.
thanks
last page output.
Edit Notification Rule Agents Unreachable: Review
This summarizes how and when Enterprise Manager will send notifications for this rule.
Step 7 of 7
Properties
Name Agents Unreachable
Owner SYSMAN
Description System-generated notification rule for monitoring Agents who lose contact with the Management Service due to network problems, host problems or Agents going down.
Public No
Target Type Database Instance
Targets
All targets of type Database Instance
Availability
Up No
Down Yes
Agent Unreachable Yes
Agent Unreachable Resolved Yes
Metric Error Detected No
Metric Error Resolved No
Blackout Started No
Blackout Ended No
Metrics
Severity States
Critical Yes
Warning Yes
Clear No
Metrics
Metric Objects
Tablespace Space Used (%) SYSAUX,USERS,TEMP,SYSTEM,UNDOTBS1
Methods
E-mail Notification
E-mail messages will be sent at times specified on your notification schedule.
Advanced Notification Methods
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
