Asked • 06/25/19

Oracle DBA, Unique situation with ORA-01017: invalid username/password; logon denied?

I am facing a very unique situation here in Oracle DB. I am facing "ORA-01017: invalid username/password; logon denied" error while logging in to my Oracle user using sqlplus. Basic information about the system: - Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production. - 2 database servers in cluster environment using Oracle clustering. Please note that while using TOAD the user logs in perfectly however. The DB is accessible from toad using the connection details to login an individual db. It fails from TOAD while using the Cluster Scan-IP. Following steps were performed before i started getting this issue. I was getting a warning message from the Oracle for my user to change the password as it is expiring. Usually in situations like this i will reuse the same password however in this case it was not allowing me to reuse the same password. So I followed [this link](http://www.dba-oracle.com/t_ora_28007_password_cannot_be_reused.htm). Now I am not able to login my user and I am even not able to completely change the password of my user and login. Please advise with what went wrong.

1 Expert Answer

By:

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.