ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 解锁oracle账户

解锁oracle账户

原创 Linux操作系统 作者:myownstars 时间:2011-02-11 14:46:16 0 删除 编辑

开发报告说某个账户无法登录,并报告错误该账户locked,登录查看;

SQL> select username,account_status from dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
abc                            LOCKED
OUTLN                          OPEN
SYS                            OPEN
SYSTEM                         OPEN

先将其解锁
alter user abc account unlock;

然后查看dba_profiles
SQL> select * from dba_profiles;

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT                        COMPOSITE_LIMIT                  KERNEL   UNLIMITED
DEFAULT                        SESSIONS_PER_USER                KERNEL   UNLIMITED
DEFAULT                        CPU_PER_SESSION                  KERNEL   UNLIMITED
DEFAULT                        CPU_PER_CALL                     KERNEL   UNLIMITED
DEFAULT                        LOGICAL_READS_PER_SESSION        KERNEL   UNLIMITED
DEFAULT                        LOGICAL_READS_PER_CALL           KERNEL   UNLIMITED
DEFAULT                        IDLE_TIME                        KERNEL   UNLIMITED
DEFAULT                        CONNECT_TIME                     KERNEL   UNLIMITED
DEFAULT                        PRIVATE_SGA                      KERNEL   UNLIMITED
DEFAULT                        FAILED_LOGIN_ATTEMPTS            PASSWORD 10
DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD 180

将参数FAILED_LOGIN_ATTEMPTS设置为unlimited,以后就再也不会受到此问题的困扰
alter profile default limit failed_login_attempts unlimited;

 

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

请登录后发表评论 登录
全部评论

注册时间:2010-03-18

  • 博文量
    375
  • 访问量
    3164575