Re: pushing tnsnames changes over the network

Thanks, Norman. The problem is that we can't have one, single tnsnames file for everyone. We have a number of departments that have in-house or vendor-supplied applications that are not directly supported by the university's central technical staff. Each of these applications has its own tnsnames entry so we can't simply overwrite the existing tnsnames file on the workstation. We have to be able to locate the active tnsnames file on each workstation and replace a single service entry within the file without modifying any other entries.

Thanks,
Ray Porter

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA7040B4E03_at_lnewton.leeds.lfs.co.uk...
> Hi Ray,
>
> can you 'pull' the changes instead of pushing ?
>
> We use NT and Win2k clients here and on logon a script is run to pick up
> the latest tnsnames.ora (and sqlnet.ora) file from a central location
> that only the admin staff can write to. This way, any changes we make to
> tnsnames.ora get picked up 'automatically' when out useres next login.
>
> As for our servers, I simply ftp the latest file to them - I only have 5
> unix boxes so it isn't a mojor hassle.
>
>
> Cheers,
> Norm.
>
> PS. I did write a tool to ftp the tnsnames.ora file up to the servers
> but it may not be helpful to you. Give me a shout privately if you want
> to take a look.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
Received on Thu Aug 07 2003 - 14:30:02 CDT