OUD 11g / 12c - EUS Error when Attempting to Login Using "sqlplus" - "ORA-01017: invalid username/password; logon denied"
(Doc ID 2118421.1)
Last updated on MAY 30, 2023
Applies to:
Oracle Unified Directory - Version 11.1.2.3.0 and laterInformation in this document applies to any platform.
Symptoms
OUD has been configured for EUS integration. However, OUD (LDAP) users are unable to connect from database to OUD.
Error generated on the database side...
ERROR:
ORA-28030: Server encountered problems accessing LDAP directory service
ORA-28030: Server encountered problems accessing LDAP directory service
And the corresponding access log on the OUD side...
[03/Mar/2016:12:25:03 +0000] DISCONNECT conn=115 reason="Client Disconnect"
[03/Mar/2016:12:25:03 +0000] CONNECT conn=116 from=<IP>:46487 to=<IP>:1636 protocol=LDAPS
[03/Mar/2016:12:25:04 +0000] DISCONNECT conn=116 reason="Client Disconnect"
[03/Mar/2016:12:25:03 +0000] CONNECT conn=116 from=<IP>:46487 to=<IP>:1636 protocol=LDAPS
[03/Mar/2016:12:25:04 +0000] DISCONNECT conn=116 reason="Client Disconnect"
Patch 19285025 is then applied to address the ORA-28030 error. A subsequent attempt to log in using sqlplus results in the following error...
ORA-01017: invalid username/password; logon denied
with trace file error output...
kzld_search -s sub -b cn=DB,cn=OracleContext,dc=xx,dc=com
search filter: (&(objectclass=orcldbEntrylevelMapping)(orclDBDistinguishedName=uid=user.10,ou=People,dc=xx,dc=com))
KZLD_ERR: failed the search 28304.
KZLD_ERR: 28304
kzld_search -s sub -b cn=DB,cn=OracleContext,dc=xx,dc=com
search filter: (&(objectclass=orcldbSubtreelevelMapping)(orclDDistinguishedName=ou=People,dc=xx,dc=com))
KZLD_ERR: failed the search 28304.
KZLD_ERR: 28304
search filter: (&(objectclass=orcldbEntrylevelMapping)(orclDBDistinguishedName=uid=user.10,ou=People,dc=xx,dc=com))
KZLD_ERR: failed the search 28304.
KZLD_ERR: 28304
kzld_search -s sub -b cn=DB,cn=OracleContext,dc=xx,dc=com
search filter: (&(objectclass=orcldbSubtreelevelMapping)(orclDDistinguishedName=ou=People,dc=xx,dc=com))
KZLD_ERR: failed the search 28304.
KZLD_ERR: 28304
How to configure the database to output a trace file -
(from EUS Authentication Fails With ORA-28030 (Doc ID 783502.1))
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |