Server Administration :: Alert Email Notifications?

Mar 20, 2011

I'm trying to set up alert notifications. I have to program it myself, because SE isn't allowed to do it with OEM. As far as I can see from the documentation, this should be all that is necessary:

conn / as sysdba
exec dbms_aqelm.set_mailhost(mailhost=>'127.0.0.1')
exec dbms_aqelm.set_mailport(mailport=>25)
exec dbms_aqelm.set_sendfrom(sendfrom=>'alert@noreply')

[Code]......

but this gives me:

ORA-24940: invalid combination of ANONYMOUS namespace, default presentation and
e-mail receive protocol
ORA-06512: at "SYS.DBMS_AQ", line 737
ORA-06512: at line 11

I must be missing something! Probably something very basic. There is nothing in any trace files.

View 2 Replies


ADVERTISEMENT

Workflow :: To Send Notifications To Multiple Supplier Email IDs?

Aug 26, 2013

I have a custom concurrent program which has a SQL query which returns multiple rows. Each row is a for each supplier e.g. 

Supplier1      sup1@gmail.com     123     5000Supplier2      sup2@gmail.com      456    4000Supplier3      sup3@gmail.com      789    3000 

This set is returned based upon some criteria mentioned in the where clause of the SQL.Ultimate aim is to send 1 notification to each of the email id's and those notification should have the corresponding attribute values. 3 notifications fired from a workflow triggered by the concurrent program (which actually returns this 3 rows in a SQL)Supplier 1 to receive  5000Supplier2 to receive  4000Supplier3 to receive  3000 My approach / or the only approach coming in mind is using a cursor for the SQL inside the concurrent program and using a for loop, initiating the workflow each time for a loop iteration i.e for each iteration of loop , workflow procedure will need to be initiated, so item type will be same but item key will of 3 different item key.  is it somehow possible to fire only one instance of workflow and not 3 different instances to send 3 notifications. Ad hoc role creation would not be option here because the number of rows may be large and not just 10-15.

View 0 Replies View Related

Sending Email Notifications / Alerts Via Enterprise Manager 11g

Feb 24, 2013

I have Oracle 11g on Linux...and i have set up SMTP of my Enterprise Manager Database control. I click on Test and an email was sent successfully. What i don't know is how to add more emails as the recipient of the alerts.

I have setup metrics like number of sessions, cpu usage, buffer cache hits, swapping, tablespace usage, etc...Upon saving and waiting for transactions to come in, alerts were shown the the EM homepage..but i did not receive any emails.

View 2 Replies View Related

Test Instance With Oracle 11gR2 - EM Sending Email Notifications Too Late

Feb 18, 2013

On a test instance with Oracle 11gR2 with Enterprise Manager Database Control I try to activate the Email Notifications in Enterprise Manager, so that I can use them for monitoring.

So i configured following settings:

Under Setup -> Notification method I gave him a valid mail address with a vaild SMTP server. The test mail was send successfully.

Under Preferences -> General i gave SYS a valid mail address to receive. The execution plan i let in standard configuration, so every time at everyday i will get an email, when something happens. the test mail was send successfully too.

Now i created an own rule to test the configuration:

I went to Preferences -> Rules an add an rule. Name and description I named "test" and set "database instance". At availability I activated all checkboxed, so i should be informed when the instance goes down, comes up, getting an error, when the error is fixed, when agent is not available, when agent is available again, when there is a metric error, when the emetic error is fixed, when a blackout starts and when it ends.

Metrics, policies and jobs there wasn't defined anything in standard, so i let it so and set nothing here. I activate the checkbox for sending emails to sys and sending repeat emails every 15 minutes 3 times at all.

Now, to test this notification i logged into my testserver and killed the listener process, to see, what will happened. After 1 Hour waiting i didn't get any email, so i restarted the listener. after the listener was started my outlook was fluted by emails from the server, that the listener was down. But why i didn't get them earlier.

I checked the procedure with the database to, here i get it down by "shutdown abort" and "shutdown immediate". But i get the mails, that the database is down, when its up already. And thats to late!

When I want to use such email notifications for productive servers and someting is going wrong, for that a notifications is configured of course, I want to get the mail directly, when that happened and not, hen the problem is fixed!

For example, here an email from testing, where the listener was down, that i've get at 13:01 :

Target Name=LISTENER_<hostname>
Target Type=Listener
Host=<hostname>
Metric=Status
[code].........

View 2 Replies View Related

Script To Email Alert Log

Aug 24, 2013

I have been looking for a script to email me a daily log of my alert log. I have tried mailx -s command,

View 1 Replies View Related

Scheduler :: How To Add Email Notifications To A Scheduler Program

Aug 9, 2013

