smtp server

Is there any way to find out the smtp server in a system where I have internet.
nobleitAsked:
Who is Participating?
 
sdstuberCommented:
select value from v$parameter where name = 'smtp_out_server';

0
 
slightwv (䄆 Netminder) Commented:
No.

You need to ask your system admin staf or network staff for an email server or mail relay.
0
 
nobleitAuthor Commented:
This is in a pc.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
slightwv (䄆 Netminder) Commented:
So?

Smtp email relays eventually need an email server.

If you don't know what it is, you need to ask.

With your other questions can I assume you are thinking about emailing from an Oracle database server?

You need to know the email server you have access to.
0
 
sdstuberCommented:
if your database has been configured for utl_mail, you can try looking in v$parameter for the  "smtp_out_server"  value

no guarantee it will be populated though, but if it is,  it "should" be a valid server
0
 
MicMaticCommented:
You can get the server from a command prompt:

1. type nslookup [enter]
2. type your domain e.g. google.com [enter]
3. type set query=mx [enter]
4. type nslookup [enter]

you'll see your smtp-server :-)
0
 
nobleitAuthor Commented:
Here is the output.
Can you help what is the smtp server...
C:\Documents and Settings\Mathew>nslookup
Default Server:  xxx.xxx.xxx.xxx.net
Address:  xxx.xxx.xxx.xxx

> mx
Server:   xxx.xxx.xxx.xxx.net
Address:   xxx.xxx.xxx.xxx

***  xxx.xxx.xxx.xxx.net can't find mx: Non-existent domain
> nslookup
Server:   xxx.xxx.xxx.xxx.net
Address:   xxx.xxx.xxx.xxx

*** xxx.xxx.xxx.xxx.net can't find nslookup: Non-existent domain
>





0
 
nobleitAuthor Commented:
how can we find out the value for smtp_out_server
from the following?
SQL> desc v$parameter;
 Name                                      Null?    Type
 ----------------------------------------- -------- ---------------

 NUM                                                NUMBER
 NAME                                               VARCHAR2(80)
 TYPE                                               NUMBER
 VALUE                                              VARCHAR2(4000)
 DISPLAY_VALUE                                      VARCHAR2(4000)
 ISDEFAULT                                          VARCHAR2(9)
 ISSES_MODIFIABLE                                   VARCHAR2(5)
 ISSYS_MODIFIABLE                                   VARCHAR2(9)
 ISINSTANCE_MODIFIABLE                              VARCHAR2(5)
 ISMODIFIED                                         VARCHAR2(10)
 ISADJUSTED                                         VARCHAR2(5)
 ISDEPRECATED                                       VARCHAR2(5)
 ISBASIC                                            VARCHAR2(5)
 DESCRIPTION                                        VARCHAR2(255)
 UPDATE_COMMENT                                     VARCHAR2(255)
 HASH                                               NUMBER

SQL>
0
 
MicMaticCommented:
you should have something like this:

C:\Documents and Settings\Mathew>nslookup
Default Server:   xxx.xxx.xxx.xxx.net
Address:  xxx.xxx.xxx.xxx
> your mailserver (e.g. if you use xxx@gmail.com the server is "gmail.com")
>set query=mx
>nslookup

the third line after that should be your smtp

0
 
slightwv (䄆 Netminder) Commented:
>>>set query=mx
>>>nslookup

Don't you mean (using your domain of gmail.com):
set query=mx
gmail.com
0
 
MicMaticCommented:
@slightwv: that's a faster way to do it :-)
but if you like to type, my way works too ;-)
0
 
slightwv (䄆 Netminder) Commented:
>>but if you like to type, my way works too ;-)

The only reason I posted is, it didn't when I tried it on our system.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.