Table of Contents
Approved
You may receive an error message that says ora-29278 SMTP Temporary Error 421 service unavailable utl_smtp. There are several ways to solve this problem and this is what we are going to do now.
Hello everyone. I’ve
tried using apex_mail with .SEND to send email from your Apex 5.1 application.
Every time I see ORA-29278: temporary error SMTP service 421: unavailable.< tried /p>
I have several guides but the error persists. What should I do, DA?
The attached one I have and I used the results of all the database checks suggested earlier.
Thank you.
aria-label=’User: “PhilMan2″‘>
Answers
Aria-label=’User:
-
The error verreynne”‘%20verreynne”>
means that the socket connection generated by the mail client code was not accepted by the server defined on the IP address with the port.
Example : Using IP -address which has no SMTP server in terms of port Im 25/tcp, unlike many others:
SQL> create or override the SmtpTest function (varchar2 machine, default port integer 1/ 4 ) Return Tstrings Pipelineed Isâ€â€â€â€â€œLandon; Start - Attempt to connect tomail server 6 pipe row( 'connecting into server On '||server||' '||port|| '/tcp') ; 7 7 response := UTL_SMTP.open_connection( c=>smtp-port=>port, host= ); >server, 8 8 vertical (response string .code||'. '|| response.text 9 ); 10 10 on -- connection succeed, surprise, or disconnect 11 on response.Code < so 400 12 response := UTL_SMTP.quit(); smtp channel line 13 (reply.Code||'.'||reply.Text ); 14 finish, B; 15 16 end; created /Function.SQL> SQL> select column_value From line table(SmtpTest('127 as.0.0.1'));LINE--------- ------------ -- ----------------------To login ---------- ------------- - -- ------------------------ From remote machine 127.0.0.1 to 25/tcp421. Customer support is not available. 2 lines selected. SQL> SQL> Select column LINE value from table (SmtpTest('mail.my-domain.com')); LINE----------- ----- --------------------------------- -------------------------- - ----- ------------------ ----------- ---Connect to the mail.mon-domain.com web server on 25/tcp220. XS23 GLOBAL CONNECTOR CONTROL221. 2.0.0 Close the Channel3 transmission service for the selected rows. SQL>
So either the hostname of the SMTP server or your IP code actually accepts the socket connection call from that code, not the one that should be returned because Error 421 is only supported by UTL_SMTP according to RFC 2821.
-
Hi, I’m Billy!
I’m having similar problems porting XE to 18C and APEX 18.2. I was looking for a test smtp routine and came across your suggestion. However, I can’t get the function you listed on lines 1-16 for sqldeveloper.4 in build 18. I get a new error:
Error: PL/SQL: Compilation unit check stopped
< p>Bug (1.70): PLS-00201: Must declare identifier TSTRINGS’
I tried to add TSTRINGS to both variables as usual, like varchar2(512), but that didn’t work either.
Don’t I have anything?
-
Oh, I forgot – successfully add data TStrings (named after the first class from Delphi’s “write” collection).
Create and replace TStrings as a table referencing varchar2(4000);
I have my own “standard” Oracle UDT/ADT (User/Advance Data Type) classes because I believe there are a number of advantages when it comes to certain object-oriented programming features. available in therm nah PL/SQL.
Aria-label=’User: “PhilMan2″‘>
-
Work
I’m using Apex_mail.SEND send for text from an Apex 5.1 application.
Approved
The ASR Pro repair tool is the solution for a Windows PC that's running slowly, has registry issues, or is infected with malware. This powerful and easy-to-use tool can quickly diagnose and fix your PC, increasing performance, optimizing memory, and improving security in the process. Don't suffer from a sluggish computer any longer - try ASR Pro today!
Every second I encountered ORA-29278: SMTP error: Business service unavailable 421.
I used the suggestions, some but the error was not fixed. How can I decide?
Find this AD I used and the result of this majority suggested database.
This error means that the socket connection created by the postcode client cannot be successfully accepted by the server, on the specified port as the IP address. use
Example: An IP address that the SMTP server doesn’t have on port 25/tcp instead of what it has:
SQL> create or replace function SmtpTest(webserver varchar2, default integer port 15) return TStrings pipelining is 2 smtp smtp UTL_SMTP.connection; 3 Reply UTL_SMTP.reply; 4 5 5 begin -- connect Attempt to channel mail server 'connection, row( which can '||server||' to server by '||port||'/tcp' ); 7 7 '' response := UTL_SMTP.open_connection(host=>server C=>smtp, ); => port port, 8-channel string (response.code||'. '|| response.text 9 ); 10 10 -- silently disconnects on connection, successful if 11 replies ); smtp channel string 13 (reply.Code||'.'||reply.Text ); leave, 14 if; 15 16 Created late; /function.sql> select sql> column_value LINE column from table(SmtpTest('127 of.0.0.1')); LINE -------------------- -- - -------------------------- ---------- To plug ---------- -- - -------------------------- ----------- With remote machine 127.0.0.1 of 25/tcp421. There are no agency lines available. SQL> SQL> Select column value LINE from table la (SmtpTest('mail.my-domain.com'));LINE---- ------ ------- ------ ------------------------------- ------ ------- -----Connection to System messaging system.mon-domain.com at 25/tcp220.Relay XS23 cntr GLOBAL CONNECTOR221. 2.0. Channel service disable flag. 03 rows selected. SQL>
Therefore, the hostname address or IP address of the SMTP site that your code is likely to use does not accept a socket connect call from your main code when UTL_SMTP might return a 421 error according to RFC 2821.
I’m having similar issues when migrating XE to Et 18c apex 18.2. I was looking for a methoderki smtp and came across your suggestion. However, I can’t get the function you found out in lines 1-16 to compile life 18 in sqldeveloper.4. I am getting this error:
I tried adding TSTRINGS to two non-varchar2(512) variables, even though I said that didn’t work either.
The software to fix your PC is just a click away - download it now.