新装完Oracle10g后,用system/password可以正常登录,而使用scott/tiger用户登录,会出现以下错误提示:
conn scott/tiger
error:    
oracle10g the account is locked     
oracle10g the password has expired
原因:
 默认Oracle10g的scott不能登陆。被禁用了。
解决方法:
(1)以DBA的身份登录
      conn sys/password as sysdba; 
(2)解锁
      alter user scott account unlock;
(3)弹出一个修改密码的对话框,修改密码
      conn scott/tiger
SQL> conn sys/sys as sysdba;
      Connected.
SQL> alter user scott account unlock;
      User altered.
SQL> commit;
      Commit complete.
SQL> conn scott/tiger//请输入新密码,并确认后OK
Password changed
Connected.
 
                    
                 

 
                
            
         浙公网安备 33010602011771号
浙公网安备 33010602011771号