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

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Tue, 10 Jun 2003 14:29:53 GMT
Message-ID: <3ee5e9e0.431026493@nyc.news.speakeasy.net>

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 Received on Tue Jun 10 2003 - 09:29:53 CDT