This content has been marked as final. Show 8 replies
I doubt you can use Gmail server as a smtp server. you should have your own SMTP server to trigger a mail.
And, Follow the below links for further details
Who is your internet provider? You can try the name of the smtp server of your provider.
Besides gmail/yahoo/hotmail etc., if you also have a working Outlook (Express) account from your own provider, check your account properties and use that smtp server.
SQL> ALTER SYSTEM SET SMTP_OUT_SERVER='your_provider's_smtp_server' SCOPE=SPFILE;
(At least: that approach worked fine for me...)
GMAIL uses encrypted authentication, I would use SMTP relay (there are tons of free relays out there), here are few samples how to set it up with gmail (what OS you plan to run it on?)
http://emailrelay.sourceforge.net - I was using this with gmail, it works great
here is how to use it with gmail http://emailrelay.sourceforge.net./userguide.html#SH_1_5
after you install it, point your Oracle to your internal SMTP relay server IP address, relay is super tiny app and really won't each much resources
But, you apparently do have an internet account (usually nowadays internet and email etc. is 'all included'), else you wouldn't be posting here. So, let's assume your provider is ACME and you live in Holland (= .nl), then you could try:
ALTER SYSTEM SET smtp_out_server='smtp.acme.nl' SCOPE=SPFILE;
You need to figure that out yourself, since we don't know who provides you internet access (nor whether it would work).
That would be the simplest way.
Not sure whether you can get gmail etc. to 'work with you': Re: utl.mail - smtp_out_server parameter