oracle11g ora 12518,Oracle ORA-12518故障 处理

Oracle ORA-12518故障 处理

TROUBLESHOOTING GUIDE TNS-12518 TNS listener could not hand off client connection [ID 550859.1]

修改时 29-SEP-2011 类型 TROUBLESHOOTING 状态 PUBLISHED

In this Document

Applies to:

Oracle Net Services - Version: 9.2.0.1.0 to 11.2.0.3 - Release: 9.2 to 11.2

Information in this document applies to any platform.

Purpose

This article discusses about how to approach ORA-12518/TNS-12518 and troubleshoot it for the resolution.

Last Review Date

January 29, 2008

In c ion fo he Reade

A T o ble hoo ing G ide i p o ided o a i in deb gging a pecific i e. When po ible, diagno ic ool a e incl ded in he doc men o a i in o ble hoo ing.

Troubleshooting Details

Section I: Steps to approach ORA-12518/TNS-12518 Error:

ORA-12518/TNS-12518 indicates a problem while listener hands off the client connection to the server process or dispatcher process.TNS-12518 islogged in the listener log. The client might receive ORA-12518 or some other disconnection errors like ORA-12537. Once TNS-12518 is noted in thelistener log, follow the below steps to approach and resolve this error.

Let us have a small discussion about how actually database connections are made:

In Dedicated mode, database client contacts listener and supplies the SERVICE NAME of the database. Then listener spawns a dedicated server

process and hands off the client connection to this dedicated server process. TNS-12518 indicates a problem while handing off the client connection tothe server process.

In Shared Server mode, database client contacts listener and supplies the SERVICE NAME of the database. Then listener hands off the client

connection to one of the dispatcher configured for that service. TNS-12518 indicates a problem while handing off the client connection to the dispatcherserver process.

Though this error is logged in the listener log, the listener is just the messenger, ORA-12518/TNS-12518 is mostly related to RDBMS and OS

resources.

Step 1. Is listener version compatible to the database

Check if you are using compatible listener version for your database version.

If the database is 8i then use 8i or 9i listeners only. 10g listeners are not compatible to work with 8i databases.

For 9i databases, 9i or 10g listeners can be used.

For 10g databases, only 10g listeners can be used.