Sounds like I'm going to have to write something - but I am amazed that
Oracle don't already have this?
--
Paul Durdin
Peter Laursen < ptl_at_edbgruppen.dk> wrote in message
news:01c053c5$aabf2450$2c289a0a_at_apollo...
> 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 - 16:28:52 CST
