Oracle error
ORA-28001
ORA-28001: the password has expired
What usually causes it
The profile's PASSWORD_LIFE_TIME passed.
What to check first
Reset the password. Give service accounts a profile that suits them.
Scripts that help
- Unlock an account or reset its passwordChange the username and password before running. Quote the password so special characters are kept.
- Password profile settingsPassword rules for each profile: lifetime, reuse, failed attempts and the verify function. Shows why an account locked or expired.
- Accounts locked, expired or expiring soonApplication accounts that aren't OPEN, or whose passwords expire in the next 14 days. Catch service accounts before they break an application.