Sending mails using plsql program


 
Thread Tools Search this Thread
Special Forums IP Networking Sending mails using plsql program
# 1  
Old 09-18-2006
Sending mails using plsql program

I am trying to send an email to personal id using plsql program. I have written a code in plsql using UTL_TCP package where opens the connections and then senda a mail. But when i execute the program mails are not being sent.

I typed "mail" command on the unix box and got the below result
==========================================
From MAILER-DAEMON Mon Sep 18 07:03:41 2006
Date: Mon, 18 Sep 2006 07:03:41 +0100 (BST)
From: Mail Delivery Subsystem <MAILER-DAEMON>
Message-Id: <200609180603.k8I63fOH029965@hwnej05.>
To: <artiscat@hwnej05>
Subject: Returned mail: see transcript for details
Content-Length: 4339

This is a MIME-encapsulated message

--k8I63fOH029965.1158559421/hwnej05.

The original message was received at Mon, 18 Sep 2006 07:03:41 +0100 (BST)
from localhost [127.0.0.1]

----- The following addresses had permanent fatal errors -----
<amolm@techmahindra.com>
(reason: 550 Host unknown)

----- Transcript of session follows -----
550 5.1.2 <amolm@techmahindra.com>... Host unknown (Name server: mailhost: host
not found)

--k8I63fOH029965.1158559421/hwnej05.
Content-Type: message/delivery-status

Reporting-MTA: dns; hwnej05.
Received-From-MTA: DNS; localhost
Arrival-Date: Mon, 18 Sep 2006 07:03:41 +0100 (BST)
Final-Recipient: RFC822; amolm@techmahindra.com
Action: failed
Status: 5.1.2
Remote-MTA: DNS; mailhost
Diagnostic-Code: SMTP; 550 Host unknown
Last-Attempt-Date: Mon, 18 Sep 2006 07:03:41 +0100 (BST)

--k8I63fOH029965.1158559421/hwnej05.
Content-Type: message/rfc822

Return-Path: <artiscat@hwnej05>
Received: from hwnej05. (localhost [127.0.0.1])
by hwnej05. (8.12.10+Sun/8.12.10) with ESMTP id k8I63fOH029963
for <amolm@techmahindra.com>; Mon, 18 Sep 2006 07:03:41 +0100 (BST)
Received: (from artiscat@localhost)
by hwnej05. (8.12.10+Sun/8.12.10/Submit) id k8I63fLW029962
for amolm@techmahindra.com; Mon, 18 Sep 2006 07:03:41 +0100 (BST)
Date: Mon, 18 Sep 2006 07:03:41 +0100 (BST)
From: Artisan Application user <artiscat@hwnej05>
Message-Id: <200609180603.k8I63fLW029962@hwnej05.>
==========================================

Could you please let me know what should i do to get rid of this problem.

I just know basics of Unix. Hence finding it difficult to resolve the problem.

Thanks & Regds
Amol
# 2  
Old 09-25-2006
Quote:
----- The following addresses had permanent fatal errors -----
<amolm@techmahindra.com>
(reason: 550 Host unknown)

----- Transcript of session follows -----
550 5.1.2 <amolm@techmahindra.com>... Host unknown (Name server: mailhost: host
not found)
The error is telling you that the host techmahindra.com can't be found in DNS.
Your code is okay, it's a DNS issue either on their side or yours (if that is a valid host).

Send a test email from hwnej05 to the email address:
$ mailx -s"test" youraddress@techmahindra.com < /dev/null

If you get the same type of error, then you know that your code was okay (as long as the spelling of the techmahindra.com is correct).

Then try to look up the mx address of techmahindra.com
$ nslookup
> set type=mx
> techmahindra.com

You should get info such as
Quote:
Server: some-server.in-your-domain.com
Address: some IP

TECHMAHINDRA.COM preference = 5, mail exchanger = ukgate.techmahindra.com
TECHMAHINDRA.COM preference = 5, mail exchanger = chandgate.techmahindra.com
...
If you don't get a response on the lookup, then your DNS isn't finding the MX record of the domain you are trying to send to and the email won't be sent.
# 3  
Old 09-26-2006
Thanks for the replay.

I tried to type the below command but getting error !!

