Chinaunix首页 | 论坛 | 博客
  • 博客访问: 664839
  • 博文数量: 168
  • 博客积分: 2928
  • 博客等级: 中校
  • 技术积分: 1904
  • 用 户 组: 普通用户
  • 注册时间: 2010-01-04 09:56
文章分类

全部博文(168)

文章存档

2010年(168)

我的朋友

分类: Oracle

2010-04-27 11:09:31

lsnrclt start 出错!TNS-12537, TNS-12560,TNS-00507 解决方法,oracle监听启动出错。
 

dragon/home/oracle/product/network/admin>lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 14-7月 -2009 01:51:48

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting /home/oracle/product/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
   Linux Error: 29: Illegal seek

更改了主机名,更改过hosts文件。首先查看$ORACLE_HOME/network/admin/listener.ora 文件中的host是多少。

另外需在/etc/hosts文件中查看是否有

127.0.0.1       localhost.localdomain   localhost

这条记录,如果后边的localhost被改为了其他也需增加这条记录。如你改为了

127.0.0.1       localhost.localdomain   dragon

这时增加进去这条记录就是由两条记录:

127.0.0.1       localhost.localdomain   dragon
127.0.0.1       localhost.localdomain   localhost

两条记录了。

 

 

下面是原文:

Subject: TNS-12537, TNS-12560, TNS-00507 Linux Error: 29: Illegal seek error When Starting the Listener
Doc ID: Note:294730.1 Type: PROBLEM
Last Revision Date: 16-JAN-2005 Status: MODERATED

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.

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

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_=OFF

where 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

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:protocol adapter error" TNS:connection closed "Connection closed"

Keywords

阅读(4206) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~