Listener - name vs IP address question

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 - 15:48:14 CST