Monday, January 25, 2016

ORA-03135: CONNECTION LOST CONTACT in Power center user

ISSUE:

PowerCenter server connects to Oracle and fails with the error:

ORA-03135: connection lost contact
Process ID: 10375
Session ID: 1296 Serial number: 31875

Database driver error...
Function Name : Execute
SQL Stmt : INSERT INTO W_SALES_PICK_LINE_FS

REASON:

This issue occur in below reasons:

The server unexpectedly crashed or was forced to down or instance not available.
The server timed out due to inactivity. 

SOLUTION:

Inrease the timeout threshold by using below parameters:

SQLNET.EXPIRE_TIME =10  #in minutes
SQLNET.INBOUND_CONNECT_TIMEOUT = 300 #in seconds
SQLNET.SEND_TIMEOUT = 300 #in seconds
SQLNET.RECV_TIMEOUT = 300 #in seconds

No comments:

Post a Comment