Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Best way to updat TNSNames.ora in all servers
Krish wrote:
> Hi All,
> We have many unix (hp-ux, AIX, Linux, Solaris) servers running Oracle
> database 9.2.0 enterprise edition. Each server has 4 or more
> databases. Currently each unix server has its own tnsnames.ora in /etc
> folder and all windows machines TNS_ADMIN is pointing to a shared
> drive.
>
> we are planning to implement one of the below methods to avoid
> "ORA-12154" error whenever new db is created and forgot to update all
> the tnsnames.ora files.
> 1.creating TNSNames.ora in a shared (NFS mounteed) file system and
> pointing all servers TNS_ADMIN to this shared drive.
> 2.shell sciprt to replace all the tnsnames.ora files with the master
> tnsnames.ora( master tnsnames.ora file will be updated whenever new db
> is created)
>
> I would like to know the experts comments, suggestions.
>
> Thanks in advance for all your help.
>
> Krish.
And the logic, or lack thereof, creating additional databases on the same server? With an unpatched neolithic version of the product? I find paper cuts less painful.
I'd suggest looking at moving to a single operating system, perhaps Oracle Linux and a supported version of the database, perhaps 10.2.0.3. And consolidating everything into a single database with multiple schemas.
With any luck at all the DBAs might not find themselves working on Sunday.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sun Sep 23 2007 - 19:11:29 CDT
![]() |
![]() |