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]
