Message receive failure on SQLNET

From: Andy Belk <belk_at_dxcern.cern.ch>
Date: Wed, 10 Jun 1992 16:13:05 GMT
Message-ID: <1992Jun10.161305.14483_at_dxcern.cern.ch>

Hello All,

           We have an infrequent problem (it only happens after 6pm) whereby a request sent over SQLNET, via TCP, between an apollo client and a server running on a DecStation (Oracle V6.0) fails with:

ORA:06109 NETTCP message receive failure

oerr says "An error occurred whilst reading the two-task communications channel".

It usually happens during a fairly small but rapidly repeated update request: 64 * update f_hw_image set sent_value =

       (select hw_value from f_hw_actset where hw_name = 'xyz')
         where hw_name = 'xyz';

(but not always). It is also, fortunately, rare.

Has anyone else had this problem ? Any suggestions for a cure ?

Any help or comments appreciated,

           Andy Belk

-- 
					    ...   Anyd   ...

Received on Wed Jun 10 1992 - 18:13:05 CEST