I have a problem sometimes when trying to connect to one of my databases using toad (v 10.6.1.3)
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 connect.
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. A few PC restarts will sometimes get me in but this is really a pain for me.
Just wondered if anyone had come across this and could offer any advice/fixes.
Thanking you in advance
EDIT: I am connecting to an oracle 10g database. I also have an oracle 8 database (on an HP Unix server) that never has this issue. Thanks.
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
thing?
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
connect.
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
advice/fixes.
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
point on.
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.
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?
I'm thinking VPN, too. Our VPN allows me to connect, but there's some sort
of a timeout issue where the firewall will drop the connection after a
certain amount of inactivity. You have a different issue, so let's try some
troubleshooting by taking Toad out of the picture (for now!).
Hopefully your Oracle Client install has SQL*Plus!
In Windows, open a DOS command window. You should be able to hold down
the Windows logo key and hit "R" to bring up the "Run" window; type "cmd" in
the box and click OK.
In the new DOS window, type "sqlplus /nolog". You may get an Oracle
"not connected" error -- that's OK.
Connect to your DB, e.g. "connect myuser@MYDB", supplying whatever
authentication you would normally use.
If you get an ORA-3113, it would seem to be a firewall issue. If not,
lather, rinse, and repeat to see if you can duplicate it. Post your results
and we'll go from there.
HTH! GL!
Rich -- [TeamT]
Disclaimer: "expert" -- n. an "ex" is a has-been and a "spurt" is a drip
under pressure.