???????????????:
??????????????test?????????
????1????dba????????????????н??????????t???????????????????????SQL>altersessionsetnls_date_format=’yyyy-mm-ddhh24:mi:ss’;????Sessionaltered.??
????2?????????????????SQL>selectusername??lock_datefromdba_userswhereusername=’TEST’;????USERNAMELOCK_DATE????-------------------------------------------------????TEST2009-03-1008:51:03????
????3??????????SQL>alterusertestaccountunlock;????Useraltered.????
????4?????????ip????test???????????
??$ORACLE_HOME/network/admin/log/listener.log???????10-MAR-200908:51:03*(CONNECT_DATA=(SID=lhoms)(SERVER=DEDICATED)(CID=(PROGRAM=oracle)(HOST=omstestdb)(USER=oraoms)))*(ADDRESS=(PROTOCOL=tcp)(HOST=10.69.1.11)(PORT=49434))*establish*lhoms*0????10-MAR-200908:51:03*(CONNECT_DATA=(SID=lhoms)(SERVER=DEDICATED)(CID=(PROGRAM=oracle)(HOST=omstestdb)(USER=oraoms)))*(ADDRESS=(PROTOCOL=tcp)(HOST=10.69.1.11)(PORT=49435))*establish*lhoms*0????
?????????????????10.69.1.11??ip????????????????????
????????????????????10?γ???????????????
????1????FAILED_LOGIN_ATTEMPTS???????select*fromdba_profiles????
????2??????30?Ρ???alterprofiledefaultlimitFAILED_LOGIN_ATTEMPTS30;????
????3??????????Σ????????????????????????alterprofiledefaultlimitFAILED_LOGIN_ATTEMPTSunlimited;