Our production database drops connection from 30minutes to 6 hours without any reason . One of our DBA
already tested out the connection in DMZ area and found out connection drops
periodically. We need to fix this issue as soon as possible. Following are the two error messages occurs when try to connect to the
ORA-02068: following severe error from OPSWEB ORA-03113: end-of-file on
ORA-02068: following severe error from OPSWEB ORA-03114: not connected to
I found a similar situation when going through a firewall.
The connection would disconnect only when idle for a certain amount of time. It was definitely not on the server or database side, but had to do with the firewall configs.
Once we moved the server inside the firewall the disconnects dissapeared.
No nothing at all. It's been going on for past several months now . I opened TAR with Oracle but they are insisting this is network issue and our net work team insisting oracle issue. I m figuring it out how should I resolve this.
Open a SQL session locally (on the server) see if that gets disconnected. If it does than you have ruled out most networking possibilities. If it does not than you have some proof to support your networking theory.
Also, if the times are random I doubt there is a procedure in place that causes this. Come to think of it I do not know of a way to terminate sessions after X time.