CODEWITHSUNDEEP
oracle-databaseoracle11gdatabase-administration
pOrinG
pOrinG

Reputation: 935

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:

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.

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.

Upvotes: 0

Views: 3953

Answers (2)

pOrinG
pOrinG

Reputation: 935

The issue was caused because of special characters. I didn't imagine that "$" would be such a big deal in passwords. Anyway please find a work around for it here.

Upvotes: -1

sandman
sandman

Reputation: 2108

Hi I am not sure exactly what your problem is, but these are the steps we follow to reuse a password:

  • get user profile
  • change profile to default
  • ALTER PROFILE "DEFAULT" LIMIT PASSWORD_REUSE_TIME UNLIMITED;
  • ALTER PROFILE "DEFAULT" LIMIT PASSWORD_REUSE_MAX UNLIMITED;
  • change password
  • ALTER PROFILE "DEFAULT" LIMIT PASSWORD_REUSE_TIME 120;
  • change profile back

Good luck!

Upvotes: 0

Related Questions