装了一个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
--改为无限长,但不建议