Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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: Tirumala, Surendra
> INET: Surendra.Tirumala_at_am.sony.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: Richard Ji
> INET: rji_at_exenet.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: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> 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: Anderson, Brian INET: andersob_at_mail.dartnet.peachnet.edu 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: Haskins, Ed INET: Ed.Haskins_at_VerizonWireless.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).Received on Tue Jul 24 2001 - 11:12:53 CDT
![]() |
![]() |