啟動監聽報錯：TNS-12537: TNS:connection closed TNS-12560: TNS:protocol adapter error TNS-00507: Connection closed Linux Error: 29: Illegal seek

標籤：

啟動監聽程式報錯：

說明：在rhel5.8上安裝完成oracle11g資料庫後，使用netca建立完監聽，啟動監聽時報錯。還未使用dbca建立執行個體。

[[email protected] ~]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-APR-2015 08:33:53Copyright (c) 1991, 2009, Oracle. All rights reserved.Starting /u01/app/oracle/product/11.2.0.1/db_1/bin/tnslsnr: please wait...TNS-12537: TNS:connection closedTNS-12560: TNS:protocol adapter errorTNS-00507: Connection closedLinux Error: 29: Illegal seek

處理方法：修改/etc/hosts檔案如下

[[email protected] ~]# cat /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.#127.0.0.1 rusky-oracle11g.com rusky-oracle11g 把此行注釋，添加第二行如下，否則啟動監聽程式時報錯。127.0.0.1    localhost.domain    localhost 192.168.1.203 rusky-oracle11g.com rusky-oracle11g

/etc/resolve.con檔案預設如下，未做修改：

 

[[email protected] ~]$ cat /etc/resolv.conf search com

 

再次啟動監聽正常：

[[email protected] ~]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-APR-2015 08:37:38Copyright (c) 1991, 2009, Oracle. All rights reserved.Starting /u01/app/oracle/product/11.2.0.1/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionSystem parameter file is /u01/app/oracle/product/11.2.0.1/db_1/network/admin/listener.oraLog messages written to /u01/app/oracle/diag/tnslsnr/rusky-oracle11g/listener/alert/log.xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rusky-oracle11g.com)(PORT=1521)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rusky-oracle11g.com)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 02-APR-2015 08:37:38Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/product/11.2.0.1/db_1/network/admin/listener.oraListener Log File /u01/app/oracle/diag/tnslsnr/rusky-oracle11g/listener/alert/log.xmlListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rusky-oracle11g.com)(PORT=1521)))The listener supports no servicesThe command completed successfully

參考資料：

http://blog.csdn.net/zengmuansha/article/details/22686231

http://blog.chinaunix.net/uid-24612962-id-3194611.html

啟動監聽報錯：TNS-12537: TNS:connection closed TNS-12560: TNS:protocol adapter error TNS-00507: Connection closed Linux Error: 29: Illegal seek