ORA-28000: the account is locked

1、用system账号登录 2、执行一下sql： ALTER USER username ACCOUNT UNLOCK; 此处username 可能为scott或者你要解锁的用户名。

、、、、、、、、、

相关配置：

1、tnsnames.ora:

 

# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_3\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-QP3ULV3GRUJ)(PORT = 1522))

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

local-test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)

 

其中SERVICE_NAME = test为Net Configuration Assistant配置的服务名；

local-test为使用plsql登录时选择的数据库名。