Oracle listener cannot be started (TNS-12537, TNS-12560, TNS-00507)
An error is reported when the Oracle listener is started, indicating that the connection is interrupted.
[Oracle @ localhost ~] $ Lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0-Production on 06-AUG-2014 20:02:16
Copyright (c) 1991,200 9, Oracle. All rights reserved.
Starting/opt/oracle/11g/bin/tnslsnr: please wait...
TNS-12537: TNS: connection closed
TNS-12560: TNS: protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek
In this case, the host name is incorrect. Check the listening status. The listening host name is localhost:
[Oracle @ localhost ~] $ Lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0-Production on 06-AUG-2014 20:02:48
Copyright (c) 1991,200 9, Oracle. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 )))
TNS-12541: TNS: no listener
TNS-12560: TNS: protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521 )))
TNS-12541: TNS: no listener
TNS-12560: TNS: protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Check the host name. It is found that localhost in/etc/hosts only needs multiple addresses, causing a listener conflict.
[Root @ localhost ~] # Cat/etc/hosts
127.0.0.1 localhost. domain localhost
10.4.40.70 localhost
Modify host name:
1 hostname
Hostname oracle
2/etc/hosts
127.0.0.1 localhost. domain
192.168.0.1 oracle
3/etc/sysconfig/network
Hostname = oracle
Started again, succeeded
[Oracle @ oracle ~] $ Lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0-Production on 06-AUG-2014 20:07:41
Copyright (c) 1991,200 9, Oracle. All rights reserved.
Starting/opt/oracle/11g/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0-Production
System parameter file is/opt/oracle/11g/network/admin/listener. ora
Log messages written to/opt/oracle/diag/tnslsnr/oracle/listener/alert/log. xml
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1521 )))
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 127.0.0.1) (PORT = 1521 )))
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 )))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0-Production
Start Date 06-AUG-2014 20:07:43
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File/opt/oracle/11g/network/admin/listener. ora
Listener Log File/opt/oracle/diag/tnslsnr/oracle/listener/alert/log. xml
Listening Endpoints Summary...
(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1521 )))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 127.0.0.1) (PORT = 1521 )))
The listener supports no services
The command completed successfully