We have a scheduler chain that calls 2 scheduler programs.The chains are controlled by a scheduler job that has job_type as CHAIN.My challenge is how to add email notifications on the failure or success of the programs.

I know about this procedure DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION, but this is only applicable to jobs and not programs(i believe). Is there an alternative way to trigger off emails for scheduler programs ?

View 0 Replies View Related

Email Alert Log Daily Script Cron Job

Jun 10, 2013

I'm working on my test db and what I thought to be an easy task is turning out to be very difficult. I am trying to set up a cron job to email me daily the alert log to check for errors. I tested the script and it is not working this is what I have to email me the alert log

mailx -s "Alert Log for Testdb" oracleexample@gmail.com > /testapp/oracle/diag/rdbms/testdb/testdb/trace/alert_testdb.log

View 3 Replies View Related

Server Administration :: Sys To See Alert Log?

Oct 18, 2011

one can only see the alert log, trc ...with sys log in?

View 12 Replies View Related

Server Administration :: Alert Log For ASM

Jul 13, 2010

Is there any separate alert.log for ASM instances?

SQL> show parameter BACKGROUND_DUMP_DEST

The above will give the dest of the alert.log for DB only?Is is the same for ASM instances? If different then where to look for.

View 2 Replies View Related

How To Change Port Number Of Email Alert Notification

Nov 24, 2010

I want to configure the Email Alert Notification in OEM.

In OEM --> Setup --> Notifications Methods --> I am able to see a provision to enter SMTP Address, but there is no port number.

Due to some security policies, my company has opened only Port Number : 9925 for SMTP and blocked Port number : 25.

When I click on "TEST MAIL SERVERS" button, it gives me a error that :

"Test failed with message : Could not connect to SMTP Host , Port No. 25" .

Now I want to change this port number 25 to 9925.

View 5 Replies View Related

Server Administration :: Outdated Alert Log?

Mar 4, 2010

Our dev server has 7 instances on it (in one box). I noticed that most of it's alert logs are not up-to-date (generation is delayed by almost 1 week). What should I supposed to do with it?

View 6 Replies View Related

Server Administration :: Command To Open Alert Log

Dec 17, 2012

Which command is the right way to open a alert log file of below size.

-rw-r----- 1 oracle asmadmin 28070129 Dec 17 08:06 alert_DEMO.log

I used to open a alert log file using vi editor. Is that a right way to open and view a alert log ?

View 5 Replies View Related

Server Administration :: Where To Find Alert Log Errors

May 10, 2010

where i can find an alert log errors so whenever they occur in my RAC so i can comprehend them very well. I am trying to know that what can be the errors when u have RAC with ASM and SAN .

View 3 Replies View Related

Server Administration :: Mail Whenever Error Registered In Alert.log?

Jul 23, 2012

I want to mail any "ora" errors registered into alert.log file. is it possible if yes then how can i do it.

View 22 Replies View Related

Server Administration :: DBMS_SERVER_ALERT Tablespace Full Alert Timing?

Oct 20, 2013

Tablespace usage alerts are checked every ten minutes. You can request a check every minute when you set the threshold, and confirm that this has been set:

