Oracle Change default Password Expiration days

When the application fails, it runs up and finds that the application interface has always reported a wrong logon database user and password. After checking that the Oracle database is restarted, the user name and password policies exceed the validity period.
 
Solution:

1. view which profile policy is used by the user
 
SQL> select username, profile from dba_users;
 
USERNAME PROFILE
 
-----------------------------------
 
MGMT_VIEW DEFAULT
 
SYS DEFAULT
 
SYSTEM DEFAULT
 
EKPUSER DEFAULT
 
2. view the valid days of the policy

SQL> Select * FROM dba_profiles s Where s. profile = 'default' AND resource_name = 'password _ LIFE_TIME ';
 
 
PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
 
-------------------------------------------------------------------------
 
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
 
 
3. Change the policy to unrestricted
 
SQL> Alter PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
 
Profile altered
 
4. check and confirm
 
SQL> Select * FROM dba_profiles s Where s. profile = 'default' AND resource_name = 'password _ LIFE_TIME ';
 
PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
 
-------------------------------------------------------------------------
 
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED
 
Modify to take effect immediately without restarting the database