转载自:http://tolywang.itpub.net/post/48/406624
oracle的其他版本也适用
The information in this document applies to:
Oracle Net Services - Version: 10.1.0.3
This problem can occur on any platform.
Symptoms
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.
Cause
Wrong syntax in hosts file and also due to the the tnslsnr process was enhanced in
10.1.0.3 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
system.
Fix
Change /etc/hosts file to include
127.0.0.1 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 |
<script></script>
In this Document
Symptoms
Changes
Cause
Solution
References
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review. |
Applies to:
Oracle Net Services - Version: 10.1.0.0 to 10.2.0.2
This problem can occur on any platform.
Symptoms
Unable to start an Oracle10g R1 (or R2) TNS Listener on Unix:
For example:
$ lsnrctl start
LSNRCTL for HPUX: Version 10.1.0.4.0 - 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
Changes
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:
127.0.0.1 localhost.localdomain localhost
192.168.2.20 prfinders.us.oracle.com prfinders .
Cause
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.
Solution
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:
SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF
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:
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
- Save the listener.ora file
2. Start the TNS Listener from a new LSNRCTL prompt:
lsnrctl <return>
LSNRCTL> start
References
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
Errors
TNS-12560 "TNS:protocol adapter error"TNS-12537 TNS:connection closedTNS-507 "Connection closed"
Keywords
分享到:
相关推荐
TNS-12541: TNS: 无监听程序 TNS-12560: TNS: 协议适配器错误 TNS-00511: 无监听程序 文章转自:http://www.luocs.com/archives/464.html 此文版权归作者 – yaogang所有,转载请注明yaogang©www.luocs.com。 ...
### ORA-12560 TNS 协议适配器错误详解 #### 一、概述 在Oracle数据库管理过程中,经常会遇到各种各样的错误提示,其中“ORA-12560 TNS: 协议适配器错误”是较为常见的一种。这种错误通常发生在客户端尝试连接到...
但是,查看listner.log文件,发现了多个类似的错误记录,提示TNS-12500错误,TNS-12540错误,TNS-12560错误,TNS-00510错误,32-bit Windows Error: 8: Exec format error等。这些错误信息表明,系统资源耗竭是导致...
实验得来的,不是随便copy的, ORA-12560TNS协议适配器错误,这个问题可定可以解决
【标题】"lcd.rar_TNS-G11232FGURN-1W _tns" 涉及的是一款名为 TNS-G11232FGURN-1W 的LCD显示器,该显示器由TN(Twisted Nematic)技术提供支持,这种技术是液晶显示(LCD)领域中的基础类型之一。"tns"可能是制造商...
ORA-12560_TNS协议适配器错误_的问题
### TNS-G12864FGDFN用户手册知识点概览 #### 一、物理参数及外形尺寸 - **模块尺寸**:该模块的尺寸为46.0mm(宽)×36.0mm(高)×2.85mm(最大厚度),这一尺寸适合用于多种设备上,确保了其在空间受限的应用...
listener-tnsnamelistener-tnsnamelistener-tnsnamelistener-tnsnamelistener-tnsnamelistener-tnsnamelistener-tnsnamelistener-tnsname
### TNS- 无法解析指定的连接标识符 在Oracle数据库管理中,遇到“TNS- 无法解析指定的连接标识符”这类错误是较为常见的现象。本文将深入探讨这一问题的原因及其解决方法。 #### 问题概述 此错误通常发生在尝试...
5. TNS-12537、TNS-12560、TNS-00507 Error 特征:LISTENER.ORA 文件中引用了一个无效的协议适配程序 原因:LISTENER.ORA 文件中 PROCOTOL 变量赋值不对。 措施:确保文件中赋值正确,一般用 TCP 协议,$ORACLE_...
ORA-12560: TNS:protocol adapter error Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error ...
在Oracle数据库系统中,用户有时会遇到“ORA-12560:TNS:protocol adapter error”这一类错误提示,通常这类错误提示与网络连接问题相关联。根据提供的部分描述来看,这个问题发生在Windows平台上,并且涉及到Oracle ...
TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=...
TNS-12560: TNS:protocol adapter error TNS-00511: No listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))...
ORA-12518 TNS:监听程序无法分发客户机连接,在您安装好数据库后配置连接数据库的过程中遇到这类问题应该很头疼吧,不过,当您还是四处查资料来解决您遇到的另你头疼的问题时,如果不经意间看到了这则贴子,那请您升...
【TNS-中国移动XXXX年客户满意度研究项目建议书】是中国移动与TNS RI合作的一份重要文档,旨在探讨如何提高中国移动的客户满意度。TNS RI是隶属于WPP集团的全球知名市场研究公司,具备丰富的行业经验和全球网络,...
在ORACLE测试服务器上还原恢复了一个数据库后,启动监听服务时出现了TNS-12541, TNS-12560,TNS-00511之类的错误,具体情况如下所示: [oracle@getlnx01 admin]$ lsnrctl status LSNRCTL for Linux: Version 10.2...
TNS-12560: TNS:协议适配器出现错误 TNS-00511: 无监听器 32-bit Windows Error: 61: Unknown error 然后,使用LSNRCTL start命令来启动监听器,如下所示: LSNRCTL> start 启动tnslsnr:请稍候... Failed to ...
协议适配器错误解决方法 协议适配器错误是指在数据库管理系统中,协议适配器无法正常工作,导致数据库无法启动或连接失败。这种错误可能是由于多种原因引起的,如监听服务没有启动、数据库实例没有启动、注册表问题...