I agree that Oracle OID is a pig!!

But I though I read somewhere that you can use MS AD as an ldap server..

Any one got it running? Any thoughts?



-----Original Message-----
From: Chunky Bayer
[mailto:oracledba-ezmlmshield-x6717766.[Email address protected]
Sent: Wednesday, April 06, 2005 1:15 PM
To: LazyDBA Discussion
Subject: Re: centralized tnsnames.ora - OID is a pig

Oracle have dropped support for Oracle Names. It's no longer a product.
It's been replaced by Oracle Internet Directory (OID) which is an ldap
server, but with enough Oracle initial data to make it slightly
difficult to use a vanilla ldap server.

OID is a pig. It's unreliable and corrupts your TNS data. Also, the
redundancy features in the sqlnet client part don't work with some
application servers, coldfusion in particular. So your limited to a
single point of faliure. i.e. you can only point your client at one TNS
server (like having one DNS server) , so when you want to do maintanance
on your TNS server it a big deal. And believe me you'll want to do
maintenance.
Regularly.

You would have to be career-suicidal to want to use it for servers,
there may be some value in having people's PCs point to an OID server,
especially if you have a lot of them, but for the machines that your
databases run on, stick with a good old fashioned tnsnames.ora file.



Oracle LazyDBA home page