My Oracle Support Banner

Step by Step Guide To Troubleshooting Enterprise User Security (EUS) - Password Authentication (Doc ID 453853.1)

Last updated on JANUARY 30, 2022

Applies to:

Advanced Networking Option - Version to [Release 10.1 to 12.1]
Information in this document applies to any platform.


NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner. 

This guide provide detailed steps on verifying/troubleshooting password authenticated Enterprise User Security (EUS).

Troubleshooting Steps

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
Troubleshooting Steps
Section I: Verify the Enterprise User Security (EUS) configuration
 Step 1: Verify OID instance configuration
Step 2: Verify Enterprise User Security (EUS) configuration on the OID

Step 3: Verify the password policy for the realm
Step 4: Verify Enterprise User Security (EUS) configuration on the DB
Section II: Common Errors and Known issues
 1. ORA-1017: Invalid username/password; login denied
 2. Invalid Credentials with EUS login through OEM
3. ORA-28043: Invalid bind credentials for DB/OID connection
4. ORA-28030: Server encountered problems accessing LDAP directory service
 5. ORA-28273: No mapping for user nickname to LDAP distinguished name exists
 6. ORA-28274: No ORACLE password attribute corresponding to user nickname exists
 7. "ORA-01012: not logged on" when executing a query after successful EUS connection AS SYSDBA
 8. EUS authentication does not work when using TNS connect string
 9. ldap_search: Insufficient access
 10. EUS authentication fails when TDE and EUS wallet points to the same location
  11. ORA-1017 when connecting through proxy user

Section III: Collect Event tracing for further analysis

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