Cara untuk menghidupkan service SMTP di databse Oracle XE bagaimana ya...
--- In [email protected], Izzudin Hanafie <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]> wrote:
> From: hendra chen <[EMAIL PROTECTED]>
> Subject: Re: [indo-oracle] Kirim e-mail dengan UTL_MAIL
> To: [email protected]
> 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]
>
