Oracle initiates listener error Tns-12547:tns:lost contact__oracle

Monitor startup error, report the following error:
Lsnrctl start
Lsnrctl for linux:version 9.2.0.4.0-production on 06-jul-2009 14:37:59
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting/opt/oracle/product/9ir2/bin/tnslsnr:please wait ...
Tns-12547:tns:lost Contact
Tns-12560:tns:protocol Adapter Error
Tns-00517:lost Contact
Linux Error:32:broken Pipe

The database server operating system is red Hat AS4 and belongs to the 32-bit operating system, and the maximum text file cannot exceed 2G.

When the Listener.log size is equal to 2G in the $oracle_home/network/log, unable to continue to write the log, the listening service will automatically stop, start or stop listener will be the error

：

The database server operating system is red Hat AS4 and belongs to the 32-bit operating system, and the maximum text file cannot exceed 2G.

When the Listener.log size is equal to 2G in the $oracle_home/network/log, unable to continue to write the log, the listening service will automatically stop, start or stop listener will be the error

Solution:

1. Often manually to clear the contents of the Listener.log file, the database server to execute the following command

CD $ORACLE _home/network/log

Cat </dev/null> Listener.log

2, let the command lsnrctl log, the database server to execute the following command

Lsnrctl

Set Log_status off

Quit

You can also turn on the listening log by adding Logging_listener=off to the Listener.ora file

The second case that may be related to this problem is the following error message:
Tns-12547:tns:lost Contact
Tns-12560:tns:protocol Adapter Error
Tns-00517:lost Contact
Linux error:104:connection Reset by Peer

This problem should be related to the host name, view/etc/hosts file
[Root@olivenan root]# more/etc/hosts
# do don't remove the following line, or various programs
# that require network functionality would fail.
127.0.0.1 localhost

Then look at the Listener.ora file and find Host=ixdba

Should be the problem here, then just add the following in the/etc/hosts

[Root@olivenan root]# more/etc/hosts
# do don't remove the following line, or various programs
# that require network functionality would fail.
127.0.0.1 localhost
127.0.0.1 IXDBA

Here's another case

This morning, encountered a problem, the customer disaster-tolerant library one of the nodes starts listening for the error tns-12547:tns:lost contact (another node starts normal)

According to the mistake, suspicion is lintener.log log file is too large, more than 2G, so unable to start, there is a possible/etc/hosts directory is not 127.0.0.1 loopback localhost records, which is usually caused by this error common cause

View the Lintener.log log file, the size is far less than 2G, the first possible exclusion;

R2:/oracle/app/oracle/product/9.2.0/network/log>ls-lrt
Total 24
Drwxr-xr-x 2 Oracle DBA 256 Nov 2007 BAK
-rw-r--r--1 Oracle DBA 6414 FEB 15:32 Sqlnet.log
-rw-r--r--1 Oracle DBA 3025 11:38 Listener.log

View/etc/hosts: 127.0.0.1 loopback localhost # loopback (lo0) name/address also normal, the second possible exclusion

/etc/hosts
#
# This file contains the hostnames and their address for hosts in the
# network.  this fi Le is used to resolve a hostname into an Internet
# address. 
#
# in minimum, this file must contain the Name and address for each
# device defined for TCP in Your/etc/net file.  It could also contain
# entries for Well-known (reserved) names such as Timeserver
# and PrintServer as as, any, and.
#
# The format of this file is:
# Internet address      hostname      ;   # Comments
# Items are separated by no number of blanks and/or tabs.  A ' # '
# indicates the BE Ginning of a comment; Characters up to the "end of the"
# line are not interpreted by routines which search this file.  Blank
# lines are allowed.

# Internet Address Hostname # Comments
# 192.9.200.1 Net0sample # Ethernet Name/address
# 128.100.0.1 Token0sample # Token Ring name/address
# 10.2.0.2 X25sample # X.25 Name/address
127.0.0.1 loopback localhost # loopback (lo0) name/address

Here's still a try, RM Lintener.log, in the touch of a listener.log, at the start of the listening

Lsnrctl Stop-----Stop first listener
RM listener.log----CD $ORACLE _home/network/log
Touch Listener.log
Lsnrctl start

Connecting to (description= address= (protocol=tcp) (host=135.10.34.38) (port=1521))
Tns-12547:tns:lost Contact
Tns-12560:tns Rotocol Adapter Error
Tns-00517:lost Contact
Ibm/aix RISC system/6000 error:73:connection Reset by peer

The error is still, check the records in Lintener.log
09-jul-2008 12:17:05 * 12546
Tns-12546:tns Ermission denied
Tns-12560:tns Rotocol Adapter Error
Tns-00516:permission denied

To view its processes:
R2:/oracle/app/oracle/product/9.2.0/network/admin>ps-ef |grep Lsnr
Oracle 192870 168578 0 12:16:13 pts/9 0:00 grep Lsnr
Oracle 254244 274714 0 11:06:44 pts/0 0:00 lsnrctl
Oracle 242390 1 0 11:06:57 pts/0 0:00/oracle/app/oracle/product/9.2.0/bin/tnslsnr listener-inherit
Rzyzdb2:/oracle/app/oracle/product/9.2.0/network/admin>

Kill-9 242390

R2:/oracle/app/oracle/product/9.2.0/network/log>lsnrctl start

Lsnrctl for Ibm/aix RISC system/6000:version 9.2.0.8.0-production on 09-jul-2008 12:24:21

Copyright 1991, 2006, Oracle Corporation. All rights reserved.
Connecting to (description= address= (protocol=tcp) (host=135.10.34.38) (port=1521))
Tns-12537:tns:connection closed
Tns-12560:tns Rotocol Adapter Error
Tns-00507:connection closed

View Node 2 Sqlnet.ora discovery:
The problem is here (Sqlnet.ora has IP limit, 38 this IP, that is, the fault of this IP no longer sqlnet.ora content, add 38 to Sqlnet.ora, start normal)