Oracle-L: RE: shared tnsnames.ora

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Thu, 27 Feb 2003 14:44:07 -0800
Message-ID: <F001.0055C483.20030227144407@fatcity.com>

Regarding distributing the tnsnames - you could use a very simple Windows batch file to do that (eg have PC names in 1 text file) and use FOR /F to process it. This works best if tnsnames lives in the same place on each client. Or create an env variable / registry key on each client to point to a common network share (that had better be available all the time).

With respect to listener.ora and localhost - has anyone using OEM's Intelligent Agent (IA) got the IA to be able to discover databases where you use localhost in the listener - I haven't yet.

Regards,
Bruce Reardon
-----O riginal Message-----
Sent: Friday, 28 February 2003 9:14 AM
To: Multiple recipients of list ORACLE-L

If you are not going to use Onames, another consideration is to create an DNS alias for your db server host and use the alias in the tnsnames file for host value. It makes it easy to the move database to another server and make 1 change to DNS.

On the listener side, I always use localhost for host value. hth,
Gene
>>> rlsmith_at_kmg.com 02/27/03 03:49PM >>>
Below is the end of my own tnsnames.ora located on my PC. There is a common network tnsnames.ora on a network share located on my 'R' drive. The network version has all the permanent databases defined in it. I can add any temporary or new test servers to my copy of tnsnames.ora and still get to all the permanent entries when ever I need to. Works great!

R. Smith

test.world =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = someserver)
          (Port = 1521)
        )

    )
    (CONNECT_DATA = (SID=test)
    )
  )
ifile=r:\tnsnames.ora

-----Original Message-----
Sent: Thursday, February 27, 2003 2:24 PM

Use Oracle Names. Easy to setup/maintain. never touch a client config again.

Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
Each new user of a new system uncovers a new class of bugs. -- Kernighan

I am looking for info on how you support a large number of PCs (200+) and keep each ones tnsnames.ora file in sync. It seems that most people do not touch them. Some try to modify them and when new databases are created, the tnsnames.ora files must be changes as well. It seems to be that a shared tnsnames.ora file on a network drive may work. I remember a thread awhile back about
the order of resolution (home directory, then OH/network/admin .....). Again, I am asking about
people using the Oracle client to connect to 15+ databases (v7.3.4 - 9.0.x) on 10+ different
servers. I have just started to think about this and posted here before I started my MetaLink
search.
TIA for any info.
JF
John Fedock
"K" Line America, Inc.
www.kline.com
( 804.327.4444
* john.fedock_at_us.kline.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Feb 27 2003 - 16:44:07 CST