Full Agreement here - we have 5 OID databases used to store names & addresses. The thing was such a beast that we dumped it in favour of a custom 9iR2 database. Result is a dataset 10% of the size and performance about 10,000% better!

*********** ORIGINAL MESSAGE ***********

On 7/04/2005 at 8:09 AM O Donnell Kevin wrote:

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.




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page