Shared server connections hang after installing CPUJAN2006

最新推荐文章于 2024-10-16 11:14:53 发布

cnyp2016

最新推荐文章于 2024-10-16 11:14:53 发布

阅读量86

点赞数

文章标签：数据库

Subject: Shared server connections hang after installing CPUJAN2006
Doc ID: Note:361273.1 Type: PROBLEM
Last Revision Date: 21-JUL-2008 Status: MODERATED

In this Document
Symptoms
Changes
Cause
Solution

--------------------------------------------------------------------------------

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.5 to 9.2.0.5
This problem can occur on any platform.

Symptoms
Checked for relevance on 20-JUL-2008.

Connections via dispatchers hang.

For each failed connection via dispatcher, the listener will log three errors in the listener log as shown.

TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-530: Protocol adapter error

For each failed connection attempt, the number of "refused connections", shown with lsnrctl services, will increment by 1.

Changes
Shared Server connections hang after installing the CPUJAN2006 patch.
Cause

Solution
Workaround:

Add the following line to the listener.ora

direct_handoff_ttc_=off

Example:

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 60
TRACE_LEVEL_LISTENER = OFF
DIRECT_HANDOFF_TTC_LISTENER=off <=== add this parameter