It's been busy for nearly two weeks, I finally got it. From the beginning, it is suspected to be a network problem. Later, it is not that it may be the problem of the application. It is very likely that the database is the problem. Finally, the truth is returned to the origin. It turns out that the network firewall is in the ghost. The behavior is very strange, how do you want to understand, I have nothing to have to give up, I didn't expect the reason. This is the case, the system we develop needs to be kept connected to the Oracle database. If the network or other reasons are not normal to disconnect, the application must be restarted, otherwise it will not be used. In the test environment, it is stable, and there is a strange phenomenon on the machine room. The next day, look at the server, all database connections are broken, sometimes it is also broken during the day, and an application disconnected Frequent, other applications don't break every day. Because our application server network segment is 192.168.x.x, the database server is in the 10.x.x.x network segment, I started to start I suspect that there is such a problem in the middle router. If the network lasts for a while, there is no traffic automatically disconnected the network. And and the NMS said this, he said it impossible to have this problem. Because we have done another system in another system, it seems to be this reason, but it is not very clear. Looking for a person familiar with the matter, it is the reason for the database network card. From the application server PING database server, there are several packets in the evening, and the database server network card is nothing. So we use ping -t server-ip> ping.txt to check if there is a packet loss in the network, lasting for a few nights, there is no packet loss, the network is very good. I checked if there is a checkbox on the power attribute card of the network card attribute whether it allows the computer to turn off the device when the computer is idle. The default is selected. So I suspect that the NIC was turned off by the computer, so all the connections were disconnected, but the discharging of the day was different. Is there a problem with the application? Why didn't you find a problem in the test environment? It is possible to have a problem with a piece of data. They touched the mine when they test, so I checked all the data, there is no problem. It's really puzzling, and I continue to ping, the NIC is impossible to be closed. It may be that a port is closed, so we wrote a small program, open a database connection, check the database every other time, keep the port is open. The problem still exists, and this applet is not broken, and other full-turn. What is the reason? In fact, the problem is already very clear, but I don't understand what happened. And I was always called that day, and I was broken again. In the morning, I broke twice in the afternoon. All day we didn't think of a good way, how would be so metamorphosis, why is it only broken? I was suspected to be a bit problem with our application, and how to detect an application in the brain juice. In order to detect the rules of the disconnection, I wrote two triggers. When the user logs in when the network is inserted into a record, the logout is to fill the logout time. Later, I found that there is no use, and I will not trigger the logoff event at all when I'm quit, white is a busy! After get off work, the cycling is home, suddenly thinks of a way, regularly activating the connection, keeping the active state to see it constantly. Many good ideas have been thinking about the way I left the office home. I can't think of it in the office, I came out of the office. The next day, there is an action, fruit is really effective, and the connection is not broken.
