My Oracle Support Banner

A Demonstration of the Alert Log Timeouts Occur: TNS-12170/TNS-12535/TNS-12560/TNS-00505 (Doc ID 2461900.1)

Last updated on NOVEMBER 19, 2018

Applies to:

Oracle Net Services - Version 11.1.0.6 to 12.2.0.1 [Release 11.1 to 12.2]
Information in this document applies to any platform.

Purpose

This document describes how an alert log timeout is triggered when an established connection is abruptly terminated due to a TCP or Network interruption.
This is a common problem with remote Oracle Net clients and this document serves to explain the circumstances that will cause this problem to occur.
Review the following for more information about how to resolve this common problem:
<Note: 1628949.1>   Alert Log Errors: 12170 TNS-12535/TNS-00505: Operation Timed Out

Scope

This document describes how and why timeout errors are thrown in the database alert log when a TCP interruption occurs after a remote connection is established.
This is a common problem in environments where firewalls exist and where connections might appear idle for a lengthy period of time due to no activity on the network.
Alert log reporting of these kinds of errors was introduced in 11g.   Oracle has a provided a simple fix for most cases where a firewall with a maximum idle time setting is disrupting client connections.

Details

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
Scope
Details
  Database versions 11g and newer, the following errors might occur in the database alert log:
 Cause
 Solution
References


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