Could you post the basic steps to convert OID to a custom database to the
list. I'd love to dump it.

Thanks,
Chunky.

----- Original Message -----
From: "Paul Murgatroyd "
<oracledba-ezmlmshield-x29656826.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, April 07, 2005 2:40 PM
Subject: Re[2]: centralized tnsnames.ora - OID is a pig


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

Oracle LazyDBA home page