oracle解锁scott用户

来源:互联网 发布:怎么才能做淘宝客服 编辑:程序博客网 时间:2024/05/17 03:56
在plsql developer中要是以scott/tiger登录时提示ora-28000 the account is locked。   
解决办法:  
 

新装完Oracle10g后,用scott/tiger测试,会出现以下错误提示:          oracle10g the account is locked          oracle10g the password has expired  

解决方法:

SQL> conn sys/123 as sysdba; Connected.  SQL> alter user scott account unlock;           User altered.  SQL> commit;  Commit complete.  SQL> conn scott/tiger//请输入新密码,并确认后OK  Password changed  Connected. 

查看当前用户:

SQL> show user;User is "scott"


原创粉丝点击