監聽啟動報TNS-12537、TNS-12560錯誤

監聽啟動報TNS-12537、TNS-12560錯誤

環境說明：

OS：CentOS 6.5

DB：Oracle  11.2.0.3

問題：資料庫啟動監聽的時候，報如下錯誤：

[oracle@localhost admin]$ lsnrctl start

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                27-NOV-2015 08:44:40

Uptime                    0 days 0 hr. 0 min. 18 sec

Trace Level              off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File  /ora01/app/oracle/product/11.2.0/db_01/network/admin/listener.ora

Listener Log File        /ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= )(PORT=1521)))

TNS-12537: TNS:connection closed

TNS-12560: TNS:protocol adapter error

TNS-00507: Connection closed

Linux Error: 29: Illegal seek

解決方案：

1、修改計主機名稱，安裝系統的時候預設的主機名稱為localhost，這個主機名稱進行解析的時候會出現很多詭異的問題，強烈建議大家記得修改主機名稱；

2、修改/etc/hosts 的檔案

[root@localhost tmp]# cat /etc/hosts

127.0.0.1  localhost localhost.localdomain localhost4 localhost4.localdomain4

::1        localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.1.100 dbtest001   

經過以上操作後，再次啟動監聽

[oracle@dbtest001 ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-NOV-2015 09:21:55

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /ora01/app/oracle/product/11.2.0/db_01/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production

System parameter file is /ora01/app/oracle/product/11.2.0/db_01/network/admin/listener.ora

Log messages written to /ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.26)(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                27-NOV-2015 09:21:55

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level              off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File  /ora01/app/oracle/product/11.2.0/db_01/network/admin/listener.ora

Listener Log File        /ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.100)(PORT=1521)))

The listener supports no services

The command completed successfully

顯示已完成監聽的啟動。