| 澶辨晥閾炬帴澶勭悊 |
|
Oracle瀵嗙爜寤惰繜楠岃瘉瀵艱嚧鐨勭郴緇烪ANG浣?PDF 涓嬭澆
鏈珯鏁寸悊涓嬭澆錛?/strong>
閾炬帴錛?a target="_blank">https://pan.baidu.com/s/1WzzngodKRgUkpDWERVzwcA
鎻愬彇鐮侊細(xì)e3wh
鐩稿叧鎴浘錛?/strong>
涓昏鍐呭錛?/strong>
闂鐜拌薄錛?/div>
鏇存敼瀵嗙爜鍚庯紝姣忔榪炴帴寮傚父鎱紝灝辯畻鐢ㄦ紜殑瀵嗙爜榪炴帴錛岄獙璇佸歡鏃朵篃闈炲父澶э紝瀵艱嚧搴旂敤紼嬪簭榪炴帴鍙嶅鍑虹幇瓚呮椂鐜拌薄錛?/div>
闂鍒嗘瀽錛?/div>
緇忔煡瀹烇紝榪欐槸鐢變簬11G鐨勫歡榪熷瘑鐮佺壒鎬у紩璧鳳紝鐗瑰埆鍦ㄤ竴浜涜嚜鍔ㄨ繛鎺ョ壒鎬х殑搴旂敤鏉ヨ錛屽鏋滃瘑鐮佽璇侀敊璇紝浼?xì)涓€鐩寸瘡縐瘑鐮侀獙璇佹椂闂達(dá)紝瀵艱嚧鍚庨潰鐨勬紜獙璇佷篃寮傚父瓚呮椂錛岃繖縐嶉棶棰樹竴鑸彂鐢熷湪淇敼搴旂敤璐︽埛瀵嗙爜鍚庯紝搴旂敤鏈嶅姟鍣ㄦ病鏈夊強(qiáng)鏃舵洿鏂版暟鎹簱榪炴帴淇℃伅瀵艱嚧銆?/div>
瑙ｅ喅鏂規(guī)錛?/div>
濡傛灉闇€瑕佷慨鏀瑰簲鐢ㄨ處鎴峰瘑鐮侊紝闇€瑕佹彁鍓嶇‘瀹氬ソ閭ｄ簺搴旂敤鏈嶅姟鍣ㄩ渶瑕佹洿鏀硅繛鎺ヤ俊鎭紝闇€鎻愬墠鍑嗗濂界浉搴旂殑鑴氭湰錛屽搴旂敤澶錛岄渶瑕佸湪鏇存敼鍚庝綔鍑虹浉搴旂殑鐩戞帶鎺柦錛屽錛?/div>
媯€(gè)鏌ユ暟鎹簱鐧誨綍鏃ュ織dba_audit_session錛屽彲浠ユ煡鍑虹櫥褰曞け璐ョ殑涓繪満鍜屽簲鐢紝閫氱煡鏋舵瀯璐熻矗浜哄強(qiáng)鏃惰皟鏁達(dá)細(xì)
Select *
From Dba_Audit_Session
Where User_Name = ’mbs7_Oms’
And Action_Name = ’logon’
And Timestamp Between
To_Date('2020-12-03 1:00:00', 'yyyy-mm-dd hh24:mi:ss') And
To_Date('2020-12-03 2:10:00', 'yyyy-mm-dd hh24:mi:ss')
Order By Sample_Time Desc
濡傚鐞嗕笉鍙?qiáng)鏃跺Q屽鑷寸敤鎴瘋寤惰繜璁よ瘉鐗規(guī)€ч樆濉烇紝鍙敤浠ヤ笅鑴氭湰鍦ㄥ紓甯歌妭鐐規(guī)壒閲忔煡鏉€榪滅▼榪炴帴榪涚▼鐨勫姙娉曡В鍐籌紝鑴氭湰濡備笅錛?/div>
ps -ef | grep LOCAL=NO | awk '{print $2}' | xargs kill -9
榪欓噷娉ㄦ剰鐨勬槸錛?/div>
鏌ユ潃鐨勫悓鏃惰閫氱煡鏋舵瀯浜哄憳灝藉揩娓呯悊榪炴帴緙撳瓨錛屽彟澶栨敞鎰忔煡鏉€鍚庯紝瀵逛簬涓€浜涙甯哥殑榪炴帴榪涚▼瑕佹墜宸ラ噸鏂板惎鍔紝 濡傚璁″簱鐨勮繙紼嬭繛鎺ヨ繘紼嬬瓑銆?/div>
褰撶劧榪欎釜鐗規(guī)€т篃鍙互璁劇疆灞忚斀錛岄€氳繃璁劇疆EVENTS 28401鍙互灞忚斀瀵嗙爜寤惰繜楠岃瘉錛?/div>
The event can be set as follows:
SQL> alter system set event =“28401 TRACE NAME CONTEXT FOREVER, LEVEL 1” scope=spfile;
璁劇疆璇ヤ簨浠跺悗閲嶅惎鏁版嵁搴撳嵆鍙€?/div>
To unset the event, set as follows:
SQL> Alter system set event= '28401 trace name context off' scope=spfile ;
---->瀵嗙爜楠岃瘉寤惰繜鍏抽棴
闄勶細(xì)濡傛灉鍚敤瀹¤錛屽彲閫氳繃浠ヤ笅璇彞緇熻鐧誨綍澶辮觸嬈℃暟
select username, os_username, userhost, client_id, trunc(timestamp), count(*) failed_logins from dba_audit_trail where returncode = 1017 and timestamp > sysdate - 7 group by username, os_username, userhost, client_id, trunc(timestamp);
|
| Java1234瀹樻柟緹?5錛?/td> | 
|
| Java1234瀹樻柟緹?5錛?/td> | 838462530 |
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
