ALTER USER "MY_ACCOUNT" ACCOUNT UNLOCK;
CREATE PROFILE DEFAULT_10GR1 LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
ALTER USER [USERNAME] PROFILE DEFAULT_10GR1;
CREATE PROFILE TEST_PROFILE LIMIT FAILED_LOGIN_ATTEMPTS 3;
CREATE USER TESTUSER IDENTIFIED BY ABCD1234 PROFILE TEST_PROFILE;
GRANT CREATE SESSION TO TESTUSER;
CREATE PROFILE TEST LIMIT PASSWORD_LOCK_TIME 5 FAILED_LOGIN_ATTEMPTS 3;
SELECT * FROM DBA_PROFILES WHERE RESOURCE_NAME='FAILED_LOGIN_ATTEMPTS'
SELECT * FROM DBA_PROFILES WHERE PROFIILE='DEFAULT' ;
SELECT * FROM DBA_USERS WHERE PROFILE='DEFAULT';
ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
如果帐户被锁定,可以查看监听器日志看看是谁在访问,监听器日志文件为:ORA92/NETORK/LOG/LISTENER.LOG
CREATE PROFILE DEFAULT_10GR1 LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
ALTER USER [USERNAME] PROFILE DEFAULT_10GR1;
CREATE PROFILE TEST_PROFILE LIMIT FAILED_LOGIN_ATTEMPTS 3;
CREATE USER TESTUSER IDENTIFIED BY ABCD1234 PROFILE TEST_PROFILE;
GRANT CREATE SESSION TO TESTUSER;
CREATE PROFILE TEST LIMIT PASSWORD_LOCK_TIME 5 FAILED_LOGIN_ATTEMPTS 3;
SELECT * FROM DBA_PROFILES WHERE RESOURCE_NAME='FAILED_LOGIN_ATTEMPTS'
SELECT * FROM DBA_PROFILES WHERE PROFIILE='DEFAULT' ;
SELECT * FROM DBA_USERS WHERE PROFILE='DEFAULT';
ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
如果帐户被锁定,可以查看监听器日志看看是谁在访问,监听器日志文件为:ORA92/NETORK/LOG/LISTENER.LOG