Re: Message receive failure on SQLNET

Check the number of network stream buffers allocated on the Dec Station. Usually this is the 'netstat -m' command. Check the "failures" column. Tune the kernel accordingly with the NS128 or N4096 parameter.

-Andy

belk_at_dxcern.cern.ch (Andy Belk) writes:

>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 ...

-- 
Andrew Finkenstadt         +1 904 222-2639 (ANDY)  GEnie:  ANDY
Homes & Land Publishing    +1 904 575-0189 x260    ...!uunet!rde!andy
Vista-Chrome, Inc.         1600 Capital Cir SW     andy_at_rde.vistachrome.com
GEnie Unix Sysop/Manager   Tallahassee, FL 32310   NIC Handle: AF136
--
...and a UNIX user said 'rm -fr *' ...and all was without form and void...