Updating TNSNAMES.ORA/Upgrading SQL*Net

Our organization support several applications that utilize SQL*Net to connect to our Oracle databases. Each application has its own instance and requires it own entry in TNSNAMES.ORA. Is there an automated utility that will insert/update entries in TNSNAMES.ORA? We are thinking about writing a small application to make sure that the correct entries are in TNSNAMES.ORA, but we'd rather use an existing utility if these is one.

Also, how do you handle installing SQL*Net on the client workstations? Do you just have your client run the Oracle install program and hope they get it right? How do you handle SQL*Net upgrades? We're looking for suggestions. We would like to automate the procedure, where possible.

Regards,
  Michael

  Michael Wilson                       MWilson_at_ti.com
  SG Software Solutions
  Defense Systems & Electronics        (214) 575-3448
  Texas Instruments, Inc.              (214) 575-2628 (fax)


================================================================