Tuesday, January 31, 2017

ORA-28001: the password has expired

when ever u are facing below error execute following step to bypass it.
An error was encountered performing the requested operation:
ORA-28001: the password has expired
28001. 00000 - "the password has expired"
*Cause: The user's account has expired and the password needs to be
*Action: change the password or contact the DBA
Vendor code 28001
Step 1:- We are using SQLDeveloper else u can also use the command prompt
Right click on Connections > New Connection.
Connection Name: LOCALHOST
Username: SYSTEM
Password: (or your sys password)
Hostname: your database server IP
Port: 1521
SID: your sid
click connect.
Step 2:- Expand other users, and choose the user with the expired password.
Step 3:- Right click and "edit" the user, enter the new password and uncheck Passowrd Expired check box and confirm it.
Either follow this steps

No comments: