Re: utl_smtp issues
- From: Surachart Opun <surachart@xxxxxxxxx>
- To: oracledbaquestions@xxxxxxxxx
- Date: Wed, 24 Feb 2010 23:31:24 +0700
utl_smtp ... use smtp_out_server parameter
- How about smtp_out_server parameter?
SQL> show parameter smtp_out_server
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
smtp_out_server string smtp.domain.com
On Database server ... check
$ telnet smtp.domain.com 25
- write pl/sql program to test, check error and ask sysadmin about maillog
on Mail Server.
Good Luck
Surachart Opun
http://surachartopun.com
On Wed, Feb 24, 2010 at 11:23 PM, Dba DBA <oracledbaquestions@xxxxxxxxx>wrote:
> Oracle: 10.1.0.3
> OS: Solaris 64 bit
>
> We have used utl_smtp for emailing for years. Now all of a sudden on some
> of our servers, mail is not being sent when we use utl_smtp. Nothing in the
> datbase has changed. mailx on the unix server works fine.
>
> What does utl_smtp do under the cover to send mail? I am assuming it makes
> some OS calls to send mail? There was probably some OS/network change or
> something. However, it is easier to track down if someone can help me figure
> out what utl_smtp does under the covers.
>
> it does not appear to use mailx since mailx still works.
>
Other related posts:
