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