你的位置:首页 > 数据库

[数据库]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)