Answer the question
In order to leave comments, you need to log in
Why does the database connection break after ~1.5 hours of rest?
There is a VM on which there is a tornado server that works with Oracle, when the server starts everything is fine, it executes queries perfectly, but after ~ 1.5 hours of rest, the tornado gives an error " OperationalError: ORA-03114: not connected to ORACLE " . Why might this be happening?
The server itself works in conjunction with nginx, with the help of supervisor.
But it does not really matter, because the same story occurs when starting the server through the console without supervisor, and when starting the server without being tied to nginx. What could be the problem?
Python version - 2.7.5
Oracle client version - 11.2
cx_Oracle version - 5.1.3
tornado version - 4.3
Answer the question
In order to leave comments, you need to log in
Is the connection to the database permanent? If so, you need to find the setting responsible for terminating inactive connections by timeout. I don't remember where she is. See the listener.ora and sqlnet.ora docs for a start.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question