十、ORA-01017

king's blog

问题描述:连接数据时用户名/口令错误,拒绝登录,导致用户被锁(ORA-01017)

ORA-01017

解决办法:

步骤一:先解锁

sqplus / as sysdba
alter user system account unlock;

1
2
3
4
5
6
7
8
9
10
11
12
oracle@ETS157:~> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 5 09:46:23 2017

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter user system account unlock;

步骤二:重新设置密码即可

alter user system identified abc;

备注:再重新设置密码,可与原来的密码相同,其中abc代表新密码

1
SQL> alter user system account unlock;
Tags:
文 / 甲乙丙丁
LEAVE A REPLY

loading