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
ADVERTISEMENT
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
Dec 11, 2012
I the past when working with apex 3 I was able to work with apex mail send very nice. In apex 4.0 with oracle 11g ee I'm not able to send emails anymore.
Last error message in the queue is:
ORA-29279: SMTP permanent error: 550 through this server without authentication.
the smtp server has not been changed, the code is fine. How I can go further?
View 20 Replies
View Related
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
View Related
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
Jun 13, 2012
I've just patched a development oracle environment (RAC 11GR2) with temporary patch 8730312. I would like to do same thing on Production RAC. Is it necessary to test all applications on dev environment with this kind of patch before deploy it on Production ?
View 2 Replies
View Related
Apr 4, 2011
How to send an email through oracle FORMS6i ?
View 1 Replies
View Related
Nov 23, 2010
How to Sending Email With PDF File attachment.
View 3 Replies
View Related
Feb 14, 2010
I have been working on sending an email with a pdf attachment.I succeeded in PDF attachments with size <32 K.The steps I Used :
1.created a directory 'EMAIL' that points to the directory containing my pdf file.
2.
declare
vInHandle utl_file.file_type;
flen number;
bsize number;
ex boolean;
l_Output raw(32767);
fname varchar2(30) := 'labels.pdf';
vSender varchar2(30) := some1@hct.edu.om';
[code].....
It send the email <32 k.But for >32 K it give me the error :
ORA-06502: PL/SQL: numeric or value error: raw variable length too long
ORA-06512: at "SYS.UTL_ENCODE", line 243
ORA-06512: at "SYS.UTL_MAIL", line 118
ORA-06512: at "SYS.UTL_MAIL", line 324
ORA-06512: at "SYS.UTL_MAIL", line 414
ORA-06512: at line 18
I know it has something to do with blob or clob ....where i can modify my code to work.
View 17 Replies
View Related
Sep 3, 2013
In the database there is a job that monitors the delivered date.5 weeks before this date a email is send.I this mail i would like to implement a notification button. the receiver will get a mail with notification:o Yes i will succeedo No, i wil not succeed this answer has to be send back to the sender . how to do this. note: the receivers can have different mail clients!
View 10 Replies
View Related
May 1, 2009
I have the following code to send an email with a report as an attachment via forms. everything is running fine.
Now i do not have a message body in the email, so my question is how do i add some text as an email body
if i add the following parameter, its not working
ADD_PARAMETER(thelist, 'BODY',TEXT_PARAMETER, 'Check the attached Report');
DECLARE
report_id REPORT_OBJECT := find_report_object('checklist');
report_message VARCHAR2(100) :='';
rep_status VARCHAR2(100) :='';
[code]....
View 6 Replies
View Related
Jan 6, 2011
I have this stored procedure that does implements some business logic and then sends an email.
I got the below error when it tried to send the email
Quote:Returned values:
ERR_CODE =-29279,
ERR_MESSAGE = "MSS DATABASE INCONSISTENCYOTHERS EXCEPTION in XCOM_X080_SUBMITORDER - SQL -29279 SQLERRM: ORA-29279: SMTP permanent error: 501 5.5.2 Syntax error in parameters scanning "TO""
How can I handle this error using exception and in case sending email fails instead of abnormal exit ?
View 2 Replies
View Related
Apr 23, 2010
How to send email from Oracle forms10g to a yahoo or gmail account using authentication.
View 5 Replies
View Related
Jun 15, 2010
I am using the following code on a button and once I pressed the button the form disconnected.
Declare
Outlook_Object client_OLE2.OBJ_TYPE;
Mail_Object client_OLE2.OBJ_TYPE;
Item1 client_OLE2.OBJ_TYPE;
Item2 client_OLE2.OBJ_TYPE;
OLEPARAM client_OLE2.list_type;
[code]....
View 2 Replies
View Related
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
Apr 22, 2013
What is the usage of UTL_HTTP?
Will I be able to send e-mail with UTL_HTTP to an external mail id?
View 5 Replies
View Related
Apr 22, 2009
I have a refresh group that will refresh several materialized views at 4:00am. Sometimes the job failed. We need to enter to the enterprise manager to check the status of the refresh group.
Our target is that notification email is sent to our email once the refresh job failed. I have found some software that can do that. However, we need to handle ourselves. I would like to ask whether we can do that using enterprise manager.
View 7 Replies
View Related
Oct 7, 2013
I have to embed a picture as a header with an e-mail content for my work, I google'd and tested with different options but I failed. (The JPG is stored in a table as a blog object) When I tried with the below code the JPG file is e-mailed as an attachment with an e-mail content, I want it to be displayed inside an e-mail.
I tried att_inline: TRUE option as well - still not working.
Here is my code I tested and worked as an attachment.
DECLARE
/*LOB operation related varriables */
v_src_loc BLOB :=EMPTY_BLOB;
l_buffer RAW(54);
l_amount BINARY_INTEGER := 54;
l_pos INTEGER := 1;
l_blob BLOB := EMPTY_BLOB;
[code]....
View 3 Replies
View Related
Aug 5, 2012
I have a system that has issues with sending some emails.
When the email sending process is activated the pages just hang.
Are there any logs or anything like that anywhere that i could look at to try and make sense of it.
View 1 Replies
View Related
Jul 3, 2010
I am planning a single instance database using Oracle 11gR2 Enterprise. The instance will run on OEL 5.5 which is on VMWare ESX 3. All disk space will be provisioned as VMDKs. The physical disk comes from a NetApp 7 controlled SAN with multiple disk arrays (one fast disk array and one slower disk array) using NetApp's RAID-DP (RAID-6).
Is there any benefit to using ASM in this single instance configuration ? It seems the data is already being striped, balanced, deduped, and (somewhat) protected by ESX, NetApp, and RAID-DP. NetApp SnapShot provides additional back-up options.
I am thinking without ASM, I could have one 1 TB LUN, say /u01, for the binaries, data files, and management files on the fast disk array and one 1 TB LUN, say /r01, for the flashback recovery area and all other recovery related files on the slower disk array. With autosize capabilities, any of the files can expand as needed up to the 1 TB capacity. 1 TB per disk array is the resource allocation for this instance.
With ASM, on the fast disk array I would have one 32 GB LUN for binaries and other files which must be outside of Oracle's CFS under ASM and then four 248 GB LUNs to create the ASM disk group DATA. On the slower disk array I would have four 256 GB LUNs to create the ASM disk group FRA.
View 1 Replies
View Related
Aug 3, 2012
upgrading a single instance 10.2.0.2 database of approx size 2TB to 11.2.0.3 rac 2 node db on linux.
View 3 Replies
View Related
Sep 16, 2006
I have a Database of My all customers Mobile Nos I want to send SMS to all customer from Oracle Database using Pl/SQL or any inbuilt Oracle Package, if available or through Oracle forms
How i can send SMS to my Customers through Oracle PL/SQL or Oracle forms or any other front end and what are the additional requirement in sending SMS and what utilities are needed .
View 7 Replies
View Related
Jun 16, 2013
i'm trying to send Arabic sms to mobile but the the message come in this way "?
View 29 Replies
View Related
Nov 23, 2010
i am able to send text/ csv attachment thru oracle PL/Sql Procedure. But i am facing this for excel attachment, some junk character is coming while opening that attachment excel file.
i am attaching here with my coding for your view. Anything i have to configure at my SMTP server.
View 5 Replies
View Related
May 21, 2008
Below code working fine when i am using Forms6i. But i want to send a mail by Forms10g.
declare
objOutlook OLE2.OBJ_TYPE;
objMail OLE2.OBJ_TYPE;
objArg OLE2.LIST_TYPE;
objAttach OLE2.OBJ_TYPE;
BEGIN
objOutlook := OLE2.CREATE_OBJ('Outlook.Application');
-- Previous example usually used 'mapi.session' but this doesn't work correctly
--anymore.
objarg := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(objarg,0);
objMail := OLE2.INVOKE_OBJ(objOutlook,'CreateItem', objarg);
OLE2.DESTROY_ARGLIST(objarg);
objAttach := OLE2.GET_OBJ_PROPERTY(objmail, 'Attachments');
[code].........
View 5 Replies
View Related
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
Aug 29, 2012
recently i have tried to upgrrade from oracle 11.2.0.2 to 11.2.0.3 in a test environment (virtual machine).
there i have mentioned the SID as ORCL, but when we took the same snapshot to other machine (VM). iam unable to connect to the VM, unless i gave the local net service configuration as ORCL but it is unable to connect. but when i ran the query "select * from GLOBAL_NAME" output was ORCL. domain. com again i have configured in LNSC as ORCL.DOMAIN.COM it is working.
but i have given the sid as ORCL..
View 5 Replies
View Related
Sep 24, 2010
I've written a pl/sql to send mail. It works fine. Now i want to modify it to send an attachment txt/scv/xls file.This file is residing on client's pc.How to do it?
Following is pl/sql for sending mail.
create or replace PROCEDURE SEND_MAIL(P_SENDER IN VARCHAR2,P_RECIPIENT IN VARCHAR2,P_MESSAGE IN VARCHAR2,P_SUBJECT IN VARCHAR2 )IS
MAILHOST VARCHAR2(30) := 'MAILHOST.TIFR.RES.IN';
MAIL_CONN UTL_SMTP.CONNECTION;
BEGIN
MAIL_CONN := UTL_SMTP.OPEN_CONNECTION(MAILHOST, 25); -- TYPICALY 25 S THE PORT NUMBER FOR INCOMMING SMTP REQUESTS ON YOUR SMTP MAIL HOST
UTL_SMTP.MAIL(MAIL_CONN, '<'||P_SENDER||'>'); -- THE '<' AND '>' DEPEDS ON WHAT TYPE OF SMTP MAIL HOST U'RE RUNNING THIS ONE'S A NETSCAPE SMTPHOST
[code]......
View 2 Replies
View Related
Jul 17, 2012
OS: RHEL 5.7 64 bit
DB: 11.2.0.2 Standard Edition 64 bit
Everyday EOD is run and after the eod, users are requesting to receive a mail confirming the same from the database. For this we need to configure automated email which will be sent to a list of users email ID immediately after the EOD is done.
View 3 Replies
View Related
Jul 30, 2013
i have created a dblink between oracle and mssql and tried testing the link its giving me below error.
SQL Error: ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified {IM002}
ORA-02063: preceding 2 lines from MSSQL
28500. 00000 - "connection from ORACLE to a non-Oracle system returned this message:"
*Cause: The cause is explained in the forwarded message.
*Action: See the non-Oracle system's documentation of the forwarded message.
I have checked the dsn data source i have created, i am able to test the DSN successfully.
View 2 Replies
View Related