账户锁定: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;
下一篇: 寒假的120道pta的总结
推荐阅读
-
oracle11g用户登录时被锁定问题的解决方法 (ora-28000 the account is locked)
-
ORA-28000: the account is locked-的解决办法
-
ORA-28000: the account is locked-的解决办法
-
账户锁定:ORA-28000: the account is locked
-
ORA-28000: the account is locked解决
-
ORA-28000: the account is locked用户锁定问题排查解决
-
ORA-28000: the account is locked-的解决办法
-
ORA-28000: the account is locked解决
-
oracle11g用户登录时被锁定问题的解决方法 (ora-28000 the account is locked)