My Oracle Support Banner

BRM dm_oracle: How to Resolve ORA-03135: Connection Lost Contact? (Doc ID 1287740.1)

Last updated on AUGUST 16, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Purpose

How to resolve "ORA-03135: connection lost contact"?
In dm_oracle.pinlog file, sometimes "ORA-03135: connection lost contact" is logged after the system idles for a while.  Details as below:
M Wed Nov 3 23:52:54 2010 <HOSTNAME> dm:3106 dm_search.c(100):2826 1:<HOSTNAME>:cm:2977:-146388224:9:1288842774:1
  in update size is 1000 (default)
E Thu Nov 4 01:19:44 2010 <HOSTNAME> dm:3090 dm_subr.c(139):1352 1:<HOSTNAME>:cm:2977:-146388224:9:1288839181:1
  ORACLE error: do_sql: PINStmtExecute: code 3135, op 0
=ORA-03135: connection lost contact
Process ID: 322
Session ID: 109 Serial number: 38559

E Thu Nov 4 01:19:44 2010 <HOSTNAME> dm:3090 dm_if_oracle.c(163):7914 1:<HOSTNAME>:cm:2977:-146388224:9:1288839181:1
  op_trans_open: "set transaction read write": err=46(PIN_ERR_BAD_VALUE), trans_flags 0x1, poid_id 262405047038980767
E Thu Nov 4 01:19:44 2010 <HOSTNAME> dm:3090 dm_if_oracle.c(163):4767 1:<HOSTNAME>:cm:2977:-146388224:9:1288839181:1
  bad probe of ORACLE connection "<BRM CONNECTION NAME>", PINStmtExecute rc 3114 errmsg "ORA-03114: not connected to ORACLE"

The database is Oracle Server - Enterprise Edition, 11.2.0.2.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 You can use SQLNET.EXPIRE_TIME=10 in the SQLNET.ORA of the server's Oracle home to help prevent
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.