Our DB is inhouse IP and quite specific to our needs, but all we did is do a simple ERD of what is required, the wrote a conversion program to pull everything from ODS.CT_DN and ODS.DS_ATTRSTORE and load it into our own application (which is optimised for performance).

What really surprised me is that in DS_ATTRSTORE we had about 25million rows, but after we did the conversion, our equivalent table had 450,000 rows.

The end result for is that name and address updates now flow from system to system in minutes rather then hours it used to take. Our client is very happy, and we will never use OID again.

Paul

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

On 7/04/2005 at 3:08 PM Chunky Bayer wrote:

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


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