Re: SQLNet: are TNSNAMES.ORA and HOSTS.TXT really necessary??
Date: 24 Dec 1994 02:12:11 GMT
Message-ID: <3dg01r$pt5_at_ra.nrl.navy.mil>
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, namely:
>
> tnsnames.ora in ORAWIN directory
> hosts.txt in <IP stack> directory, e.g. PATHWAY, WRQNET, NETMANAG
> services in <IP stack> directory
> oracle.ini in WINDOWS directory
>
> 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?
> ________________________________________________________________________________
I believe that "tnsnames.ora" is only needed with SQLNET V2. Not sure about "hosts.txt" Received on Sat Dec 24 1994 - 03:12:11 CET