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

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 Received on Tue Jun 10 2003 - 11:12:23 CDT