My Oracle Support Banner

OID 11g Erroneous "LDAP: error code 19 - Attribute Uniqueness Constraint Violation" When Trying to Re-Add an Entry After bulkdelete (Doc ID 2420157.1)

Last updated on JULY 28, 2020

Applies to:

Oracle Internet Directory - Version 11.1.1 and later
Information in this document applies to any platform.


Oracle Internet Directory (OID) 11g bulkdelete tool is not removing all the records from OID Database (DB) related tables when an entry having an unique attribute defined is processed.

Once a unique attribute is defined in OID and an entry is added, a record is also added in OID uniqueness related table for that particular entry. If that entry is then deleted using bulkdelete tool, the entry from the table is not deleted.

Later on, if the same initial entry is added again in OID using ldapadd, Oracle Directory Services Manager (ODSM) or another ldap method, an LDAP 19 error then occurs.

Steps to Reproduce:

1. Create an uid_unique - Attribute Uniqueness Constraint, with Unique Attribute Subtree - cn=Users, dc=example,dc=com.

2. Create a test user in ODSM.

3. Use bulkdelete command such as below to delete this particular user:





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.