Oracle?????????????????????ν????
???????????? ???????[ 2016/7/29 10:13:42 ] ????????????? Oracle
???????????????:
??????????????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;
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11