TNS-12547 Linux error:104:connection Reset by PE (reprinted)

TNS-12547 Linux error:104:connection Reset by peer

Resolution process Reference: Http://blog.chinaunix.net/u/7121/showart_403812.html

[[email protected] log]$ lsnrctl start
Lsnrctl for linux:version 10.2.0.1.0-production on 23-jun-2009 09:53:26

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

Starting/opt/oracle/product/10.2.1/db_1/bin/tnslsnr:please wait ...

Tnslsnr for Linux:version 10.2.0.1.0-production
System parameter File Is/opt/oracle/product/10.2.1/db_1/network/admin/listener.ora
Log messages Written To/opt/oracle/product/10.2.1/db_1/network/log/listener.log
Listening on: (Description= (Address= (PROTOCOL=IPC) (Key=extproc1)))
Listening on: (Description= (Address= (protocol=tcp) (Host=mymachine.localdomain) (port=1521)))

Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
Tns-12547:tns:lost Contact
Tns-12560:tns:protocol Adapter Error
Tns-00517:lost Contact
Linux error:104:connection Reset by peer
Connecting to (Description= (address= (protocol=tcp) (Host=mymachine.localdomain) (port=1521)))
Tns-12541:tns:no Listener
Tns-12560:tns:protocol Adapter Error
Tns-00511:no Listener
Linux Error:111:connection refused
Resolution process:
[Email protected] log]$ more/etc/hosts
# don't remove the following line, or various programs
# that require network functionality would fail.
10.10.5.24 Mymachine.localdomain
10.10.3.254 Host54.localdomain

[Email protected] ~]# vi/etc/hosts
# don't remove the following line, or various programs
# that require network functionality would fail.
127.0.0.1 localhost #添加
10.10.5.24 Mymachine.localdomain
10.10.3.254 Host54.localdomain

Restart monitoring:
[[email protected] log]$ lsnrctl start
Lsnrctl for linux:version 10.2.0.1.0-production on 23-jun-2009 09:55:47
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting/opt/oracle/product/10.2.1/db_1/bin/tnslsnr:please wait ...
Tnslsnr for Linux:version 10.2.0.1.0-production
System parameter File Is/opt/oracle/product/10.2.1/db_1/network/admin/listener.ora
Log messages Written To/opt/oracle/product/10.2.1/db_1/network/log/listener.log
Listening on: (Description= (Address= (PROTOCOL=IPC) (Key=extproc1)))
Listening on: (Description= (Address= (protocol=tcp) (Host=mymachine.localdomain) (port=1521)))
Connecting to (Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for Linux:version 10.2.0.1.0-production
Start Date 23-jun-2009 09:55:48
Uptime 0 days 0 hr. 0 min. 0 sec
Trace level off
Security on:local OS Authentication
SNMP OFF
Listener Parameter File/opt/oracle/product/10.2.1/db_1/network/admin/listener.ora
Listener Log File/opt/oracle/product/10.2.1/db_1/network/log/listener.log
Listening Endpoints Summary ...
(Description= (address= (PROTOCOL=IPC) (Key=extproc1)))
(Description= (address= (protocol=tcp) (Host=mymachine.localdomain) (port=1521)))
Services Summary ...
Service "Plsextproc" has 1 instance (s).
Instance "Plsextproc", status UNKNOWN, have 1 handler (s) for the This service ...
Service "ORCL" has 1 instance (s).
Instance "ORCL", status UNKNOWN, have 1 handler (s) for the This service ...
The command completed successfully

Search on the Internet, another case of tns-12547:tns:lost contact, the specific error is as follows:
Tns-12547:tns:lost Contact
Tns-12560:tns:protocol Adapter Error
Tns-00517:lost Contact
Linux Error:32:broken Pipe
Cause: Listener.log file exceeds 2G
Workaround: Empty the log file
[Email protected] ~]$ CD $ORACLE _home/network/log
[Email protected] log]$ cat/dev/null > Listener.log

This article from Csdn Blog, reproduced please indicate the source: http://blog.csdn.net/daimin1983/archive/2009/06/23/4291661.aspx

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 is enhanced in
10.1.0.3 to support FAN (Fast application Notification) via
ONS (Oracle Notification Services). This new code opens a sockets open on localhost. Therefore
"localhost" should is defined on the system.

This new code opens a sockets open on localhost. Therefore "localhost" should is defined on the
System.

Fix

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

=================================

TNS-12547 Linux error:104:connection Reset by PE (reprinted)