Re: updating tnsnames.ora and host file

Paul Durdin <paul.durdin_at_nospamntlworld.co.uk> skrev i artiklen <9WjS5.13591$JE1.194145_at_news2-win.server.ntlworld.com>...
> I need to programmatically update the tnsnames.ora and hosts file as part
 of
> an installation package. This keeps cropping up and I wondered how other
> folk manage this.
>
> I am forever needing to make changes to the files. I can do this as part
 of
> an install package or from SMS as part of a script. Ideally I need a
 utility
> that lets me add / amend / delete entries.
>
> I'm at the point of writing my own, but firstly I cant believe that
 someone
> hasn't already done this (e.g. Oracle?) and I note that Easy NetConfig
> complains long and hard if I make manually changes to tnsnames.ora

Me too, me too :-)
If you get any good answers I would like to know. I hate applications that simply overwrite the *.ora client files thereby smashing all other apps :( I guess one could write an app that would update the tnsnames.ora but it can be tricky to write a program that always updates the /correct/ tnsnames.ora - different orahomes, NT-registry settings, Oracle-versions etc.
Manually editing or having a program update the tnsnames.ora is not a problem. Easy Config complains about some comment info that night be lost - thats not a problem.

Peter Laursen Received on Tue Nov 21 2000 - 08:16:35 CST