TNS-12537 TNS-12560 TNS-00507

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 startLSNRCTL 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 this is generally the host name is not correct, observe the listening status, the listening host name is localhost: [oracle @ localhost ~] $ Lsnrctl statusLSNRCTL 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 refusedConnecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localhos T) (PORT = 1521) TNS-12541: TNS: no listener TNS-12560: TNS: protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused view Host Name, it is found that localhost in/etc/hosts only needs multiple addresses, causing a listener conflict [root @ localhost ~] # Cat/etc/hosts127.0.0.1 localhost. domain localhost10.4.40.70 modify the Host Name of localhost: 1 hostnamehostname oracle2/etc/hosts127.0.0.1 localhost. domain192.168.0.1 oracle3/etc/sysconfig/networkhostname = oracle restarts again. [oracle @ oracle ~] $ Lsnrctl startLSNRCTL 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-ProductionSystem parameter file is/opt/oracle/11g/network/admin/listener. oraLog messages written to/opt/oracle/diag/tnslsnr/oracle/listener/alert/log. xmlListening 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 LISTENERVersion TNSLSNR for Linux: version 11.2.0.1.0-ProductionStart Date 06-AUG-2014 20: 07: 43 Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File/opt/oracle/11g/network/admin/listener. oraListener Log File/opt/oracle/diag/tnslsnr/oracle/listener/alert/log. xmlListening Endpoints Summary... (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1521) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 127.0.0.1) (PORT = 1521) The listener supports no servicesThe command completed successfully