Kalau di RHEL 5 bagaimana ya untuk mengaktifkan SMTP Service nya.
Saya udah coba pakai postfix, dan SMTP nya sudah berhasil berjalan,,
tetapi tetap tidak bisa kirim e-mail dengan UTL_MAIL
Error starting at line 1 in command:
begin
utl_mail.send(
sender => '[EMAIL PROTECTED]',
recipients => ' [EMAIL PROTECTED]',
subject => 'Testing utl_mail',
message => 'The receipt of this email means'||
' that shutting down the database'||
' works for UTL_MAIL '
);
end;
Error report:
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 97
ORA-06512: at "SYS.UTL_SMTP", line 139
ORA-06512: at "SYS.UTL_MAIL", line 405
ORA-06512: at "SYS.UTL_MAIL", line 594
ORA-06512: at line 2
29278. 00000 - "SMTP transient error: %s"
*Cause: A SMTP transient error occurred.
*Action: Correct the error and retry the SMTP operation.
--- In [email protected], Izzudin Hanafie <[EMAIL PROTECTED]>
wrote:
>
> Bukan di databasenya tetapi di level OSnya...kebetulan saya disini
database servernya menggunakan OS : Windows 2003 Server..
>
> Regard's
>
> Izzudin Hanafie
>
> --- On Sat, 8/2/08, Bayu Kurniawan R <[EMAIL PROTECTED]> wrote:
> From: Bayu Kurniawan R <[EMAIL PROTECTED]>
> Subject: [indo-oracle] Re: Kirim e-mail dengan UTL_MAIL
> To: [email protected]
> Date: Saturday, August 2, 2008, 4:05 AM
>
>
>
>
>
>
>
>
>
>
>
> Cara untuk menghidupkan service SMTP di databse Oracle
XE bagaimana ya...
>
>
>
> --- In indo-oracle@ yahoogroups. com, Izzudin Hanafie <izzudin_aq@ ...>
>
> wrote:
>
> >
>
> > Sekarang sudah bisa...:). Ternyata service SMTP di database
>
> servernya belum hidup, makanya muncul error message seperti dibawah.
>
> > Pak Hendra, trigger dari DB untuk memanggil shell script template
>
> email itu sendiri bagaimana yaa bila mengunakan OS ..?.
>
> >
>
> > Regard's
>
> >
>
> > Izzudin Hanafie
>
> >
>
> > --- On Wed, 7/30/08, hendra chen <h3ndr4ch3n@ ...> wrote:
>
> > From: hendra chen <h3ndr4ch3n@ ...>
>
> > Subject: Re: [indo-oracle] Kirim e-mail dengan UTL_MAIL
>
> > To: indo-oracle@ yahoogroups. com
>
> > Date: Wednesday, July 30, 2008, 10:55 PM
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> > ya tergantung OS yang bapak gunakan.
>
> >
>
> > misalnya saya gunakan OS HPUX,
>
> >
>
> > ya saya setting dl n gunakan script shell untuk mengirimkan mail
>
> yang isi nya saya ambil dari DB.
>
> >
>
> > dari sisi DB ya kita gunakan query apa yang mau kita keluarkan,
>
> >
>
> > gunakan aja DBMS_OUTPUT untuk menampung hasil query yang mau di
kirim,
>
> >
>
> > atau spool , dan nanti isi nya bs di kirim berupa attach mail.
>
> >
>
> >
>
> >
>
> > --- On Thu, 31/7/08, agus purwanto <purwanto_ags@ yahoo.com> wrote:
>
> >
>
> > From: agus purwanto <purwanto_ags@ yahoo.com>
>
> >
>
> > Subject: Re: [indo-oracle] Kirim e-mail dengan UTL_MAIL
>
> >
>
> > To: indo-oracle@ yahoogroups. com
>
> >
>
> > Date: Thursday, 31 July, 2008, 9:46 AM
>
> >
>
> >
>
> >
>
> > caranya gimana ya pak kalo dari OS ?
>
> >
>
> >
>
> >
>
> > ----- Original Message ----
>
> >
>
> >
>
> >
>
> > From: hendra chen <h3ndr4ch3n@ yahoo. com.sg>
>
> >
>
> >
>
> >
>
> > To: indo-oracle@ yahoogroups. com
>
> >
>
> >
>
> >
>
> > Sent: Thursday, July 31, 2008 9:42:41 AM
>
> >
>
> >
>
> >
>
> > Subject: Re: [indo-oracle] Kirim e-mail dengan UTL_MAIL
>
> >
>
> >
>
> >
>
> > jika memang ada masalah dalam package UTL_MAIL,
>
> >
>
> >
>
> >
>
> > gunakan saja tools OS untuk kirim email,
>
> >
>
> >
>
> >
>
> > saya sih lebih suka gunakan OS punya,krn jika DB down, saya bs tau,
>
> krn email nya tetap terkirim.
>
> >
>
> >
>
> >
>
> > --- On Tue, 29/7/08, Izzudin Hanafie <izzudin_aq@ yahoo. com> wrote:
>
> >
>
> >
>
> >
>
> > From: Izzudin Hanafie <izzudin_aq@ yahoo. com>
>
> >
>
> >
>
> >
>
> > Subject: Re: [indo-oracle] Kirim e-mail dengan UTL_MAIL
>
> >
>
> >
>
> >
>
> > To: indo-oracle@ yahoogroups. com
>
> >
>
> >
>
> >
>
> > Date: Tuesday, 29 July, 2008, 4:33 PM
>
> >
>
> >
>
> >
>
> > Mas Bayu, apakah masalah tersebut sudah solve...?. Bila memang
>
> sudah, mohon sharingnya.. :D. Saya juga mengalami masalah serupa
>
> ketika akan mengaktifkan package UTL_MAIL. Barangkali ada rekan's yang
>
> pernah mengalami hal tersebut..?.
>
> >
>
> >
>
> >
>
> > Mohon informasinya,
>
> >
>
> >
>
> >
>
> > Thanks
>
> >
>
> >
>
> >
>
> > Izzudin Hanafie
>
> >
>
> >
>
> >
>
> > --- On Thu, 7/24/08, Bayu Kurniawan R <[EMAIL PROTECTED] com> wrote:
>
> >
>
> >
>
> >
>
> > From: Bayu Kurniawan R <[EMAIL PROTECTED] com>
>
> >
>
> >
>
> >
>
> > Subject: [indo-oracle] Kirim e-mail dengan UTL_MAIL
>
> >
>
> >
>
> >
>
> > To: indo-oracle@ yahoogroups. com
>
> >
>
> >
>
> >
>
> > Date: Thursday, July 24, 2008, 7:48 AM
>
> >
>
> >
>
> >
>
> > Saya telah berhasil menginstall UTL_MAIL di Oracle 10XE pada Redhat
>
> >
>
> >
>
> >
>
> > EL5, dengan menggunakan perintah :
>
> >
>
> >
>
> >
>
> > SQL> connect sys/password as sysdba
>
> >
>
> >
>
> >
>
> > Connected.
>
> >
>
> >
>
> >
>
> > SQL> @$ORACLE_HOME/ rdbms/admin/ utlmail.sql
>
> >
>
> >
>
> >
>
> > Package created.
>
> >
>
> >
>
> >
>
> > Synonym created.
>
> >
>
> >
>
> >
>
> > SQL> @$ORACLE_HOME /rdbms/admin/ prvtmail. plb
>
> >
>
> >
>
> >
>
> > Package body created.
>
> >
>
> >
>
> >
>
> > No errors.
>
> >
>
> >
>
> >
>
> > SQL> alter system set smtp_out_server = '<ip-address: port'
scope=Both;
>
> >
>
> >
>
> >
>
> > Kemudian untuk mengetes e-mail dengan menggunakan perintah berikut :
>
> >
>
> >
>
> >
>
> > begin
>
> >
>
> >
>
> >
>
> > utl_mail.send(
>
> >
>
> >
>
> >
>
> > sender => 'gjwilliams01@ yahoo.com',
>
> >
>
> >
>
> >
>
> > recipients => ' gjwilliams01@ yahoo.com',
>
> >
>
> >
>
> >
>
> > subject => 'Testing utl_mail',
>
> >
>
> >
>
> >
>
> > message => 'The receipt of this email means'||
>
> >
>
> >
>
> >
>
> > ' that shutting down the database'||
>
> >
>
> >
>
> >
>
> > ' works for UTL_MAIL '
>
> >
>
> >
>
> >
>
> > );
>
> >
>
> >
>
> >
>
> > end;
>
> >
>
> >
>
> >
>
> > /
>
> >
>
> >
>
> >
>
> > Dan hasilnya :
>
> >
>
> >
>
> >
>
> > ERROR at line 1:
>
> >
>
> >
>
> >
>
> > ORA-29278: SMTP transient error: 421 Service not available
>
> >
>
> >
>
> >
>
> > ORA-06512: at "SYS.UTL_SMTP" , line 21
>
> >
>
> >
>
> >
>
> > ORA-06512: at "SYS.UTL_SMTP" , line 97
>
> >
>
> >
>
> >
>
> > ORA-06512: at "SYS.UTL_SMTP" , line 139
>
> >
>
> >
>
> >
>
> > ORA-06512: at "SYS.UTL_MAIL" , line 405
>
> >
>
> >
>
> >
>
> > ORA-06512: at "SYS.UTL_MAIL" , line 594
>
> >
>
> >
>
> >
>
> > ORA-06512: at line 2
>
> >
>
> >
>
> >
>
> > Please help
>
> >
>
> >
>
> >
>
> > [Non-text portions of this message have been removed]
>
> >
>
> >
>
> >
>
> > Get your new Email address!
>
> >
>
> >
>
> >
>
> > Grab the Email name you've always wanted before someone else does!
>
> >
>
> >
>
> >
>
> > http://mail. promotions. yahoo.com/ newdomains/ sg/
>
> >
>
> >
>
> >
>
> > [Non-text portions of this message have been removed]
>
> >
>
> >
>
> >
>
> > [Non-text portions of this message have been removed]
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> > Get your new Email address!
>
> >
>
> > Grab the Email name you've always wanted before someone else does!
>
> >
>
> > http://mail. promotions. yahoo.com/ newdomains/ sg/
>
> >
>
> >
>
> >
>
> > [Non-text portions of this message have been removed]
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> > [Non-text portions of this message have been removed]
>
> >
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
