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
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
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_SERV ICES versus NTS.
Can anyone confirm that this is legitimate tweak when encountering connection issues?
Can anyone confirm that this is legitimate tweak when encountering connection issues?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.