TNS-12537, TNS-12560, TNS-00507
来源:互联网 发布:南方贵金属交易软件 编辑:程序博客网 时间:2024/05/21 06:27
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 in10.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 include127.0.0.1 localhost.localdomain localhost
================================================
Subject: 10g TNS Listener Fails To Start With Errors: TNS-12537...Error: 29: Illegal seekDoc ID:Note:315720.1Type: PROBLEMLast Revision Date: 26-SEP-2007Status: MODERATED
In this Document
Symptoms
Changes
Cause
Solution
References
This document is being delivered to you via Oracle Support'sRapid Visibility (RaV) Rapid Visibility</A /> (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-12537, TNS-12560,TNS-00507 解决方法
- TNS-12537, TNS-12560, TNS-00507
- TNS-12537,TNS-12560,TNS-00507问题解决
- TNS-12537: TNS:connection closed TNS-12560: TNS:protocol adapter error TNS-00507: Connection clos
- tns
- Oracle11g ORA-609 TNS 12537 TNS 12560
- Oracle11g ORA-609 TNS 12537 TNS 12560
- 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 组合错误解决方案
- TNS-12537, TNS-12560,TNS-00507 Linux Error: 29: Illegal seek error
- 启动oracle监听报错:TNS-12537 TNS-12560 TNS-00507 Linux Error
- 一句话搞定TNS-12537、TNS-12560、TNS-00507、Linux Error:29 错误组合
- Oracle 监听lsnrctl命令启动报错(TNS-12537,TNS-12560,TNS-00507)
- Oracle 监听器无法启动(TNS-12537,TNS-12560,TNS-00507)
- TNS-12537 TNS-12560 TNS-00507 Linux Error: 29: Illegal seek
- TNS-12546 TNS-12560 TNS-00516
- TNS-12535 TNS-12560 TNS-00505
- TNS-12518 TNS-12549 TNS-12560 TNS-00519
- linux下apache自动启动设置
- C#文件编译
- C++读写文件
- mysql中对查询结果进行排序
- 算法设计--基础知识
- TNS-12537, TNS-12560, TNS-00507
- SQL Server 2005控制用户权限访问表
- VML
- Linux+C语言开发+Makefile的用法总结
- 新建文章1
- SQL Server 2008定时作业的制定
- Tomcat下使用 telnet命令连接
- FireFox图片不能滚动
- Dom4J读取XML文件时出现的connection timed out:connect Nested exception异常解决方法