oracle 的密码策略及密码修改

1.找到用户对应的配置文件
select username,account_status,profile from dba_users;
--------------------------------
USERNAME   ACCOUNT_STATUS             EXPIRY_DA             PROFILE
SYSTEM       EXPIRED & LOCKED              26-JAN-19            DEFAULT

2.查看配置文件中，密码有效期的配置
select * from dba_profiles s where s.profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

3.修改为无限制

alter profile default limit password_life_time unlimited;

4.修改密码并解锁用户

alter user system identified by newpassword;

alter user system account unlock;