Re[2]:RE: tnsnames.ora in clients

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Mon, 23 Jul 2001 10:29:19 -0700
Message-ID: <F001.003521F7.20010723102702@fatcity.com>

ahhh no, oracle has already claimed desupport for ONS, whereas they've not for pl/sql.

joe

>>> <dgoulet_at_vicr.com> 07/23/01 01:04PM >>>Yeah, at the same rate that SQLJ is replacing

PL/SQL!Dick Goulet____________________Reply 
Separator____________________Subject:    Re:RE: tnsnames.ora

in clientsAuthor: "JOE TESTA"
<JTESTA_at_longaberger.com>Date:

7/23/2001 1:00 PMexcept that ONS is going away in favor of ldap.joe>>> dgoulet_at_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"
<Bruce.Page_at_BellSouth.com>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 [<A
href="mailto:Surendra.Tirumala_at_am.sony.com]">mailto:Surendra.Tirumala_at_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: <A
href="http://www.orafaq.com">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: <A
href="http://www.orafaq.com">http://www.orafaq.com-- Author: Page, Bruce INET: Bruce.Page_at_BellSouth.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing

Lists--------------------------------------------------------------------To

Lists--------------------------------------------------------------------To

REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_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).<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN"><HTML><HEAD><META
http-equiv=Content-Type content="text/html; charset=iso-8859-1"><META content="MSHTML 5.50.4522.1800" name=GENERATOR></HEAD><BODY style="MARGIN-TOP: 2px; FONT: 6pt MS Sans Serif; MARGIN-LEFT: 2px"><DIV>except that ONS is going away in favor of ldap.</DIV><DIV> </DIV><DIV>joe</DIV><DIV> </DIV><DIV> >>> dgoulet_at_vicr.com 07/23/01 12:58PM >>> We switched to ONS 3 years ago & have never regretted it.  Getting rid of the tnsnames.ora file was the berries. Dick

Goulet<BR><BR>____________________Reply 
Separator____________________<BR>Author:"Page; Bruce"

<Bruce.Page_at_BellSouth.com> Date:       7/23/2001 7:52 AM One method I have seen used a lot is to set the TNS_ADMIN variable to point to the centralized file. Another is to have the LAN guys add a check to their login script to check to see if the TNSNAMES.ORA has been updated and if it has, have it pushed down when the user logs into the LAN. > -----Original
Message----- > From: Tirumala, Surendra [<A href="<A href="mailto:Surendra.Tirumala_at_am.sony.com]" ?>mailto:Surendra.Tirumala_at_am.sony.com]"><A href="mailto:Surendra.Tirumala_at_am.sony.co">mailto:Surendra.Tirumala_at_am.sony.com]</A> > 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 orelse > advanced features > like ONS. > > Your suggestions are highly appreciated. > > Thanks, >
 > Suren > Consultant DBA >
Sony > -- > Please see the official ORACLE-L FAQ: <A href="<A href="http://www.orafaq.com" ?>http://www.orafaq.com"><A
href="http://www.orafaq.comhttp://www.orafaq.com</A> > -- > 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 >

--------------------------------------------------------------------<BR>&gt;

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). >
 -- Pleasesee the official ORACLE-L FAQ: <A

href="http://www.orafaq.com"><A 
href="http://www.orafaq.comhttp://www.orafaq.com</A><BR>--

 Author: Page, Bruce   INET:
Bruce.Page_at_BellSouth.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego,
California        -- Public Internet access / Mailing

Lists<BR>--------------------------------------------------------------------<BR>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-LFAQ:
<A href="http://www.orafaq.com"><A

href="http://www.orafaq.comhttp://www.orafaq.com</A> --
 Author:   INET:

dgoulet_at_vicr.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego,
California        -- Public Internet access / Mailing

Lists<BR>--------------------------------------------------------------------<BR>To