orclz> execute DBMS_SERVER_ALERT.SET_THRESHOLD(-
> metrics_id => DBMS_SERVER_ALERT.TABLESPACE_PCT_FULL,-
> warning_operator => DBMS_SERVER_ALERT.OPERATOR_GT,-
> warning_value => '50',-
> critical_operator => DBMS_SERVER_ALERT.OPERATOR_GT,-
> critical_value => '75',-

[code]....

orclz>but you will still have to wait up to ten minutes for the alert to be raised. know whether this frequency can be changed? And why this particular alert behaves differently from all the others? This is the bahaviour in all releases since server alerts arrived.

View 2 Replies View Related

Server Administration :: Event Alert Created Successfully On Custom Table But Not Firing?

Mar 8, 2013

I have created custom table in inventory and after register table & columns, i create event alert on it. event alert is not firing.

View 1 Replies View Related

Server Administration :: Create User Email

Mar 22, 2011

I want whenever a user is created in database the server send me a mail about this.

View 3 Replies View Related

Scheduler :: Notifications Not Being Sent

Mar 17, 2013

why the Scheduler is not sending out notifications for a job I am running.I set up a small job that calls a programm which references a stored procedure. The procedure executes a manual refresh of a materialized view.

I did set up the SMTP parameters EMAIL_SENDER and EMAIL_SERVER, restarted the instance afterwards and verified that the parameters are set by logging into the Enterprise Manager web console and looking at the page with the email server parameters.

I did verify that the job did actually start and complete successfully by checking the logs in ALL_SCHEDULER_JOB_RUN_DETAILS

I did verify that I actually do have the notifications activated by checking ALL_SCHEDULER_NOTIFICATIONS...There are notifications for all events (JOB_STARTED, JOB_COMPLETED, JOB_SUCCEEDED, JOB_FAILED, etc.) for my job

I also verified that the materialized view has actually been refreshed by checking in ALL_MVIEW_REFRESH_TIMES

I also verified that the email server I am using is sending out emails by sending a test email from the shell using the same sender and recipient addresses as I am using in the notification settings.What could the reason be for the scheduler not sending out emails?

View 7 Replies View Related

ORA-1403 Encountered When Generating Server Alert?

Jun 7, 2012

how to resolve the below error.. I am getting this error on the alert log .. oracle DB version is 11.2.0.1 and os is AIX6.1

ORA-1403 encountered when generating server alert SMG-4121 Thu Jun 07 13:38:27 2012
ORA-1403 encountered when generating server alert SMG-4121 Thu Jun 07 13:39:00 2012
ORA-1403 encountered when generating server alert SMG-3503 Thu Jun 07 13:43:27 2012
ORA-1403 encountered when generating server alert SMG-4121 Thu Jun 07 13:48:27 2012

View 4 Replies View Related

Workflow :: When Set Vocation Rule - It Stuck All The Users Notifications

Sep 3, 2012

I am working on Workflow and the issue is When a person leaves for vacation he can set his vacation rules so that someone has to attend / approve his workflow notifications. But when we set vocation rules all notification goes into errors state and this error can resolve by refreshing/Retry this notification. And the error detail is mentioned below An Error occurred in the following Workflow.

Item Type = CONCSPL
Item Key = 086937-15990
User Key =

Error Name = 100
Error Message = ORA-01403: no data found
ORA-01403: no data found
Error Stack =
Wf_Engine_Util.Function_Call(cust_f_test.f_find_approver, CONCSPL, 086937-15990, 180198, RUN)

[code]....

Bottom line is all notifition should be successfully process and send to dedicated person.

View 2 Replies View Related

Server Utilities :: Send Email After Export Done (successfully Without And With Error )

Jun 16, 2011

I have a ORACLE 10g(10.2.0.1.0) database that I am running on windows. I have export backups batch file running every day through windows scheduler. I would like to know If there is some way that sends me an email after the backup is finished and also send me if it does not finish with error.

I have successfully done this om my SQL Server machine but don't know for ORACLE as I have not purchased it and have license

View 16 Replies View Related

Server Administration :: Create Tablespace For Administration

Nov 29, 2010

i'm a student currently learning database administration security.

I need to create a tablespace for administration of database but i don't know what datafile settings are best suited for admin usage.

I have attached the schema that was given to me for this assignment.

View 12 Replies View Related

Multiple Alert Log In 10g RAC

Jan 9, 2013

We have Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit RAC in Linux and syslog server also in Linux.

syslog server is a centralize server to monitor all the system and database log.

is there any way to create a multiple alert log file. so that we can keep one alert log file in default location and another alert log file in centralize syslog server for monitoring purpose.

View 3 Replies View Related

Alert Log Monitoring?

Jul 23, 2012

I'm using this logic to avoid specific error.Does not seem to be working fine. Any other method to exclude perticular error from monitoring.

if [ -n "$line_no1" -o -n "$line_no3" ] ; then
cat $script_loc/alrt_chk.log | grep -i "ORA-" > $script_loc/ora_alert_only.log
#----
echo "Entering in while Loop"

[code]...

View 2 Replies View Related

XML - Formatted Alert Log?

Jul 7, 2013

 My database version is 11.2.0.3  Is there any added advantage using XML-formatted alert log file over text format alert log?

View 4 Replies View Related

How To Access Alert Log Using Sql

Aug 21, 2012

How can we access Alert log using sql, without sys privilege in oracle 11g ?

View 17 Replies View Related

How To Set Tablespace Alert Message

Aug 11, 2012

How can i set alert message for users tablespace.

for ex

My users(tablespace) data file size is 100m . If 90m reached , i need some alert message through email or mobile.

Os : linux 4
version :10.2.0

View 2 Replies View Related

Finding Alert Log File

Dec 23, 2011

How can i come to know that which current alert log file is being used for database? Is their a command at database level to find out the current alert log file to which database is using ?

View 2 Replies View Related

Is It One Alert Log Per Instance Or One Per Database

Jul 28, 2010

Is it one alert log per instance or one per database? My guess would be per instance, but I have some documentation that indicates per database.

View 4 Replies View Related

Forms :: Pop-up Or Alert On Desktop?

Nov 10, 2012

i am using .dot net frame work to show a pop up on desktop like reminder , can i do that using any oracle tools i am using oracle 10g along with forms 6i , i am using one query for this.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved