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

已連接配接。