How to programatically/dynamically update tnsnames.ora

Dear oracle gurus,

This is exactly my scenario. I have a java application which talks to Master oracle DB. From with in this java application, i create database links to remote oracle databases and do queries. the database links are dynamically created as and when new remote database comes up.
Presently we are distributing this application and are having the customers edit the tnsnames.ora either manually or use them netasst (SQL Net configurator)

But eventually we do not want them to edit manually.

Has anybody attempted to programatically update the tnsnames.ora either using a unix script or from inside java. are there any bad consequences to doing this.

Previously i had miserable experience with editing this file manually and things did not work until i used netasst (SQL Net program).

Another reason why we donot want customers to edit tnsnames / use SQL Net is licensing restrictions and contractual obligations. We got oracle licenses for cheap and we cannot expose oracle or expect the end user to do any kind of DBA activity

So what i am looking for is some easy custom script / tool that does exactly what SQL.Net does to tnsnames.ora

-thx,
avsrk Received on Thu Jul 31 2003 - 08:52:53 CDT