OCI-28098
Profile limits PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME are not unlimited, password will expire within string days.
Cause
The password of the user's account expired and entered the grace period and should be changed. This can happen if any of the following is true:
- The user account is associated with a password profile with a limited PASSWORD_LIFE_TIME and a non-zero PASSWORD_GRACE_TIME.
- The user account is created as part of either a database import inside a pluggable database (PDB) or clone of an existing PDB and the user's password does not meet the requirements of the mandatory profile (that is configured with a limited password grace period) enforced in the PDB. Since the password grace period has not yet elapsed, the user is not prompted to input a new password and an ORA-28098 warning message continues to be displayed upon each successful login to the user account, until the user changes their password. After the grace period has elapsed, the password expires and until the user successfully changes their password their login continues to fail with an ORA-28001 error.
Action
Change the password or contact the database administrator to understand the rules for choosing a new password that complies with the mandatory profile.