Re: Installation of Oracle client for end users

On Tue, Jul 22, 2008 at 3:55 PM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> I generally prefer a compromise myself. Install the client software
> locally, but put the tnsnames on the network (read only). Only give dba's a
> local tnsnames.
>
>

Got rid of tnsnames.ora for (most) clients long ago.

We converted to Oracle Names.

After doing so I found that any app with high connection rates will frequently fail to resolve names with Oracle Names in 9.2.x due to a bug, so some clients get tnsnames.ora, and servers get tnsnames.ora with Oracle Names being used to resolve names not found in the local tnsnames.ora.

Now it's time to move to OID (possibly with names proxy) as 10g doesn't work with names for database name resolution.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l