Oracle Database Discussions

Hi,

i don't know if this was already discussed here, but i didn't find a thread about this.

We use the UTL_SMTP Package in our production 10.2.0.4 database to send some statistics to the department. This works very nice since we established the Microsoft Exchange Server 2010.

The problem is that the mail is arriving without any content. (it has the right title but no content)

we already solved another little problem:
-----
-->The only thing which is different to the old exchange is, that you have to declare complete adresses.

For example:
UTL_SMTP.open_connection ('<server_name>.<domain>', 25); -- the adress of the mail-server
or
UTL_SMTP.rcpt (mail_conn, '<recipient>@<domain>'); -- adress of the recipient

Without a complete adress (without domain for example) only the old echange(2003) accepts the mails. (of course only at domain-internal mail-communication)
-----

So now the mails are arriving but they have no content. I think there is no problem with the usage of the UTL_SMTP-package.

The new exchange system is clustered and now there are two dns-entries:

One points to an "HUB & CAS"two-server-aktiv-aktiv cluster which is working like a load-balancer(my simplified sight, it is also called NLB[Network Load Balancing] Cluster ) and forwards the mails to one of the tree new exchange-db-server or send it to the old exchange server(if the old exchange is even the owner of the recipient-"post-box"!?).

The other one points direktly to the old exchange server.


The Problem accours only in mails with the destination to the new exchange system.
It is no general problem because mails from some CLI-Tools or other programs to the new system arriving without any problem (and with content :-) ).

I hope someone has an idea.
We have the same problem when we mail to an recipient whose post-box is owned by the new exchange.
So the problem will also be there when we move all our "post-boxes" from the old to the new Exchange.

Thanks in advance

Edited by: MaLau on 06.10.2010 04:00

Edited by: MaLau on 06.10.2010 05:22