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

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]:RE: tnsnames.ora in clients

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

From: <dgoulet_at_vicr.com>
Date: Mon, 23 Jul 2001 10:31:58 -0700
Message-ID: <F001.0035212E.20010723101255@fatcity.com>

Yeah, at the same rate that SQLJ is replacing PL/SQL!

Dick Goulet

____________________Reply Separator____________________
Author: "JOE TESTA" <JTESTA_at_longaberger.com>
Date:       7/23/2001 1:00 PM

except 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 the tnsnames.ora file was the berries.

Dick Goulet

____________________Reply Separator____________________
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 [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: 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: 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
--------------------------------------------------------------------
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: 
  INET: dgoulet_at_vicr.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).

<!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><FONT size=1>except that ONS is going away in favor of ldap.</FONT></DIV>
<DIV><FONT size=1></FONT>&nbsp;</DIV>
<DIV><FONT size=1>joe</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><BR><BR>&gt;&gt;&gt; dgoulet_at_vicr.com 07/23/01 12:58PM &gt;&gt;&gt;<BR>We 
switched to ONS 3 years ago &amp; have never regretted it.&nbsp; Getting rid of 
the<BR>tnsnames.ora file was the berries.<BR><BR>Dick 
Goulet<BR><BR>____________________Reply Separator____________________<BR>Author:

"Page; Bruce" 
&lt;Bruce.Page_at_BellSouth.com&gt;<BR>Date:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
7/23/2001 7:52 AM<BR><BR>One method I have seen used a lot is to set the 
TNS_ADMIN variable to point to<BR>the centralized file.<BR><BR>Another is to 
have the LAN guys add a check to their login script to check to<BR>see if the 
TNSNAMES.ORA has been updated and if it has, have it pushed down when<BR>the 
user logs into the LAN.<BR><BR>&gt; -----Original Message-----<BR>&gt; From: 
Tirumala, Surendra [<A 
href="mailto:Surendra.Tirumala_at_am.sony.com]">mailto:Surendra.Tirumala_at_am.sony.co
m]</A><BR>&gt; 
Sent: Monday, July 23, 2001 10:56 AM<BR>&gt; To: Multiple recipients of list 
ORACLE-L<BR>&gt; Subject: tnsnames.ora in clients<BR>&gt; <BR>&gt; <BR>&gt; 
Hello All,<BR>&gt; <BR>&gt; Good morning!<BR>&gt; I would like to know how the 
'tnsnames.ora' file on all <BR>&gt; client(windows)<BR>&gt; machines can be 
updated automatically whenever something changed on<BR>&gt; central 
'tnsnames.ora' file.<BR>&gt; Is this the process still being used extensively or

else <BR>&gt; advanced features<BR>&gt; like ONS.<BR>&gt; <BR>&gt; Your 
suggestions are highly appreciated.<BR>&gt; <BR>&gt; Thanks,<BR>&gt; <BR>&gt; 
Suren<BR>&gt; Consultant DBA<BR>&gt; Sony<BR>&gt; -- <BR>&gt; Please see the 
official ORACLE-L FAQ: <A 
href="http://www.orafaq.com">http://www.orafaq.com</A><BR>&gt; -- <BR>&gt; 
Author: Tirumala, Surendra<BR>&gt;&nbsp;&nbsp; INET: 
Surendra.Tirumala_at_am.sony.com<BR>&gt; <BR>&gt; Fat City Network 
Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051<BR>&gt; 
San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public 
Internet access / Mailing Lists<BR>&gt; 
--------------------------------------------------------------------<BR>&gt; To 
REMOVE yourself from this mailing list, send an E-Mail message<BR>&gt; to: 
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>&gt; the 
message BODY, include a line containing: UNSUB ORACLE-L<BR>&gt; (or the name of 
mailing list you want to be removed from).&nbsp; You may<BR>&gt; also send the 
HELP command for other information (like subscribing).<BR>&gt; <BR>-- <BR>Please

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

FAQ: http://www.orafaq.com<BR>-- <BR>Author:

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
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
--------------------------------------------------------------------
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 Mon Jul 23 2001 - 12:31:58 CDT

Original text of this message

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