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

Dick, do you have documentation for installing 10g OID? I posted http://www.freelists.org/archives/oracle-l/09-2005/msg00156.html three weeks ago, but got no hits.

The only reason I need to get OID running is that while OpenLDAP does work (we tested using SunOne) for Oracle names resolution, it is not supported by Oracle. Been there, done that, don't want to do it again.

Sorry for being late on the thread, but I was out for a few weeks...

Thx!
Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_quadtechworld.com      QuadTech, Sussex, WI USA

-----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 3: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.

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