关于Oracle 10g scott用户解锁的方法

在安装完Oracle10g之后，默认scott用户是锁定状态的，必须解锁才能使用。

打开SQL*Plus

以system和用户名登录后，执行下面的命令：

SQL> select username , account_status from dba_users;

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SYSMAN OPEN
OUTLN EXPIRED & LOCKED
MDSYS EXPIRED & LOCKED
ORDSYS EXPIRED & LOCKED
EXFSYS EXPIRED & LOCKED
DMSYS EXPIRED & LOCKED
WMSYS EXPIRED & LOCKED

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
CTXSYS EXPIRED & LOCKED
ANONYMOUS EXPIRED & LOCKED
XDB EXPIRED & LOCKED
ORDPLUGINS EXPIRED & LOCKED
SI_INFORMTN_SCHEMA EXPIRED & LOCKED
OLAPSYS EXPIRED & LOCKED
SCOTT EXPIRED & LOCKED
TSMSYS EXPIRED & LOCKED
BI EXPIRED & LOCKED
PM EXPIRED & LOCKED
MDDATA EXPIRED & LOCKED

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
IX EXPIRED & LOCKED
SH EXPIRED & LOCKED
DIP EXPIRED & LOCKED
OE EXPIRED & LOCKED
HR EXPIRED & LOCKED

已选择27行。
这里我们看到scott账户是锁定状态的，下面开始解锁

SQL> alter user scott account unlock;

用户已更改。

这样就完成解锁的操作。接下来，给scott用户设定密码

修改scott的登录密码

SQL> alter user scott identified by tiger;

tiger就是scott的用户密码

SQL> conn scott/tiger

已连接。