Sunday, March 13, 2016

ORA-28002: the password will expire

When you get below error from Oracle DB it indicate its time for you to change the Password. However you can get ride of this message if you set the password expired field as unlimited. I am using sqldeveloper hence showing you the UI screen wise navigation to do the same.
A database warning was encountered performing the requested operation:
ORA-28002: the password will expire within 7 days
28002. 00000 - "the password will expire within %s days"
*Cause: The user's account is about to expire and the password
needs to be changed
*Action: change the password or contact the DBA
Vendor code 28002
Use another user to log into any database connection you have, you can also use the default "system" or "sys" username.
Open connection tree and find the "Other Users" node and open that like so :
Find your username in the child notes under "Other Users" and right click to edit user like so:
Type in your new password and Un-check password expired, then apply. Right click edit user again to see if the settings were changed if you wish.

No comments: