This error message tells that localhost, the same server where you have your Oracle database running, does not have an SMTP server up and running.
Means this error occur when SMTP SERVER IS NOT REACHABLE so it is not oracle error.
when UTL_SMTP package not able to connect SMTP server then above error will occur.
So first need to check without involving oracle we are able to connect smtp server through TELNET command
for eg:
C:\>telnet SMTP_SERVERNAME port (default port 25)
A Qestion:- do we need smtp and oracle on the same server ?
===========================================================
Answer:-
===============
No, its no need to, smtp and oracle on the same server.
You first have to check whether you are able to contact the email server without involving ORACLE.
you need just connection with SMTP server
C:\>telnet SMTP_server port
Connecting To SMTP_server Could not open connection to the host, on port 23: Connect failed
You will see the above error it means system is not able to connect smtp server that is why the above error occur.
after successfully connect to SMTP server , then try via oracle database.
Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
Index Usage – 21 week ago
-
-
-
-
-
-
-
-
Oracle Cloud & Third party tools3 years ago
-
-
-
Moving Sideways7 years ago
-
Upcoming Events...10 years ago
-
1 comment:
I was able to connect to smtp server (smtp.gmail.com). But what should be done in the database to successfully send email?
Post a Comment