PB development program to connect the oracle database, after a period of time will be broken!-CodePudding

PB9 development program, the server operating system is Unix, is oracle11g database, there is a piece of code in the program is take the server's current time, now found that over a period of time the code we won't be able to get a server of the current time, which is broken, check the oracle profiles file, no time limit, anyone know what reason be? How to solve?

CodePudding user response:

refer to the original poster vikent response:

PB9 development program, the server operating system is Unix, is oracle11g database, there is a piece of code in the program is take the server's current time, now found that over a period of time the code we won't be able to get a server of the current time, which is broken, check the oracle profiles file, no time limit, anyone know what reason be? How to solve?

Estimation is the problem of network, ping see if there are any packet loss problem

CodePudding user response:

Do not replace, because at the same time another connection SQL database application all normal!

CodePudding user response:

refer to the second floor vikent response:

does not replace, because at the same time another connection SQL database application all normal!

Mechanism is different, use ping to try, if there is a packet loss, can appear such circumstance, encountered before

CodePudding user response:

May be the result of the firewall to see if opening time is fixed, fixed, if can regularly even in the application database,

CodePudding user response:

Disconnect the hours are not fixed, some client continuously for a long time, some client soon, some frequently, some do not frequently,

CodePudding user response:

Is much more connection, the server automatically disconnect

CodePudding user response:

This I have practical experience, but my is a Windows server, you can try and see in the
Sqlnet. Ora file
Setting:
SQLNET. EXPIRE_TIME=5

It is ok to set up after the restart the ORACLE