Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQLNET 32 and 16 bit config files on Lan ??

Re: SQLNET 32 and 16 bit config files on Lan ??

From: Doug Smith <dsmith_at_gulfaero.com>
Date: 1997/09/12
Message-ID: <01bcbfaf$2dbc04d0$81a0d886@dsmith>#1/1

I figured it out myself.

For 16 bit sqlnet: add a line to \orawin\oracle.ini "TNS_ADMIN={x:\network\admin}
  where x is the mapped lan drive and the directory where sqlnet.ora and tnsnames.ora are stored.

For 32 bit sqlnet: add a variable to the SYSTEM settings under Control Panel in Windows NT 4.0. with "TNS_ADMIN={x:\network\admin}" where x is the mapped lan drive and the directory where sqlnet.ora and tnsnames.ora are stored.

You can use one copy of sqlnet.ora and tnsnames.ora by pointing them both to the same drive/directory on the LAN.

If anybody has a better way, please let me know.

Doug Smith <dsmith_at_gulfaero.com> wrote in article <01bcbeca$5e97a900$81a0d886_at_dsmith>...
> My client PC's use Windows NT 4.0.
>
> They run both 32 and 16 bit SQLNET and cooresponding ODBC drivers.
>
> I am installing SQLNET on each PC using distribution software but I would
> like to point
> to a Lan Server Drive for the SQLNET config files, TNSNAMES.ORA and
> SQLNET.ORA
>
> How do I point to locations other than \ORANT\network\admin for 32 bit
 and
> \ORAWIN\network\admin for 16 bit SQLNET config files ?????
>
> TNS_ADMIN ???
> ORACLE.INI ???
>
> THANKS !!!!!!!
>
  Received on Fri Sep 12 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US