My Oracle Support Banner

SQLPlus Local Login on the Database (DB) Host Fails with "ORA-01017: invalid username/password; logon denied" If an ldap.ora File Exists / Is Present in DB $ORACLE_HOME/network/admin Location (Doc ID 2818922.1)

Last updated on APRIL 17, 2023

Applies to:

Advanced Networking Option - Version and later
Information in this document applies to any platform.


After registering the Database (DB) with an LDAP server using DBCA, able to bind and login for the database registered ok.

However, if the ldap.ora file exists on the DB $ORACLE_HOME/network/admin location, then not able to login locally as "sqlplus / as sysdba" for all the instances running on that node.

Also when using SRVCTL the same error occurs: It fails with OCI error Invalid username/password.

ORA-01017: invalid username/password; logon denied

Removing the ldap.ora from DB Home location above, then "sqlplus / as sysdba" login works fine.

All other nodes that have similar setups are working fine. The issue affects this one host only.


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.