Creating an User Entry in OID Fails with: ldap_add: additional info: Object already exist (Doc ID 1140355.1)

Last updated on SEPTEMBER 04, 2019

Applies to:

Symptoms

Not able to create the user in OID.
When trying to create the user through ldapadd command it returns user already exists errors message.
But cannot see the user in OIDDAS, ODM/oidadmin or from the ldapsearch result.

<ORACLE_HOME>\bin>ldapadd -h <OID_HOSTNAME> -p <OID_PORT> -D cn=orcladmin -w <password> -f C:\user.ldif
adding new entry cn=<USERNAME>,cn=Users,dc=<COMPANY>,dc=com
ldap_add: Already exists
ldap_add: additional info: Object already exists

Unable to delete the users from the OID completely.
Using ldapdelete command again does not produce any message.

<ORACLE_HOME>\bin>ldapdelete -h <OID_HOSTNAME> -p <OID_PORT> -D "cn=orcladmin" -w <password> "cn=<USERNAME>,cn=Users,dc=<COMPANY>,dc=com"

After deleting the user(s) from OID by using the ldap tools, it is still there as an entry in the ct_uid table of the ODS schema.

An ldapsearch command does not produce any output neither user information nor any error message.

<ORACLE_HOME>\bin>ldapsearch -h <OID_HOSTNAME> -p <OID_PORT> -D cn=orcladmin -w <password> -b "cn=<USERNAME>,cn=Users,dc=<COMPANY>,dc=com" -s base objectclass=*

Changes

Cause

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