RE: tnsnames.ora file maintenance

From: Sais, Gene <>
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: [] On Behalf Of Bobak, Mark Sent: Tuesday, March 03, 2009 3:27 PM
To:; 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.


From: [] On Behalf Of Stephen T Murphy Sent: Tuesday, March 03, 2009 3:23 PM
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: [] On Behalf Of Goulet, Richard Sent: Tuesday, March 03, 2009 3:16 PM
To:; Cc:
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: [] On Behalf Of Jared Still Sent: Tuesday, March 03, 2009 2:58 PM
Subject: Re: tnsnames.ora file maintenance

On Tue, Mar 3, 2009 at 11:00 AM, Bobak, Mark <<>> wrote:

After much experimenting w/ OID, I discovered a much simpler solution, called 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.


Received on Tue Mar 03 2009 - 14:41:38 CST

Original text of this message