My first post here, so hi everyone
I have a problem sometimes when trying to connect to one of my databases
using toad (v 10.6.1.3)
Just the one database is giving these problems, or do others do the same
I am a remote worker, going through an ASA and VPN and frequently get
the error ORA-03113: end of file on communication channel when i try to
3113 is a bit of a catch all I’m afraid. It basically means that you’ve
been dropped - somehow - by the network or something has happened to
cause your connection to be lost.
I occasionally have to go via a VPN as well, but I can connect quite
happily using Toad when I do that.
There is nothing wrong with the database as people actually on the
network can access it no problem and if i remote through to a networked
PC i can access the database no problem too.
Sounds remarkably like your VPN (or whatever) is a tad flaky for some
reason. Do you have a network team you can contact? Are they any good?
A few PC restarts will
sometimes get me in but this is really a pain for me.
Yes, a pain, and not really a suitable answer to your problem.
Just wondered if anyone had come across this and could offer any
Unfortunately, it seems most likely that your VPN is duff somehow. I’m
wondering if the firewall is not set up to allow Oracle connections
through? You need to open up the listener port for all your listeners,
but then, once you connect to the listener, it hands you off to your
server process and communications take place on a random port from that
Unless you have an “Oracle aware” firewall, you may not be permitted to
communicate with anything other than the listener. If your firewall is
not Oracle aware, you will most likely need Oracle Communication Manager
in place. Failing that, turn off the firewall - with all the potential
problems that implies.