Re: pushing tnsnames changes over the network

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:shs2jvo8os2rebb53hihul2v1qjki2mei0_at_4ax.com...
> On Wed, 6 Aug 2003 17:01:35 -0400, "Ray Porter" <ray_porter_at_unc.edu>
> wrote:
>
> Why building such a tool if Oracle provides Oracle Names and/or Oracle
> Internet Directory, which will both centralize the tnsnames.ora and
> have the client connect Names or OID?
>
>
> Sybrand Bakker, Senior Oracle DBA
>

Because here, and I suspect on many university/college campuses, each school and department is its own little fiefdom. With in one school on this campus each department maintains its own file servers and largely determines network architecture and which tools will be used and how they will be installed. Tech support folks in that school tell me that because of funding sources (both public and private) there is no reasonable hope of any sort of centralized tech support in that school. There are no Oracle Name Servers setup on this campus and no plans for any to my knowledge nor are there any plans for an Oracle Internet Directory. That leaves those of us supporting applications used across departments with a lot of challenges (the main app I'm concerned about is in about 60 departments across campus and several remote locations spread across the USA). Our only alternative for client-side applications at this time is a tnsnames.ora on the each workstation.

So my question stands, does anyone have a tool that might be able to push a tnsnames.ora change out across a LAN? It needs to be able to locate a single service name in the tnsnames.ora and change only that service name attributes (actually just the host name). I'm not sure how much the fact that some departments have users running applications using different versions of Oracle and may have multiple tnsnames.ora files on their workstations.

Ray Porter Received on Thu Aug 07 2003 - 08:31:49 CDT