欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

账户锁定:ORA-28000: the account is locked

程序员文章站 2022-07-04 21:09:36
...
Caused by: java.sql.SQLException: ORA-28000: the account is locked

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
	at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:645)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:299)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	... 23 more

oracle11g中默认在default概要文件中设置了"FAILED_LOGIN_ATTEMPTS=10次",当输入密码错误次数达到设置值将导致此,该用户会自动锁住。


1. 登陆oracle(管理员)  
普通用户:sqlplus username/password;
管理员:sqlplus sys/manager as sysdba;

2. 查询被锁用户
SQL> select username, account_status from dba_users where username='xxx';

3. 解锁用户
SQL> alter user xxx account unlock;

4. 查看用户限制登陆次数
SQL> select * from dba_profiles where RESOURCE_NAME='FAILED_LOGIN_ATTEMPTS';

5. 修改用户无论输入多少次都不会被锁定
SQL> alter profile default limit failed_login_attempts unlimited;
相关标签: oracle