Password expiration

By default Oracle 11 and newer has default that will init all new user/schema with the following policy.

• The password for the user account expires automatically in 180 days.

• The user account is locked 7 days after password expiration.

• The user account is locked for 1 day after 10 failed login attempts.

The following SQL can be used to disable all.

alter profile default limit
  failed_login_attempts unlimited
  password_life_time unlimited;

Password expiration for Schema's already created will not be affected, and must manually be changed.

To reset an expired password, a new password must be set like this:

alter user <USERID> identified by <password> account unlock;