Menu
When trying to connect to my database with Oracle SQL Developer, I am getting the error:
ORA-28001 the password has expired
How can I change my password in SQL Developer?
222
Method 1: Using SQL*Plus (command line tool) At the command line, enter sqlplus user@database, where user is your user ID, and database is the specific database you are connecting to. Enter your current password. Once you have connected to the database, use the password command to change your database password.
create profile unlimited_pwd_prof limit password_life_time unlimited; alter user <username> profile unlimited_pwd_prof; Once you've done this you may think everything's good. So you're surprised when you login again and still hit the ORA-28002 error.
ORA-28001 means that your password has been expired according to your profile. Normally, you should change the password, but you can still work around it. Don't be confused with ORA-28000: The account is locked, it's a different account problem.
Open SQL Developer and perform the following steps:
Right click on Connections > New Connection.
click connect.
Expand other users, and choose the user with the expired password. Right click and "edit" the user, enter the new password and confirm it.
If you want your password to never expire again uncheck the box for password expiry.
158
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
