Application Login Fails With ORA-28273: No Mapping For User Nickname To LDAP Distinguished Name Exists (Doc ID 436989.1)

Symptoms

• Custom application fails to login an EUS user with:

  2007-06-20 10:40:19,250 DEBUG xxxxxx..util.BeginTransactionInterceptor - Begin
    TX in xxxxxxxxx.UserManager.fetchUserPreferences
    for cn=<USERNAME>,cn=users, dc=<COMPANY>,dc=com
  2007-06-20 10:40:25,828 ERROR xxxxxx.xxxxx Error.jsp - Exception-ID
    1182350425812
  org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC
  Connection for transaction; nested exception is
    java.sql.SQLException: ORA-28273: No mapping for user nickname to LDAP
    distinguished name exists.
    java.sql.SQLException: ORA-28273: No mapping for user nickname to LDAP
    distinguished name exists.
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)

• Oracle Enterprise Security Manager shows that the user search base containing this user is listed in the Oracle Context being used
• The user entry exists in OID
• The user is able to connect via sqlplus
• The user is able to ldapbind to OID:

  ldapbind -h <OID_HOSTNAME> -p <OID_PORT> -D "<full_user_DN>" -w <PASSWORD>

• The uid (login username) for this user is correct:

  ldapsearch -h <OID_HOSTNAME> -p <OID_PORT> -D "cn=orcladmin" -w <PASSWORD> -s base -b "<full_user_DN>" "objectclass=*" uid

• Login with this uid to the Self-Service Console is successful, at:

  http://<INFRA_HOSTNAME>:<HTTP_PORT>/oiddas

Cause

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