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