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 18.104.22.168.0 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