Re: Updating TNSNAMES.ORA file from the command line?

In article <749pr3$og4$1_at_news-2.csn.net>,   "Sheila Hatfield" <Sheila.Hatfield_at_experian.com> wrote:
> We have an application that uses a variety of databases on our clients
> sites. They need access to these databases
> and our installation program needs to configure their TNSNAMES.ORA and
> SQLNET.ORA files correctly to connect up and run our application. (The
> databases which need to be configured are normally in flux, we'd like a
> dynamic way of updating the
> clients oracle configuration.)
>
> Two problems:
> 1. If we modify the either of these files outside of the SQLNet Easy
> Configuration utility the file(s) are marked as invalid, and the next time
> you do use the try to use the utility the changes the installtion program
> made are lost.
> 2. Also it's a time consuming task to parse through this file and determine
> if an entry for a database already exists in the file, and if so to update
> the entry correctly with new information.
>
> Does anyone know of a way to update this file from the command line or a
> utility that would do this ? And also possibly have the changes be accepted
> by the SQL Net Easy Config?
>
> Any help or info is appreciated. Please send a copy of your response to
> Sheila.Hatfield_at_experian.com
> Thanks!
>
> ~~
> Sheila Hatfield
> Software Engineer, Experian Database Marketing Solutions -- Denver, CO
> Sheila.Hatfield_at_experian.com
>
>
Have you considered Oracle Names? It does exactly what you want. It updates [Quoted] name server and clients get database names from the name servers.

--
Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own