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

Forget Java. Just make $ORACLE_HOME\rdbms\admin available as a UTL_FILE_DIR path and read and write with UTL_FILE.

For those interested ... you can do the same thing with SQL*Loader control files ... write them dynamically on-the-fly.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)