| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: shared tnsnames.ora
The problem is if that shared tnsnames.ora then becomes a massive single
point of failure.
If for some reason someone messes up this file or it becomes unavailable. All your users would be left out of the databases.
I REALLY think Oracle Names is the way to go. (I have used it in 1000+ user environments with very little problems) When you use two names servers you really have a solid reliable set up that makes adding and removing dbs a snap. (those huge tnsnames.ora files drive me nuts)
Set up two servers and lose the tnsnames.ora file. you only need the SQLNET.ora file with preferred oracle names entries.
What can be done too is to use DNS aliases to direct users to servers aliased as ONAMES1 and ONAMES2. That way if you swap out boxes in the future you no longer have to mess editing a sqlnet.ora file. Just change the DNS alias name to point at the new names server...
Security wise it makes big sence too as the SID, host and port are hidden from the user community.
Unless you WANT to make busy work for yourself maintaining tnsnames files....(yuk)
BRad
-----Original Message-----
Sent: Thursday, February 27, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
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)
)
-----Original Message-----
Sent: Thursday, February 27, 2003 2:24 PM
To: Multiple recipients of list ORACLE-L
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
John.Fedock_at_us.kl
ine.com To:
ORACLE-L_at_fatcity.com
Sent by: cc:
root_at_fatcity.com Subject: shared tnsnames.ora
02/27/2003 12:56
PM
Please respond to
ORACLE-L
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: Ron Thomas INET: rthomas_at_hypercom.com 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). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: rlsmith_at_kmg.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: Brad.Odland_at_qtiworld.com 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:27:43 CST
 |
 |