ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 用户登录相关

oracle 用户登录相关

原创 Linux操作系统 作者:tian1982tian 时间:2012-06-20 17:06:30 0 删除 编辑

oracle 9I:
数据库用户登陆10次以上用户不被锁,且在user$视图里的登陆错误信息也没有
SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn hr/hr1
ERROR:
ORA-01017: invalid username/password; logon denied


SQL>  select name,lcount
  2  from user$
  3  where name='HR';

NAME                               LCOUNT
------------------------------ ----------
HR                                      0

SQL> /

NAME                               LCOUNT
------------------------------ ----------
HR                                      0

SQL> /

NAME                               LCOUNT
------------------------------ ----------
HR                                      0

SQL> /

NAME                               LCOUNT
------------------------------ ----------
HR                                      0

SQL>

oracle 10G:
数据库用户登陆10次以上用户被锁,且在user$视图里的登陆错误信息被记录

SQL> conn bdi/bdi
Connected.
SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> conn bdi/890
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn bdi/12
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> conn bdi/12
ERROR:
ORA-28000: the account is locked

SQL> select name,lcount
  2  from user$
  3  where name='BDI';

NAME                               LCOUNT
------------------------------ ----------
BDI                                     0

SQL> /

NAME                               LCOUNT
------------------------------ ----------
BDI                                     1

SQL> /

NAME                               LCOUNT
------------------------------ ----------
BDI                                     2

SQL> /

NAME                               LCOUNT
------------------------------ ----------
BDI                                    10

SQL> /

NAME                               LCOUNT
------------------------------ ----------
BDI                                    10

SQL>

SQL> alter user bdi accouont unlock;
SP2-0640: Not connected
SQL> conn / as sysdba
Connected.
SQL> alter user bdi account unlock;

User altered.

SQL>

在这里我终于明白了一件事情,好几次开发来找我说是数据库连不上,我一用户连数据库,就报数据库用户被锁了,
原来是开发把密码搞错了,输入错误密码超过10次以上oracle就会自动的把用户锁掉,下次开发的来找可有话说了

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16400082/viewspace-733462/,如需转载,请注明出处,否则将追究法律责任。

下一篇: ORACLE 表连接方式
请登录后发表评论 登录
全部评论

注册时间:2010-12-29

  • 博文量
    70
  • 访问量
    163927