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.
Labels:
Oracle
Oracle ORA errors