|
故障现象：
SQL> connect scott/scott
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> connect scott/scott
ERROR:
ORA-28000: the account is locked
表明:Oracle?中 scott用户因密码不对，10次以后，就被locked。
SQL> select account_status,lock_date,profile from dba_users where username=‘SCOTT‘;
ACCOUNT_STATUS?????????????????? TO_CHAR(LOCK_DATE,‘D PROFILE
-------------------------------- -------------------- ------------------------------
LOCKED(TIMED)??????????????????? 31-MAY-2004 19:33:53 DEFAULT
这样，表明再添加oracle session时，就报错，无法连接上去。
?
故障解决：
? （1） 给当前用户解锁：
???? sql> alter user scott account unlock;
?（2） 查看当前用户的限制：
?
SQL>? SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile=‘DEFAULT‘;
RESOURCE_NAME??????????????????? RESOURCE_TYPE LIMIT
-------------------------------- ------------- ----------------------------------------
COMPOSITE_LIMIT????????????????? KERNEL??????? UNLIMITED
SESSIONS_PER_USER??????????????? KERNEL??????? UNLIMITED
CPU_PER_SESSION????????????????? KERNEL??????? UNLIMITED
CPU_PER_CALL???????????????????? KERNEL??????? UNLIMITED
LOGICAL_READS_PER_SESSION??????? KERNEL??????? UNLIMITED
LOGICAL_READS_PER_CALL?????????? KERNEL??????? UNLIMITED
IDLE_TIME??????????????????????? KERNEL??????? UNLIMITED
CONNECT_TIME???????????????????? KERNEL??????? UNLIMITED
PRIVATE_SGA????????????????????? KERNEL??????? UNLIMITED
FAILED_LOGIN_ATTEMPTS??????????? PASSWORD????? 10
PASSWORD_LIFE_TIME?????????????? PASSWORD????? UNLIMITED
PASSWORD_REUSE_TIME????????????? PASSWORD????? UNLIMITED
PASSWORD_REUSE_MAX?????????????? PASSWORD????? UNLIMITED
PASSWORD_VERIFY_FUNCTION???????? PASSWORD????? NULL
PASSWORD_LOCK_TIME?????????????? PASSWORD????? UNLIMITED
PASSWORD_GRACE_TIME????????????? PASSWORD????? UNLIMITED
表明： 10次以后，就 failed_login_attempts 就报错，锁定用户。
需要修改成：unlimited?
sql> alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;
或修改成：次数比较大：100000
sql>alter profile default limit FAILED_LOGIN_ATTEMPTS 100000；
然后再查看资源情况：
SQL> SELECT resource_name,limit FROM dba_profiles WHERE profile=‘DEFAULT‘;
RESOURCE_NAME??????????????????? RESOURCE_TYPE LIMIT
-------------------------------- ------------- ----------------------------------------
COMPOSITE_LIMIT????????????????? KERNEL??????? UNLIMITED
SESSIONS_PER_USER??????????????? KERNEL??????? UNLIMITED
CPU_PER_SESSION????????????????? KERNEL??????? UNLIMITED
CPU_PER_CALL???????????????????? KERNEL??????? UNLIMITED
LOGICAL_READS_PER_SESSION??????? KERNEL??????? UNLIMITED
LOGICAL_READS_PER_CALL?????????? KERNEL??????? UNLIMITED
IDLE_TIME??????????????????????? KERNEL??????? UNLIMITED
CONNECT_TIME???????????????????? KERNEL??????? UNLIMITED
PRIVATE_SGA????????????????????? KERNEL??????? UNLIMITED
FAILED_LOGIN_ATTEMPTS??????????? PASSWORD????? UNLIMITED
PASSWORD_LIFE_TIME?????????????? PASSWORD????? UNLIMITED
PASSWORD_REUSE_TIME????????????? PASSWORD????? UNLIMITED
PASSWORD_REUSE_MAX?????????????? PASSWORD????? UNLIMITED
PASSWORD_VERIFY_FUNCTION???????? PASSWORD????? NULL
PASSWORD_LOCK_TIME?????????????? PASSWORD????? UNLIMITED
PASSWORD_GRACE_TIME????????????? PASSWORD????? UNLIMITED
16 rows selected
SQL>
?
这样就不会用：client端因输入密码错误，造成用户被locked(timed)
?
原文链接：https://www.cnblogs.com/zougang/p/6512906.html
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
