Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the oracle snooping fault under windows". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to solve the oracle snooping fault under windows".

Phenomenon: database service and monitoring are running normally, but opening the function module is very slow

Process:

Check the database alert_oaxx.log log

Log switching is not high, no error is reported; the database load is not heavy.

Check the status of the database

The service and monitoring are running normally, the sqlplus / as sysdba login is normal, and the number of sessions is normal.

Check the system startup time

Initial installation date: 2015-5-13, 12:09:51

System startup time: 2018-6-14, 3:11:06

Check the network connection and find a large amount of close_wait, caused by process 327000, which is judged to be 360tray

TCP 10.25.136.5:52667 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52668 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52669 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52672 221.130.200.53:80 CLOSE_WAIT 327000TCP 10. 25.136.5:52674 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52675 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52676 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52677 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136. 5:52678 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52680 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52681 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52682 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52683 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52684 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52686 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52688 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52690 221.130 . 200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52691 221.130.200.53:80 CLOSE_WAIT 327000TCP 10.25.136.5:52692 221.130.200.53:80 CLOSE_WAIT 327000

Check database wait events

No waiting

Fourth, do tnsping discovery:

C:\ Users\ Administrator > tnsping oadbTNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0-Production on 08-May-2019 15:05:04Copyright (c) 1997, 2010, Oracle. All rights reserved. Parameter file used: y:\ oracle\ product\ 11.2.0\ dbhome_1\ network\ admin\ sqlnet.ora has used the TNSNAMES adapter to resolve the alias attempt connection (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.xx.1xx.5) (PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oadb)) OK (51910 Ms)

High latency, deactivating 360tray

C:\ Users\ Administrator > tnsping oadbTNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0-Production on 08-May-2019 14:58:23Copyright (c) 1997, 2010, Oracle. All rights reserved. Parameter file used: y:\ oracle\ product\ 11.2.0\ dbhome_1\ network\ admin\ sqlnet.ora has used the TNSNAMES adapter to resolve the alias attempt connection (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = WIN-5K0CGNM3EQV) (PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oadb)) OK (24950 Ms)

Reduced to 25 seconds, but still very high, ping host, found that the latency is very low, disable ipv6, the effect is still the same

C:\ Users\ Administrator > ping 10.25.136.5

Ping 10.25.136.5 has 32 bytes of data:

Reply from 10.25.136.5: bytes = 32 time

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.