Re: ORA-12571 when inserting records (V7.3.3/W-NT4.0) ORACLE has no real solution?!

You are right, ORA-12571 is a common error associated with SQL*Net V2, SQL*Net thinks the connection is broken while you are inserting lots of rows into the Oracle database. The default timeout period is 10 secs. In the Listener.ora you can set a longer timeout period with the line CONNECT_TIMEOUT_LISTENER = 300 , which means 5 minutes. Myself and others have encountered this error with the TCP/IP protocol. You raised an interesting point, that DECNET works ok. without this parameter being set. But I am a bit surprised that an INSERT of 500 records would cause this error, normally I would expect many many more.

Regards
Joe

In article <6k8ki7$t52$1_at_news.imp.ch>, "Aleksandar (Sasha) Cvetkovic" <Aleksandar.Cvetkovic_at_syseca.ch> says:
>
>Author: Aleksandar Cvetkovic (Aleksandar.Cvetkovic_at_syseca.ch)
>Subject: ORA-12571 (TNS packet writer failure)
>

>I am getting the above error when trying to insert 500 records to an
>ORACLE-DB.
>The embedded SQL code (VAX/VMS 6.2; PASCAL) is the following:
>....
>EXEC SQL PREPARE Insert_String FROM :hv_SQLString;
>EXEC SQL FOR :hv_Nr_Of_Records EXECUTE Insert_String USING ...
>...
>When the host variable hv_Nr_Of_Records is 500 (or 400) the error occurs.
>If I reduce the number of records to say 300 everything is OK.
>NOTE: The error does not happen with ORACLE V8.0.4.0.0 (also running on
>W-NT).
>

>Regards,
>Sasha
>
>
>
Received on Fri May 29 1998 - 06:58:48 CDT