关于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

已连接。