Set Oracle User password never expired in 12C database?

ERROR:

ORA-28002: the password will expire within 7 days

ERROR at line 1:

ORA-28007: the password cannot be reused

Solution :-

 SQL> select username, account_status, EXPIRY_DATE from dba_users where username='SYSTEM';

SQL> select profile from DBA_USERS where username = 'HR';

SQL> SELECT * FROM dba_profiles WHERE profile = 'DEFAULT' AND resource_type = 'PASSWORD';

Next, change the profile limit to unlimited.

SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;

SQL> alter profile DEFAULT limit PASSWORD_REUSE_MAX unlimited;

SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME  unlimited;

SQL> ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS 100 PASSWORD_LOCK_TIME 100;

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_GRACE_TIME unlimited;

-------------------------------------------------------------------------

SQL> alter user HR account lock;

SQL> select USERNAME,ACCOUNT_STATUS,LOCK_DATE,EXPIRY_DATE,LAST_LOGIN from dba_users where USERNAME='HR';

SQL> select LIMIT, RESOURCE_NAME from dba_profiles where RESOURCE_NAME in ('PASSWORD_GRACE_TIME','PASSWORD_LIFE_TIME','PASSWORD_REUSE_MAX','PASSWORD_REUSE_TIME') and PROFILE=(select profile from dba_users where username='SYSTEM');

LIMIT           RESOURCE_NAME

UNLIMITED PASSWORD_LIFE_TIME

UNLIMITED PASSWORD_REUSE_TIME

UNLIMITED PASSWORD_REUSE_MAX

UNLIMITED       PASSWORD_GRACE_TIME

For development you can disable password policy if no other profile was set (i.e. disable password expiration in default one):

SQL> ALTER PROFILE "DEFAULT" LIMIT PASSWORD_VERIFY_FUNCTION NULL;

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

create a new policy and assign that to your users:

SQL> create profile unlimited_password_policy limit password_life_time unlimited;

SQL> alter user <username> profile unlimited_password_policy;

SQL> ALTER PROFILE unlimited_password_policy LIMIT PASSWORD_GRACE_TIME unlimited;