Re: Where does sql*net get hostname in nttbnd2addr (MTS)

We are not using NAT, there is a VPN between the client and the server, the server does have several network cards and IPs (some virtual).

On Tue, 10 Jun 2003 18:12:23 +0200, Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote:

>On Tue, 10 Jun 2003 14:29:53 GMT, andreyNSPAM_at_bookexchange.net
>(NetComrade) wrote:
>
>>On Mon, 9 Jun 2003 22:20:12 +0200, "Sybrand Bakker"
>><postbus_at_sybrandb.demon.nl> wrote:
>>>
>>>
>>>The nodename in connect_data of tnsnames.ora and the hostname in
>>>listener.ora *must* match, otherwise you'll get 12545.
>>>So: if your host isn't qualified on the client, you don't want to get a
>>>qualified name back: it is not going to work.
>>>If you are using qualified names on the server, you *must* use (which you
>>>can set up in /etc/hosts) a qualified name also.
>>
>>Correct, first the client looks at tnsnames.ora and gets a qualified
>>name from there and tried to connect to it. After which, the server
>>(running in MTS) tells the client to connect to a different network
>>card (I guess it's a default card) and passes back a different host
>>back to the client, at which step the client tries to connect to the
>>new host, except the host has been passed back w/o the domain. So in
>>each trace file i have two host lookups
>>cli_2568.trc:[09-JUN-2003 12:06:46:557] nttbnd2addr: entry
>>cli_2568.trc:[09-JUN-2003 12:06:46:557] nttbnd2addr: looking up IP
>>addr for host: virtual_db_ip.mydomain.com
>>cli_2568.trc:[09-JUN-2003 12:06:46:559] nttbnd2addr: exit
>>cli_2568.trc:[09-JUN-2003 12:06:46:689] nttbnd2addr: entry
>>cli_2568.trc:[09-JUN-2003 12:06:46:690] nttbnd2addr: looking up IP
>>addr for host: server_where_db_is_running
>>cli_2568.trc:[09-JUN-2003 12:06:46:702] nttbnd2addr: exit
>>
>>I am trying to figure out how to make the server pass the entire
>>domain, w/o having to add the server to the client (which runs under a
>>different domain).
>>Another way, would be to make the server pass back the virtual ip the
>>client connected to in the first place.
>>.......
>>We use Oracle 8.1.7.4 on Solaris 2.7 boxes
>>remove NSPAM to email
>
>
>Why don't you use connection manager? This allows for NAT.
>
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Tue Jun 10 2003 - 15:25:17 CDT