Re: ORA-3113 - End of file on communcation channel error

"Mark Pattrick" <mpattrick_at_amcare.demon.co.uk> wrote:

>I am getting a random disconnection from Oracle V7.1.4.1.0 resulting in the
>above error message. I am using Forms V4.5 running a large application
>form. The PC specification is 16MB RAM, 486DX2/66 and all software is on a
>Netware 4.1 file server. Seems to depend on number of users logged on?
 

>I am using OnNets PC/TCP V2.1 and WFWG 3.11 (does not seem to happen on a
>Windows 95 machine!)
 

>The form that causes the problem, when loaded inot memory does not allow
>for any other program to be loaded apart from Windows. If I have MS Mail
>running then the form does not always load complete.
 

>Any ideas?
 

>Mark Pattrick
>Amcare Limited

We spent many weeks and $Ks investigating a similar problem, without ever getting to the bottom of it.

My memory is somewhat hazy (this was over 1 year ago at a different site), but I think our set up was Oracle server 7.1.6 on HPUX 10, OnNet PC/TCP, WFWG 3.11, VB app accessing Oracle through RogueWave dbtools.h++ .
The VB app, RogueWave dlls, and various log files were originally held on the HPUX server, and accessed through PC/TCP NFS. The apparently random error code we saw was 3114 -- Not connected to server. (Presumably there had been a previous 3113, but this wasn't trapped.)

We used a lan sniffer to analyse lan traffic, and got OnNet, HP and Oracle support involved, all without success.

We finally circumvented the problem by moving the app, dlls, and log files to a WinNT file server.

If you've got the option (and even if you haven't!) I suggest investigating a different file server setup, or keeping the application on the PCs. It'll cost you less in the long run.

Good luck....

Tim Auckland Received on Thu Jan 30 1997 - 00:00:00 CST