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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 登入ftp伺服器的時候顯示421 Service not availableFTP伺服器AI
- rhel5上配置vsftpd_421 Service not available, remote server has closed connectionFTPAIREMServer
- ERROR: UTL_SMTP.OPEN_CONNECTIONError
- [ASP.NET State service] errorASP.NETError
- linux CentOS出現Error: xz compression not availableLinuxCentOSErrorAI
- 【ERROR】su user報'This account is currently not available'錯誤 for linuxErrorAILinux
- Git bash Error: Could not fork child process: There are no available terminals (-1)GitErrorAI
- YaST2 error: (gnomesu): CRITICAL **: There are no services for 'libgnomesu' available.ASTErrorAI
- R12 help--diagnostics--examine gives function not available errorFunctionAIError
- Error: 17803, Severity: 20, State: 7 Insufficient memory availableErrorAI
- ORA-32700: error occurred in DIAG Group ServiceError
- java transient簡介Java
- Error:Unknow host 'service.gradle.org'ErrorGradle
- Service.cpp:10:28: error: within this contextErrorContext
- k8s kubectl top pod報錯error Metrics API not availableK8SErrorAPIAI
- [java]transient關鍵字Java
- transient和synchronized的使用synchronized
- Java——transient and 序列化Java
- java transient關鍵字Java
- ORA-29702: error occurred in Cluster Group Service operationError
- 使用@Service註解出現No bean named 'xxxx' available]錯誤BeanAI
- zookeeper報錯 service not available now, maybe disk full, CL: 0.95 CQ: 0.95 INDEX: 0.95, maybeAIIndex
- Not-null property references a transient value - transient instance must be saved before current opeNull
- RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not availableErrorUXDatabaseOracleAI
- 在 Java 中如何使用 transientJava
- The SQL Server (MSSQLSERVER) service terminated with service-specific error 1814 (0x716).SQLServerError
- ProxSMTP: An SMTP FilterFilter
- Fatal Error: TXK Install Service,Cannot install Oracle Database HomeErrorOracleDatabase
- ORA-19511: Error received from media manager layer, error text: ANS0322E (RC-72) no text available fErrorAI
- malformed database schema (is_transient) - near "where"ORMDatabase
- google smtp 郵箱配置Go
- oracle mail utl_smtpOracleAI
- Ubuntu smtp驗證配置Ubuntu
- WPForms和 WP Mail SMTP – 最好的WordPress SMTP郵件傳送外掛ORMAI
- Leetcode[421] Maximum XOR of Two Numbers in an ArrayLeetCode
- 啟動dubbo消費端過程提示No provider available for the service的問題定位與解決IDEAI
- Java transient 的作用及使用方法Java
- Java中transient關鍵字的作用Java