RE: SHARED SQLNET.ora? RE: tnsnames.ora in clients

Kirti is right. We had the same issues. We used to have our TNSNAMES out on a lan space on my old job but, when we got Oracle Names up and running, we found out just what kind of lag time we had. It really was noticable at the connect time.

-----Original Message-----
Sent: Tuesday, July 24, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L

Hi Ed,
 We use ONAMES. We had tried putting SQLNET.ora on the shared drive. It was working. However, they later found out that accessing it at all times from various locations was not always the fastest, easiest and acceptable way. We have a number of portable clients. And all shared drives are not always mapped as it depends on how they chose to connect/dial-in. So, lately we just keep a master copy of SQLNET.ora on a shared drive. We seldom change it (we use aliases for the Servers running the Names). As new clients (laptops) are deployed, the PC support team just copies it to the PCs from the shared (master) location. And this process has been working great for a few years now.

If you need any specific information, please let me know.

Thanks.

Regards,

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Haskins, Ed [SMTP:Ed.Haskins_at_VerizonWireless.com]
> Sent: Tuesday, July 24, 2001 12:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: SHARED SQLNET.ora? RE: tnsnames.ora in clients
>
> Has anyone been successful with putting the SQLNET.ora file in the same
> shared location as the TNSNAMES.ora file? I know it's supposed to be used
> solely on the user workstation in /network/admin (Net80/admin), but some
> people are trying to place it on the shared drive as well.
>
> We're actually implementing ONAMES, so we're replacing the SQLNET.ora file
> to specify ONAMES, and some Regions are thinking they only need to place
> this on the shared drive where TNS_ADMIN points to. I don't think this is
> supported or works in all situations. Any experiences or comments??
>
> Ed
>
> -----Original Message-----
> Sent: Tuesday, July 24, 2001 1:02 PM
> To: Multiple recipients of list ORACLE-L
>
>
> We use a shared tnsnames.ora from a NT server.
>
> > -----Original Message-----
> > From: Ron Rogers [mailto:RROGERS_at_galottery.org]
> > Sent: Monday, July 23, 2001 2:33 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: tnsnames.ora in clients
> >
> >
> > Does this method of "sharing" the tnsnames work for you? What
> > operating system are you using? I use Novell and when I tried
> > this method of sharing the tnsnames it wouls not work. We had
> > to resolve to downloading the latest copy to the users when
> > they logged in.
> > ROR mª¿ªm
> >
> > >>> rji_at_exenet.com 07/23/01 11:41AM >>>
> > You can write a script and each time when a user logs into a domain
> > it will check and copy the latest tnsnames.ora file. Or you can just
> > place the tnsnames.ora file on the network drive and point everyone
> > to it.
> >
> > >>> Surendra.Tirumala_at_am.sony.com 07/23/01 10:55AM >>>
> > Hello All,
> >
> > Good morning!
> > I would like to know how the 'tnsnames.ora' file on all
> > client(windows)
> > machines can be updated automatically whenever something changed on
> > central 'tnsnames.ora' file.
> > Is this the process still being used extensively or else
> > advanced features
> > like ONS.
> >
> > Your suggestions are highly appreciated.
> >
> > Thanks,
> >
> > Suren
> > Consultant DBA
> > Sony
> > --
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
  INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).