oracle用户解锁

装了一个oracle，长时间不用，难免密码啥的忘了

 

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

报错：OCISessionBegin

ORA-28000: the account is locked

解决：alter user scott account unlock;--解锁

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

报错：OCISessionBegin

ORA-28001: the password has expired

试十次就锁住啦，慎重啊

解决：ALTER USER scott IDENTIFIED BY tiger ;--换密码

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

问题：SELECT * FROM dba_profiles WHERE profile='DEFAULT'

AND resource_name='PASSWORD_LIFE_TIME'

--查询密码期限，默认180天

解决：ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

--改为无限长，但不建议