Re: Listener - name vs IP address question

Hi David,

AFAIK this is standard tcp/ip behavior. As soon as the address is being translated to an ip address by DNS, this is being used in all communications. This sounds OK to me, as otherwise the symbolic address needs to be translated every time. I have executed similar tests on AIX (RS6000) and got similar results.

Regards,

Sybrand Bakker, Oracle DBA

David Breese wrote:

> I am attempting to help our Oracle folks resolve a problem and
> I have a question about how the listener works. We are running
> Oracle 7 on an NT server.
>
> I have taken a data sniffer trace of the conversation between
> the client and the server. When the connection starts, the client
> station connects to the server on port 1526 and sends a packet to
> the server that contains the following info:
>
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world)
> (PROTOCOL=TCP)(HOST=mydbserver)(Port=1526)))
> (CONNECT_DATA=(SID=MDS)(CID=(PROGRAM=PLUS33W.EXE)(HOST=123456)
> (USER=myuserid))))
>
> The server then responds with a packet that contains:
>
> (ADDRESS=(PROTOCOL=tcp)(DEV=1828)(HOST=198.80.123.31)(PORT=4484))
>
> The client then terminates its connection to port 1526 and then
> reconnects on port 4484.
>
> My question is this: is there any way to make the listener
> response have "HOST=mydnserver" instead of "HOST=198.80.123.31"?
> Our Oracle folks have changed the tnsnames.ora file and the
> listener.ora file to have the name instead of the IP address,
> but the response still contains the IP address instead of the
> name. Is there any way to make the listener use the hostname in
> the reply (so the client can resolve it) instead of resolving it
> first and then putting the IP address in the reply?
>
> Any help would be appreciated.
> Thanks.
>
> David
>
> David Breese
> dbreese1_at_no_spam.tx.net (remove no_spam. to reply)

Received on Wed Jan 13 1999 - 16:21:00 CST