Dear Agus, rubah parameter smtp_out_server Anda ke IP Address mail servernya ALTER SYSTEM SET smtp_out_server='IP Address' SCOPE=SPFILE;
Regards, Defry ________________________________ From: agus sulaiman <[email protected]> To: indo-oracle <[email protected]> Sent: Mon, June 28, 2010 1:07:52 PM Subject: [indo-oracle] Error execute UTL_MAIL.send Kepada temen-temen semuanya, Saya mencoba menggunakan UTL_MAIL pada database oracle 11g tetapi pada saat saya eksekusi terjadi error. Koneksi menggunakan speedy. Berikut langkah-langkah yang saya lakukan: CONN sys/password AS SYSDBA @$ORACLE_HOME/rdbms/admin/utlmail.sql @$ORACLE_HOME/rdbms/admin/prvtmail.plb CONN sys/password AS SYSDBA ALTER SYSTEM SET smtp_out_server='smtp.domain.com' SCOPE=SPFILE; SHUTDOWN IMMEDIATE STARTUPBEGIN UTL_MAIL.send(sender => '[email protected]', recipients => '[email protected]', subject => 'UTL_MAIL Test', message => 'If you get this message it worked!'); END; / Error starting at line 1 in command: BEGIN UTL_MAIL.send(sender => '[email protected]', recipients => '[email protected]', subject => 'UTL_MAIL Test', message => 'If you get this message it worked!'); END; Hasilnya Sebagai berikut: Error report: ORA-29279: SMTP permanent error: 554 Your access to this mail system has been rejected due to the sending MTA's poor reputation. If you believe that this failure is in error, please contact the intended recipient via alternate means. ORA-06512: at "SYS.UTL_SMTP", line 20 ORA-06512: at "SYS.UTL_SMTP", line 98 ORA-06512: at "SYS.UTL_SMTP", line 138 ORA-06512: at "SYS.UTL_MAIL", line 386 ORA-06512: at "SYS.UTL_MAIL", line 599 ORA-06512: at line 2 29279. 00000 - "SMTP permanent error: %s" *Cause: A SMTP permanent error occurred. *Action: Correct the error and retry the SMTP operation. Mungkin teman-teman ada yang sudah pernah mengalaminya dari error tersebut. yang menjadi pertanyaan saya adalah: 1. Apakah ada settingan khusus di windows untuk smtp nya atau settingan database oraclenya masih salah, notes koneksi gunakan speedy? 2. Solusi dari masalah seperti ini seperti apa? Mungkin teman-teman bisa sharing mengenai hal ini. Terima kasih. Salam, Agus Sulaiman. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