$ nslookup
ksh: nslookup: not found
# 4  
Old 09-26-2006
What OS and version are you using? You can try /usr/sbin/nslookup but it may not be in that directory on your OS.
# 5  
Old 09-27-2006
Version is Sun OS 5.9 and below is the o/p for the command /usr/sbin/loopup

Default Server: icore-rylcr-55.nexus.btintra.com
Address: 147.149.2.69
# 6  
Old 09-27-2006
You need to re-run the nslookup command and set the MX and lookup the domain you were trying to find. All you put as the output of the command was the default message which shows which dns server you are pointing to run lookups against. The parts in bold are what you type

$nslookup
>set type=mx
>techmahindra.com
this will give you the output to post in this thread...
>exit
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Solaris

Sending Mails to the Multiple Email Address

Hi All, I am pretty new to the mail service in Sun Solaris 5.10. If anybody help me in writing a script for the multiple recipient with subject and the body would be a helpful. Kindly help... Thanks in advance. :) Warm Regards, Pramod (5 Replies)
Discussion started by: Pramod_009
5 Replies

2. Solaris

Crontab schedule sending two mails insted of one

Hi all, We have scheduled one cronjob which is supposed to show output through mails about 15 systems's current status (whether its up or down) but it send two mails one about 10 system which arrive at 5.30(actual scheduled time) and in second mail about 5 systems. We want all these... (1 Reply)
Discussion started by: manalisharmabe
1 Replies

3. Shell Programming and Scripting

Sending email from a unix program

Hi, I have create a unix prog file to validate data and send out an email. Below is the command used to send out email in the program. But it is not triggering the email. Please advice on this. (echo ${MESSAGE};uuencode "$FCP_OUT" "ERROR_REPORT.csv"; uuencode "$VALIDATION_RPT"... (1 Reply)
Discussion started by: contactsmrajesh
1 Replies

4. Shell Programming and Scripting

cron not sending external mails

This script is to send a email if the IP adress is active when i run this script it is working and sending emails to external users in different domains, but when this script is scheduled in a cron it is unable to send the emails #/bin/sh ifconfig -a | grep 192.168.0.1 if ; then mail -s... (10 Replies)
Discussion started by: robo
10 Replies

5. UNIX for Dummies Questions & Answers

Sending mails to various users without hard coding the email IDS

Hi Can any one help me out ? I am trying to send an autogenerated mail with an attachment to bulk of users using 'MAILX' and 'UNENCODE' . I have used it as follows X " ( cat /sastemp/body.txt; uuencode Test.xls.gz Test.xls.gz ) | mailx -s 'Testing' ' abcd@yahoo.com , efgh@gmail.com ' " ... (9 Replies)
Discussion started by: manas6
9 Replies

6. Shell Programming and Scripting

error while sending mails through MKS

#!/bin/ksh email0="dummy@company.com" emails() { # mail Generation echo "Hi" | /mapimail -s "-(Test Mail)From Production- `date`" $email0; } emails i receive the following error IDispatch::new MSMAPI.MAPISession failed: 800401f3 at... (0 Replies)
Discussion started by: Vrgurav
0 Replies

7. SuSE

How to configure Suse Enterprise Linux 9.0 for sending mails to smtp server...???

Hi All, I have a system running with Suse Enterprise Linux 9.0. xyz# uname -a Linux xyz 2.4.21-291-smp #1 SMP Tue May 24 14:07:45 UTC 2005 i686 unknown I would like to configure postfix on this system for sending mails as a root user using "mail" command to smtp server (Windows System)... (5 Replies)
Discussion started by: jumadhiya
5 Replies

8. UNIX for Advanced & Expert Users

sending mails with attachment and also some text in mail body

Hi, Can some one help me with the syntax of the mailx that should send an attachment and also some text in the message body together. When I am using the following syntax it is not sending the attachment but only the message body. unix2dos -ascii $REPORTFILE | uuencode $PCFILE | mailx -s... (7 Replies)
Discussion started by: guptan
7 Replies

9. UNIX for Dummies Questions & Answers

Sending Mass mails

Hi Forum, I am extremely new to unix.Can somebody please help me out with the following: I am supposed to write a script that will ftp a file which is a .csv and conatins the following: Mail-id Path of file abc@xyz.com D:\xyz\abc.htm ash@sde.com ... (1 Reply)
Discussion started by: iyerdeepa82
1 Replies
Login or Register to Ask a Question