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.