Re: problem with ipx/spx via isdn with sqlnet 2.2

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/10/10
Message-ID: <61kjqt$mk6$3@news02.btx.dtag.de>#1/1

Alfons Kroese wrote:
>
> Hi,
>
> I've got a problem with oracle 7.2 novell server and win3.11 client over
> isdn lines. I use ipx/spx en sqlnet 2.2.
> The problem is that everything works fine as long as you keep working,
> but if you pause for 5 minutes , the server thinks he has lost the
> connection and sends an error message on the next select from the
> client.
> the message is : ora 12571 TNS packet writer failure.
> I've tried al sorts of things , but nothing seems to work.
> Does anybody know an answer ?
> Thanks, josie.

Hi,

if you enabled inactivity timeouts the physical connection will be closed (your 5 minutes intervalls). Despite spoofing enabled Oracle will loose connection as it happens with your installation. To let Oracle keep connection you have to disable SAP 103 on your IPX-Router and you've got to set the Oracle listener timout to infinity. The last point will lead to the following: Assuming a workstation hangs or breaks down none of the oracle connections the user at this opened before will be

closed automaticaly!!!!!!!!!!!!!!!! So your DBA has to look for

conenctions no longer in use, despite your DB ist shutdown every night for a cold backup.

-- 
Regards

M.Gresz    :-)

Received on Fri Oct 10 1997 - 00:00:00 CDT