Updating TNSNAMES.ORA file from the command line?
Date: 1998/12/04
Message-ID: <749pr3$og4$1_at_news-2.csn.net>#1/1
[Quoted] [Quoted] 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 [Quoted] 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
Received on Fri Dec 04 1998 - 00:00:00 CET