Home » RDBMS Server » Networking and Gateways » Operation Times out after 30 minutes (Oracle database 11.2.0.4.0 OEL 6.1)
Operation Times out after 30 minutes [message #684194] Mon, 19 April 2021 07:53 Go to next message
Andrey_R
Messages: 380
Registered: January 2012
Location: Israel
Senior Member

Hi all,
I am running a PL/Sql block that is doing some validation checks for data
After exactly 30 minutes it times out:

SQL> set timing on serveroutput on
SQL>
SQL> DECLARE
  2  V_EXISTS date;
  3  V_ROWID CHAR(18);
  4  begin
  5           FOR i in (......)
  6      LOOP
  7        SELECT ..................;
  8        select ......into .....;
  9      END LOOP;
 10      EXCEPTION
 11        WHEN OTHERS .........;
 12      END;
 13      /
ERROR:
ORA-03114: not connected to ORACLE


DECLARE
*
ERROR at line 1:
ORA-03135: connection lost contact
Process ID: 79678
Session ID: 629 Serial number: 14145


Elapsed: 00:30:00.67
SQL>
I checked my client's SQLNET.ora and it says

INBOUND_CONNECT_TIMEOUT_LISTENERNAME = 0

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.RECV_TIMEOUT = 0

SQLNET.AUTHENTICATION_SERVICES= (NTS)

SQLNET.EXPIRE_TIME = 0

SQLNET.SEND_TIMEOUT = 0

SQLNET.INBOUND_CONNECT_TIMEOUT = 0
I'm not sure why I would get this timed out.. what can be the cause ?


Thank you
Andrey
Re: Operation Times out after 30 minutes [message #684195 is a reply to message #684194] Mon, 19 April 2021 08:12 Go to previous message
John Watson
Messages: 8640
Registered: January 2010
Location: Global Village
Senior Member
You are probably being disconnected by an OS network timeout somewhere. You need to set a sqlnet.expire_time to stop that happening.
Previous Topic: Connection to MS SQL using ODBC Gateway
Next Topic: ORA-12641
Goto Forum:
  


Current Time: Fri Dec 03 02:07:04 CST 2021