ORA-29278: SMTP transient error: 421 Service not available
create or replace procedure souchang_Send_Email(p_txt varchar2,
p_sub Varchar2,
p_SendorAddress Varchar2,
p_ReceiverAddress varchar2,
p_EmailServer varchar2,
p_Port Number Default 25,
p_need_smtp Int Default 0,
p_user Varchar2 Default Null,
p_pass Varchar2 Default Null) IS
l_addr Varchar2(200) := '';
l_len Int;
l_ReceiverAddress Varchar2(4000);
procedure p_Email(p_txt varchar2,
p_sub Varchar2,
p_SendorAddress Varchar2,
p_ReceiverAddress varchar2,
p_EmailServer varchar2,
p_Port Number,
p_user Varchar2,
p_pass Varchar2) Is
l_conn UTL_SMTP.CONNECTION;
l_crlf VARCHAR2(2) := CHR(13) || CHR(10);
l_mesg VARCHAR2(4000);
Begin
l_conn := utl_smtp.open_connection(p_EmailServer, p_Port);
utl_smtp.helo(l_conn, p_EmailServer);
If p_need_smtp = 1 Then
utl_smtp.command(l_conn, 'AUTH LOGIN', '');
utl_smtp.command(l_conn,
utl_encode.base64_encode(utl_raw.cast_to_raw(p_user)),
'');
utl_smtp.command(l_conn,
utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_to_raw(p_pass))),
'');
End If;
utl_smtp.mail(l_conn, p_SendorAddress);
utl_smtp.rcpt(l_conn, p_ReceiverAddress);
l_mesg := 'Content-Type: text/plain; Charset=GB2312' || l_crlf ||
'Date:' || TO_CHAR(SYSDATE, 'yyyy-mm-dd hh24:mi:ss') ||
l_crlf || 'From:' || p_SendorAddress || l_crlf || 'Subject: ' ||
p_sub || l_crlf || 'To: ' || p_ReceiverAddress || l_crlf ||
'Content-Type: text/plain; Charset=GB2312' || l_crlf || '' ||
l_crlf || p_txt || l_crlf;
utl_smtp.data(l_conn, l_mesg);
utl_smtp.quit(l_conn);
Exception
When Others Then
dbms_output.put_line(Sqlcode || ':' || Sqlerrm);
End;
Begin
l_ReceiverAddress := trim(rtrim(replace(Replace(p_ReceiverAddress,
';',
','),
' ',
''),
','));
l_len := length(l_ReceiverAddress);
For i In 1 .. l_len Loop
If substr(l_ReceiverAddress, i, 1) <> ',' Then
l_addr := l_addr || substr(l_ReceiverAddress, i, 1);
Else
dbms_output.put_line();
p_Email(p_txt,
p_sub,
p_SendorAddress,
l_addr,
p_EmailServer,
p_Port,
p_user,
p_pass);
l_addr := '';
End If;
If i = l_len Then
dbms_output.put_line('*');
p_Email(p_txt,
p_sub,
p_SendorAddress,
l_addr,
p_EmailServer,
p_Port,
p_user,
p_pass);
End If;
End Loop;
END;
I can't find the solution to this error,but same export reply :
Go to Control Panel->Add or Remove Programs->Click on
Add/Remove Wndows Components
Check IIS check box.
Select Internet Information Service (IIS) option and click on Details button
Check whether SMTP Service is checked or not.
If not selected then select SMTP check box.
This process should be done on server.
It will help out from ORA-29278: SMTP transient error: 421 Service not available problem.
my cumputer does not install the iss services and smtp services
have any other solution to it
any others:
whe .com can be opend but can't ping the ip opend
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9879835/viewspace-996818/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- linux CentOS出現Error: xz compression not availableLinuxCentOSErrorAI
- Git bash Error: Could not fork child process: There are no available terminals (-1)GitErrorAI
- 【ERROR】su user報'This account is currently not available'錯誤 for linuxErrorAILinux
- 使用@Service註解出現No bean named 'xxxx' available]錯誤BeanAI
- Error:Unknow host 'service.gradle.org'ErrorGradle
- k8s kubectl top pod報錯error Metrics API not availableK8SErrorAPIAI
- ORA-29702: error occurred in Cluster Group Service operationError
- zookeeper報錯 service not available now, maybe disk full, CL: 0.95 CQ: 0.95 INDEX: 0.95, maybeAIIndex
- FIN421 Econometrics for FinanceNaN
- @Transient關鍵字
- Job for docker.service failed because the control process exited with error codeDockerAIError
- 20241027LeetCode421周賽LeetCode
- transient和synchronized的使用synchronized
- [java]transient關鍵字Java
- Job for mysqld.service failed because the control process exited with error code...MySqlAIError
- 啟動dubbo消費端過程提示No provider available for the service的問題定位與解決IDEAI
- No instances available for XXXAI
- 421-Maximum XOR of Two Numbers in an Array
- ORA-29702:error occurred in Cluster Group Service operation錯誤解決Error
- 瞬態關鍵字transient
- 在 Java 中如何使用 transientJava
- transient關鍵詞的概述
- google smtp 郵箱配置Go
- WPForms和 WP Mail SMTP – 最好的WordPress SMTP郵件傳送外掛ORMAI
- No bean named ''XXX“ availableBeanAI
- No bean named BookServiceImpl availableBeanAI
- transient的作用及序列化
- python SMTP郵件服務Python
- Python SMTP傳送郵件Python
- SMTP操作使用詳解並透過python進行smtp郵件傳送示例Python
- SMTP協議解讀以及如何使用SMTP協議傳送電子郵件協議
- Job for mysqld.service failed because the control process exited with error code錯誤解決MySqlAIError
- JEP 421: Java將要終結finalize()了!Java
- No Task Available解決方法AI
- Java中transient關鍵字的作用Java
- Java transient 的作用及使用方法Java
- Python_smtp 郵件互動Python
- Jmeter——SMTP Sampler傳送郵件JMeter
- 安裝MySQL出現Job for mysqld.service failed because the control process exited with error codeMySqlAIError