TNS-12537, TNS-12560, TNS-00507

原创 2011年10月13日 10:20:58


The listener fails to start with the following errors:
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek
Generic to Unix platforms.


Wrong syntax in hosts file and also due to the the tnslsnr process was enhanced in to support FAN(Fast Application Notification) via
ONS (Oracle Notification Services). This new code opens a socket open on localhost. Therefore
"localhost" should be defined on the system.

This new code opens a socket open on localhost. Therefore "localhost" should be defined on the


Change /etc/hosts file to include localhost.localdomain localhost


Subject: 10g TNS Listener Fails To Start With Errors: TNS-12537...Error: 29: Illegal seek
Doc ID: Note:315720.1 Type: PROBLEM
Last Revision Date: 26-SEP-2007 Status: MODERATED

In this Document

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

Applies to:

Oracle Net Services - Version: to
This problem can occur on any platform.


Unable to start an Oracle10g R1 (or R2) TNS Listener on Unix:

For example:

$ lsnrctl start
LSNRCTL for HPUX: Version - Production on 01-JUL-2005 10:16:59
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Starting /db02/product/10.1/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:proto adapter error
TNS-00507: Connection closed
HPUX Error: 29: Illegal seek


Verify the user attempting to start the TNS Listener process has read permissions on the /etc/hosts file, and that this file contains the localhost entry: localhost.localdomain localhost prfinders .


TNS Listener fails while attempting to initiate subscription to ONS node down event.

Level 16 TNS Listener trace shows the last action:

[01-JUL-2005 10:16:59:727] nsglonsinit: Initiated subscription for node down event

Same symptoms and corrective action found in Bug 4227455 OCS_MAIN_SOLARIS_050304 - UNABLE TO START THE SECOND LISTENER of if OS User is unable to read the /etc/hosts file.


To implement the solution, please execute the following steps:

1. Explicitly disable the 10g TNS Listener's subscrition to ONS by editing the listener.ora file and add the parameter below:


where <listener_name> would be replaced with the actual listener name configured in the listener.ora file.

For example, if the listener name is LISTENER (default), the parameter would be:


- Save the listener.ora file

2. Start the TNS Listener from a new LSNRCTL prompt:

lsnrctl <return>

LSNRCTL> start


Note 284602.1 - 10g Listener: High CPU Utilization - Listener May HangNote 294730.1 - TNS-12537, TNS-12560, TNS-00507 Linux Error: 29: Illegal seek error When Starting the Listener


TNS-12560 "TNS:protocol adapter error"TNS-12537 TNS:connection closedTNS-507 "Connection closed"



TNS-12537,TNS-12560,TNS-00507问题解决! SymptomsThe listener fails to start with the following error...
  • kingsonl
  • kingsonl
  • 2012年10月11日 18:08
  • 1278

TNS-12537, TNS-12560,TNS-00507 解决方法

The information in this document applies to: 此文档中的信息适用于: Oracle Net Services - Version: ...
  • ksqqxq
  • ksqqxq
  • 2011年09月19日 16:22
  • 1223

一句话搞定TNS-12537、TNS-12560、TNS-00507、Linux Error:29 错误组合

针对Oracle 10g启动监听器时出现的TNS-12537、TNS-12560、TNS-00507、Linux Error:29 错误组合,在Trouble Shooting的时候不要单独排查某个报...
  • KENAN0
  • KENAN0
  • 2014年06月11日 23:51
  • 440


一、testTXT函数 二、vbokonly+vbexclamation 含义:弹出的对话框只有一个确定按钮和一个警告的图标 三、trim() 函数功能:去除字符串头或尾的空格,但不包含中间的空格 例...
  • Sophia_0331
  • Sophia_0331
  • 2017年08月19日 16:57
  • 313

监听器启动时报错:TNS-12537: TNS:connection closed/ TNS-00507: Connection closed

监听器启动时报错: 版本为:LSNRCTL for Linux: Version [oracle@ocm1 ~]$ lsnrctl start LSNRCTL for Linu...
  • q947817003
  • q947817003
  • 2014年03月24日 16:28
  • 2147

TNS-12537, TNS-12560, TNS-00507 Linux Error: 29: Illegal seek error When Starting the Listener

TNS-12537, TNS-12560, TNS-00507 Linux Error: 29: Illegal seek error When Starting the Listener T...
  • mack415858775
  • mack415858775
  • 2011年09月15日 17:20
  • 1489

Oracle 监听lsnrctl命令启动报错(TNS-12537,TNS-12560,TNS-00507)

LINUX登录oracle用户,通过lsnrctl start命令启动数据库时,报错如下: “ [oracle@localhost ~]$ lsnrctl start LSNRCTL f...
  • weiruoao
  • weiruoao
  • 2015年04月29日 23:12
  • 3085

TNS-12537, TNS-12560,TNS-00507 Linux Error: 29: Illegal seek error

TNS-12537, TNS-12560,TNS-00507 Linux Error: 29: Illegal seek error 错误现象: TNS-12537: TNS:connection...
  • wuweilong
  • wuweilong
  • 2012年12月11日 18:54
  • 3104

Oracle 监听器无法启动(TNS-12537,TNS-12560,TNS-00507)

Oracle启动监听报错,提示 连接中断 [oracle@localhost ~]$ lsnrctl start LSNRCTL for Linux: Version - P...
  • hknaruto
  • hknaruto
  • 2015年09月01日 16:21
  • 235

AIX 下lsnrctl start 错误

遇到的报错如下: sbdb:/home/oracle$lsnrctl status LSNRCTL for IBM/AIX RISC System/6000: Version 11.2...
  • cqfan
  • cqfan
  • 2015年11月22日 02:57
  • 506
您举报文章:TNS-12537, TNS-12560, TNS-00507