RE: tnsnames.ora file maintenance
Date: Tue, 3 Mar 2009 15:41:38 -0500
Message-ID: <1F5BB50762DC2048B9ADD414A336E1C5B12CD3F5D2_at_CLERKMAIL07.Clerk.local>
I prefer to set the TNS_ADMIN variable to a common directory. If someone wants to use their own tnsnames, they can delete the TNS_ADMIN environment variable. Otherwise, everyone shares the same tnsnames.ora file. The tnsnames.ora file gets updated infrequently and when it does, it gets distributed to the desktops upon login.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark Sent: Tuesday, March 03, 2009 3:27 PM
To: SMurphy_at_uamail.albany.edu; oracle-l_at_freelists.org Subject: RE: tnsnames.ora file maintenance
From the webpage, looks like it's limited to Windows, Solaris, and Linux.....Of course, it could certainly serve up LDAP to any platform, including AIX, it's just the program itself needs to run on one of the three aforementioned OSes.
-Mark
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stephen T Murphy
Sent: Tuesday, March 03, 2009 3:23 PM
To: oracle-l_at_freelists.org
Subject: RE: tnsnames.ora file maintenance
Is there an AIX version of tnsManager?
- *---------------------------------------------------------------------------*
Stephen T. Murphy
Manager, Database and Technical Support
ITS - University Applications Development
MSC-100
The University at Albany, S.U.N.Y.
Albany, New York 12222
Phone: (518) 437-4523 Fax: (518) 437-4540
MailTo: SMurphy_at_UAMail.Albany.EDU<mailto:%20SMurphy_at_UAMail.Albany.EDU> AIM: SMurphy199
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Goulet, Richard Sent: Tuesday, March 03, 2009 3:16 PM
To: jkstill_at_gmail.com; Mark.Bobak_at_proquest.com Cc: oracle-l_at_freelists.org
Subject: RE: tnsnames.ora file maintenance We downloaded it and did manage to get it running on Windoze as well as Linux. It is not bad, except that your names are restricted to the first . in the name. In our case CORE.PROD.MMS.US got tied up with CORE.TEST.MMS.US. Type either into tnsping and you got the first one that answered. You have to change them to CORE_PROD_MMS_US. Phooey!
Dick Goulet
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Tuesday, March 03, 2009 2:58 PM
To: Mark.Bobak_at_proquest.com
Cc: oracle-l_at_freelists.org
Subject: Re: tnsnames.ora file maintenance
On Tue, Mar 3, 2009 at 11:00 AM, Bobak, Mark <Mark.Bobak_at_proquest.com<mailto:Mark.Bobak_at_proquest.com>> wrote:
After much experimenting w/ OID, I discovered a much simpler solution, called tnsManager.
See:
http://www.shutdownabort.com/tnsmanager/
I looked at that a few months ago.
Now I can't recall if I got it to work or not.
The problem I see with that is the inevitable issues with any TNS name resolution errors, and working with support.
Jared
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 03 2009 - 14:41:38 CST