Re: SQL*NET looses connection with ISDN

What values do you get by pinging the database server? Can you also tnsping/tnsping80 the <servicename> like you usually do? If the latency is low enough (let's say 60ms over the wan), you might consider looking into the bandwidth. If it's relatively very high, even increasing the bandwidth wouldn't neccesarelly solve your problem.

Also check in sqlnet.ora the 'expire_time' parameter.

On Tue, 27 Jan 1998 16:02:16 -0600, imrad007_at_hotmail.com wrote:

>Knud:
>
>My name is Russell Duff and I live in Pittsburgh, PA. Your post caught my
>eye because I'm having the same problem. Though we are not using ISDN (we
>are using T-1) I think we are having the same problem. When I called
>Oracle WorldWide support they informed me that the connection between the
>client and the server was being broken (ORA-03113). I asked my rep is
>there a setting to increase the timeout of SQL*net and he replied "Their
 

>isn't". My rep told me that TCP/IP controls the timeout. I did a
>experiment last week in which I ran one of my applications (Patient
>Scheduler) in house and when it was running disconnect the network
>connection (manually pull the cable out from the wall) wait about 15
>seconds and then plug the network connect back in. After I plugged the
>connection back in I received ORA-03113 when I requested more info from
>the app. Now TCP/IP is a monster in itself and to my understanding from
>what I've heard TCP/IP has a default timeout setting of ten seconds (This
>could be wrong but then again I'm not the TCP/IP master). You might want
>to check the bandwidth on the network to see if collisions are happening
>or bottle necking. Network isn't my thing but the Oracle rep suggested to
>increase the bandwidth because packets are colliding and distructing. A
>test you could do is decrease your number of users on your network and
>see if you still have the problem. Keep doing this until you don't
>receive the error. This should be a point were the network can handle the
>load of the packets or network traffic you are trying to push accross.
>Though this is advice and you can do with it what you want I would
>suggest to call Oracle World Wide support and get their two cents on the
>situation.
>
>Russ
>imrad007_at_hotmail.com
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

Kaboel Karso Received on Fri Jan 30 1998 - 00:00:00 CST