The Oracle error “ORA-28002: The password will expire within X day(S)” is a warning that the user account will soon expire. The user password must be changed; otherwise, the database administrator (DBA) will be required to assist.
The attached article offers instructions on how to change a database user password and provides steps to remove the default password expiration period set in Oracle 11g from 180 DAYS to UNLIMITED. This will prevent user passwords from expiring - thus preventing the same error from being displayed again in the future.
Comments
0 comments
Please sign in to leave a comment.