- 若不能创建scott用户,先查看是否scott被锁住了
- 命令行当中运行:
启动Oraclesqlplus / as sysdba
进入scott.sql@D:\Oracle\DBS\product\12.2.0\dbhome_1\rdbms\admin\scott.sql
查看用户SHOW USER;
- 如果内容显示为
USER ""
,则表示scott被锁住了 - 解除scott被锁住:
1.alter user scott account unlock;
2.设置scott密码为tigeralter user scott identified by tiger;
3.conn scott/tiger;
4.SHOW USER;
遇到的报错和困难:
1、SQL> alter user scott account unlock; SP2-0640: 未连接
解决办法:重新启动在进程服务的OracleServiceORCL