Oracle listener cannot be started (TNS-12537, TNS-12560, TNS-00507)

Oracle listener cannot be started (TNS-12537, TNS-12560, TNS-00507)

Oracle listener cannot be started (TNS-12537, TNS-12560, TNS-00507)

An error is reported when Oracle starts the listener, 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

This article permanently updates the link address: