RE: OID vs Oracle Names Server vs TNSNAMES.ORA vs MAD

Why not place the tnsnames.ora file on a network drive and set TNS_ADMIN in the user PC network logon scripts to point to it. Then everyone references the one central tnsnames.ora file so you have just a few tnsnames.ora file to maintain and you can probably copy over most of them.

HTH -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Goulet, Dick Sent: Wednesday, September 21, 2005 4:10 PM To: stephenbooth.uk_at_gmail.com; oracle-l
Subject: RE: OID vs Oracle Names Server vs TNSNAMES.ORA vs MAD

Stephen,

        We're using Onames, very successfully to boot, but our circumstances may not be the same as yours. We found that TNSNAMES.ora files were a royal pain in the ___. Especially if we kept then on each persons desktop. It made figuring out where anyone was going a real nightmare and the remote offices were a real pain to keep current. Onames killed all of those problems in one swoop. Now yea Onames is deprecated & obsolete in 10g so we're planning a move over to OID. The reason we're going to use OID instead of AD is simply a division of work (as you alluded to). Our NT admins, for lack of a better term, are using AD to manage the usernames & passwords of everyone connecting to the network. Yes they could also do the OID equivalent, but are not inclined to do so & don't want to grant access, for what I believe is good reason, to us. Consequently we've agreed to use OID for Oracle names resolution and AD for everything else if possible. We're even looking into single signon to see how that would work with AD as the repository. If your client in this case wants to move from tnsnames.ora files to oid as a central repository for name resolution, then I'd recommend it. Having one place to stash that stuff is much better than a couple hundred.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of stephen booth Sent: Wednesday, September 21, 2005 3:26 PM To: oracle-l
Subject: OID vs Oracle Names Server vs TNSNAMES.ORA vs MAD

My line manager grabbed me just as I was leaving today to say that one of our departments is thinking of implementing Oracle Names Server, currently they're using tnsnames.ora files on each desktop. The application they're using is a COTS Forms fat client application.

I've never used ONS (or OID for that matter), only ever needed tnsnames.ora ,and never come accross it on a course so all I really know about it is what I've picked up from the documentation (I've found that Oracle documentation tends to be great for telling you how to do stuff but less good at telling you the whys and why nots of choosing to use a particular technology).

I have a vague reccolection of attending a talk at the 2004 UK Oracle User Group conference, or maybe the 2003 conference, where the relative pros and cons of Oracle Names, tnsnames.ora and OID were outlined. I've searched the UKOUG site library and Googled but can't seem to find the slides. Does anyone happen to know where I could find the slides from that talk or a document that covers the same ground.

IIRC ONS is deprecated so would be a bad idea to implement. I'd be most likely wanting to look at OID or some alternative directory. We do use Microsoft Active Directory, which I'm aware that Net8 can use as an alternative to OID. Can anyone point me to an overview of the issues around doing that. The main issue I can envisage coming up is our directories team being unwilling to let anything they don't control writing to the directory so anything that might assuage their fears would be most useful.

Thanks in advance.

Stephen
--

It's better to ask a silly question than to make a silly assumption.
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 21 2005 - 15:33:36 CDT