Re: How to programatically/dynamically update tnsnames.ora

Subrahmanyam Arya wrote:

> 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

Once again NO Oracle version & no OS name or version. :-(

Under Unix a couple of options might work as a solution.

1. cat my_custom_tns.ora >> /var/opt/oracle/tnsnames.ora
2. If the application is owned by some neutral account, then placing a .tnsnames.ora the "home" directory with the customizations will get used before any of usual locations.