su - oracle
sqlplus / as sysdba

SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT'AND resource_name='PASSWORD_LIFE_TIME';

select username,account_status,expiry_date,profile from dba_users where account_status='OPEN';

--180天期限
alter profile default limit password_life_time '180';

--永久期限
alter profile default limit password_life_time unlimited;

alter user 用户名 identified by 新密码；

alter user system account unlock;