oracle user account locked

1.Question describe 

   when you use account scott/tiger connect to oracle, you will see "the user account is locked",

   because you did't unlock the account when you install the oracle.

2.Solution:

   ~login in account system/Cnblogs1900 (the password is setted when you installl the oracle)

   ~alter user scott account unlock;(you will see ,user has changed.)

   ~commit;(you will see , commit finished)

   ~conn scott/tiger(you will see, the password has expired, and change the password, please input the new password)

   ~(after you set the password, you can connect with the user scott account)

posted @ 2016-03-21 09:34  fanblog  阅读(565)  评论(0)    收藏  举报