Link to home
Start Free TrialLog in
Avatar of byd2k
byd2k

asked on

Oracle ORA-03114 Error

Hi,

We perform a mini-database download onto a few laptops through the WAN connection.  Every since we upgraded to a :) faster speed with Comcast, 1 out of 4 times I'll end up with a generic ORA-03114 error.  Are there any tweaks on the laptop that I could configure to force it not to time out or retry more often?

Thanks,
byd2k
Avatar of Rich Olu
Rich Olu
Flag of United Kingdom of Great Britain and Northern Ireland image

I don't fully understand your process, but the error means a call to oracle was attempted when no connection was established.

If you think the bottleneck is at the laptop end, then why not try a gigabit NIC maybe.

It would also help if you could elaborate on the process a bit more.

R.
Avatar of byd2k
byd2k

ASKER

After troubleshooting this further, we discovered that Comcast uses a term called Powerboost.  That is why 1 out of ever x attempts download in an incredible speed.  The laptop(s) perform a database download and after a few minutes, I end up with the Oracle connection error.  From another post, someone suggested to edit the sqlnet.ora file, and changing SQLNET.AUTHENTICATION_SERVICES versus NTS.

Can anyone confirm that this is legitimate tweak when encountering connection issues?

ASKER CERTIFIED SOLUTION
Avatar of byd2k
byd2k

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial