Saturday, August 10, 2013

ORA-03135: connection lost contact

ORA-03135: connection lost contact
Process ID: 12750
Session ID: 133 Serial number: 37557


Solutions:


ORA-03135: connection lost contact error will come due to two reasons.

1) Server unexpectedly terminated or was forced to terminate.
2) Server timed out the connection.


S.No
File Name
Parameter
 
New Value
1
Sqlnet.ora
Expire_time
 
30
2
Sqlnet.ora
inbound_connect_timeout
 
0
3
listener.ora
inbound_connect_timeout_listenername
 
0
 

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...