solve ORA-01017: invalid username/password; logon denied in oracle

Resolve ORA-01017: invalid username/password; logon denied in oracle.

In this tutorial we will try to find out appropriate solution to ORA-12505, ORA-01017: invalid username/password; logon denied in oracle.


It is very issue to solve this error, and probably it will take couple of minutes to sort out this issue.




>First of all, you must ensure that id and password you are passing are correct.

>Or, you may try resetting the password again using the following command -

ALTER USER user_name IDENTIFIED BY new_password;

Example-
user_name = ankit
new_password=Oracle123

ALTER USER ankit IDENTIFIED BY Oracle123;


In CMD >
Enter sqlplus using admin user system.
And execute ALTER USER command.
C:\Users\ankitmittal01>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 1 23:34:28 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: system
Enter password:

SQL> ALTER USER ankit IDENTIFIED BY Oracle123;

User altered.

Now, your password has been changed, login using id and new_password.

And it will solve ORA-01017: invalid username/password; logon denied error in oracle.

If you still facing any problem, or if it does not solve your problem completely, please comment below.

No comments:

Post a Comment