Oracle密码过期如何取消密码180天限制及密码180天过期，账号锁住的问题

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

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

alter user system identified by TRANSITsystrong2017;

alter user 用户名 account unlock; 
commit;

 sql>SELECT username,PROFILE FROM dba_users;

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

 sql>ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

 sql>alter user sys account unlock;