4 Replies Latest reply on May 6, 2014 9:49 PM by 900846

Bulk delete entries from an OU in OUD

900846 Apr 23, 2014 10:23 PM

Hi All,

Is there any option to delete all the entries inside an OU in OUD.

I tried options:

a) I tried delete ou by logging into ODSM. Since i have 2 million user entries inside that OU, it is giving a timeout error after a 1 min.

b) I tried ldapdelete by providing a file with the list of dn's which needs to be deleted. It runs for a while and after sometime it gives an error Can't contact LDAP server.

Is there any setting which i need to increase the time out? Or is there an alternative way to do a bulk delete in OUD.

regards,

Ram

1. Re: Bulk delete entries from an OU in OUD

Sylvain Duloutre-Oracle Apr 23, 2014 10:58 PM (in response to 900846)

Hello

The Subtree Delete Control (1.2.840.113556.1.4.805) supported by OUD (Supported LDAP Controls - Oracle Fusion Middleware Architecture Reference for Oracle Unified Directory) might fit your needs.
This control is attached to a delete request to indicate that the specified entry and all descendant entries are to be deleted.
You must have appropriate privileges to do that (admin account)

You can attached control to a ldapdelete using the -J option as described in ldapdelete - Oracle Fusion Middleware Command-Line Usage Guide for Oracle Unified Directory

Sylvain

------
When closing a thread as answered remember to mark the correct and helpful posts to make it easier for others to find them
1 person found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Bulk delete entries from an OU in OUD

900846 Apr 25, 2014 3:14 AM (in response to Sylvain Duloutre-Oracle)

Thanks Sylvain.

I tried with this command to delete entries

ldapdelete -J subtreedelete -h localhost -p 1389 -D "cn=Directory Manager" -w password -x ou=ext,ou=users,dc=example,dc=com

There are about 2 lakhs entries inside this OU and it is taking infact it is running since a hr and still it has not completed the operation.

Is there some other setting which i need to do.

regards,
Ram
Like Show 0 Likes(0)

Actions
3. Re: Bulk delete entries from an OU in OUD

Sylvain Duloutre-Oracle Apr 25, 2014 4:52 PM (in response to 900846)

Hello,

There is no additional thing to do, adding the control should work.
If it takes a very long time to delete thats one thing, if it never completes and seem to hang this is another thing.
Has it deleted some entries or does it seem to hang w/o deleting any entry ?
Current implementation may be slow with large trees.
If the problem persists, I would encourage you to contact the Oracle Support so that they can investigate

Sylvain

------
When closing a thread as answered remember to mark the correct and helpful posts to make it easier for others to find them
Like Show 0 Likes(0)

Actions
4. Re: Bulk delete entries from an OU in OUD

900846 May 6, 2014 9:49 PM (in response to Sylvain Duloutre-Oracle)

Thanks Sylvain, i have raised an SR and awaiting for the response
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.