Oracle 監聽器無法啟動（TNS-12537，TNS-12560，TNS-00507）

標籤：des   style   blog   color   os   io   strong   for   

Oracle啟動監聽報錯，提示 串連中斷

[[email protected] ~]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-AUG-2014 20:02:16Copyright (c) 1991, 2009, 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

這樣一般是主機名稱不對，觀察監聽狀態，監聽主機名稱為 localhost:

[[email protected] ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-AUG-2014 20:02:48Copyright (c) 1991, 2009, 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=localhost)(PORT=1521)))TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error  TNS-00511: No listener   Linux Error: 111: Connection refused

查看主機名稱，發現/etc/hosts內localhost只想多個地址，引發監聽衝突

[[email protected] ~]# cat /etc/hosts127.0.0.1   localhost.domain localhost10.4.40.70  localhost

修改主機名稱：

1 hostname 

hostname oracle

2 /etc/hosts

127.0.0.1 localhost localhost.domain192.168.0.1 oracle

3 /etc/sysconfig/network

hostname = oracle

再次啟動,成功

[[email protected] ~]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-AUG-2014 20:07:41Copyright (c) 1991, 2009, 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:43Uptime                    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