Re: SQLNet: are TNSNAMES.ORA and HOSTS.TXT really necessary??
From: Lee E Parsons <lparsons_at_world.std.com>
Date: Tue, 27 Dec 1994 03:23:17 GMT
Message-ID: <D1G9Et.H4q_at_world.std.com>
>
> The instructions for installing SQLNet V1 on MS Windows list various files
> that must exist with certain contents, [...]
>
> After some testing I've deduced that tnsnames.ora and hosts.txt are not even
> used by SQLNet V1. I temporarily deleted them and SQLPlus ran fine without
> them. It seems the line beginning "SQLNET DBNAME xxx = t:<host>:<sid>" in the
> ORACLE.INI file is what really matters.
>
> Does anybody know where tnsnames.ora and hosts.txt are necessary?
Date: Tue, 27 Dec 1994 03:23:17 GMT
Message-ID: <D1G9Et.H4q_at_world.std.com>
little_c_at_cho006.cho.ge.com (Chris Little) wrote:
>
>
> The instructions for installing SQLNet V1 on MS Windows list various files
> that must exist with certain contents, [...]
>
> After some testing I've deduced that tnsnames.ora and hosts.txt are not even
> used by SQLNet V1. I temporarily deleted them and SQLPlus ran fine without
> them. It seems the line beginning "SQLNET DBNAME xxx = t:<host>:<sid>" in the
> ORACLE.INI file is what really matters.
>
> Does anybody know where tnsnames.ora and hosts.txt are necessary?
Isn't hosts.txt (actually I thought it was just hosts, but I cant check now) the file that maps ip addresses to hostnames?
If so then you must have some version of hosts.txt unless your running something like DNS. If your not using DNS look for another version of hosts. The one you deleted may not have been the one that your version of TCP/IP was actually using.
Bottom line is that your PC must have someway of turning the "host" in t:<host>:<sid> into a IP address. hosts.txt is where he normally looks for that address.
-- Regards, Lee E. Parsons Systems Oracle DBA lparsons_at_world.std.comReceived on Tue Dec 27 1994 - 04:23:17 CET