From JTESTA@longaberger.com Mon, 23 Jul 2001 10:04:10 -0700 From: "JOE TESTA" Date: Mon, 23 Jul 2001 10:04:10 -0700 Subject: Re:RE: tnsnames.ora in clients Message-ID: MIME-Version: 1.0 Content-Type: text/plain except that ONS is going away in favor of ldap.   joe   >>> dgoulet@vicr.com 07/23/01 12:58PM >>>We switched to ONS 3 years ago & have never regretted it.  Getting rid of thetnsnames.ora file was the berries.Dick Goulet____________________Reply Separator____________________Author: "Page; Bruce" Date:       7/23/2001 7:52 AMOne method I have seen used a lot is to set the TNS_ADMIN variable to point tothe centralized file.Another is to have the LAN guys add a check to their login script to check tosee if the TNSNAMES.ORA has been updated and if it has, have it pushed down whenthe user logs into the LAN.> -----Original Message-----> From: Tirumala, Surendra [mailto:Surendra.Tirumala@am.sony.com]> Sent: Monday, July 23, 2001 10:56 AM> To: Multiple recipients of list ORACLE-L> Subject: tnsnames.ora in clients> > > 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@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@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: Page, Bruce  INET: Bruce.Page@BellSouth.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author:   INET: dgoulet@vicr.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).