This content has been marked as final. Show 6 replies
Please share the oracle version
I got the smtp error. what can i do and how can i configure smtp in my system.
please past the error messages
2 vSender VARCHAR2(30) := 'email@example.com';
3 vRecip VARCHAR2(30) := 'firstname.lastname@example.org';
4 vSubj VARCHAR2(50) := 'Enter the subject here';
5 vMesg VARCHAR2(4000) := 'Enter the body';
6 vMType VARCHAR2(30) := 'text/plain; charset=us-ascii';
9 (vSender, vRecip, NULL, NULL, vSubj, vMesg, vMType,NULL);
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 8
This doesn't appear to be a security question.
The problem appears to be that you've configured a SMTP_OUT_SERVER that either does not exist, that is temporarily down, or that is listening on a different port than the one you specified. This is not an Oracle error. It's an error message coming from whatever SMTP server you're trying to use.
you can setup the smtp by following the steps here.