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 19.0.0.0.0 and later
Information in this document applies to any platform.

Symptoms

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.

ERROR:
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.

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


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