oracle11g hr密码错误,oracle11g防止密码错误尝试多次被锁定

Xshell for Xmanager Enterprise 4 (Build 0193)

Copyright (c) 2002-2011 NetSarang Computer, Inc. All rights reserved.

Type `help' to learn how to use Xshell prompt.

Xshell:\>

Connecting to 10.0.1.6:22...

Connection established.

To escape to local shell, press 'Ctrl+Alt+]'.

Last login: Fri Apr 20 10:35:48 2012 from 172.1.9.233

[oracle@cjdb01 ~]$ sqlplus sys/pass as sysdba

修改用户错误密码尝试次数为无限次

以下百度复制来的：

具体修改方法：

1、修改FAILED_LOGIN_ATTEMPTS的值

SQL>select * from dba_profiles where RESOURCE_NAME='FAILED_LOGIN_ATTEMPTS';

PROFILE              RESOURCE_NAME                  RESOURCE LIMIT

-------------------- ------------------------------ -------- ----------

DEFAULT              FAILED_LOGIN_ATTEMPTS          PASSWORD 10

SQL> alter profile default limit failed_login_attempts 100;

SQL> select * from dba_profiles where RESOURCE_NAME='FAILED_LOGIN_ATTEMPTS';

PROFILE              RESOURCE_NAME                  RESOURCE LIMIT

-------------------- ------------------------------ -------- ----------

DEFAULT              FAILED_LOGIN_ATTEMPTS          PASSWORD 100

2、修改为无限次尝试

SQL> alter profile default limit failed_login_attempts unlimited;

SQL> select * from dba_profiles where RESOURCE_NAME='FAILED_LOGIN_ATTEMPTS';

PROFILE              RESOURCE_NAME                  RESOURCE LIMIT

-------------------- ------------------------------ -------- ----------

DEFAULT              FAILED_LOGIN_ATTEMPTS          PASSWORD UNLIMITED