scott用户被锁定的解决办法
原因：默认Oracle的scott不能登陆
解决办法
在本地终端中输入 sqlplus 登录 oracle
user-name 输入：sys as sysdba
password 输入：oracle
完成解锁操作
alter user scott account unlock;
更新密码
alter user scott identified by tiger;
退出后就可以用 scott / tiger 登录了。
操作示例如下
1[oracle@oracle ~]$ sqlplus
2
3SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 15 14:55:39 2020
4
5Copyright (c) 1982, 2009, Oracle. All rights reserved.
6
7Enter user-name: sys as sysdba
8Enter password:
9
10Connected to:
11Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
12With the Partitioning, OLAP, Data Mining and Real Application Testing options
13
14SQL> alter user scott account unlock;
15
16User altered.
17
18SQL> alter user scott identified by tiger;
19
20User altered.
21
22SQL> exit
23Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
24With the Partitioning, OLAP, Data Mining and Real Application Testing options
评论