Oracle 监听lsnrctl命令启动报错(TNS

LINUX登录oracle用户,,通过lsnrctl start命令启动数据库时,报错如下:

“ [oracle@localhost ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 – Production on 29-APR-2015 07:38:11

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

Starting /home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait…

TNS-12537: TNS:connection closed TNS-12560: TNS:protocol adapter error Linux Error: 29: Illegal seek

“`

原因: /etc/hosts内有两个localhost的主机名,监听冲突。

解决方法: 1、修改其中一个主机名,比如oracle,执行以下命令。

hostname oracle

2、在/etc/hosts内修改一个主机名为oracle。

[root@oracle etc]# cat /etc/hosts 127.0.0.1 localhost ::1oracle

3、在/etc/sysconfig/network修改主机名为oracle。

[root@oracle etc]# cat /etc/sysconfig/network NETWORKING=yes HOSTNAME=oracle

4、重新启动,在oracle用户下执行lsnrctl start。

[oracle@oracle ~]$ lsnrctl startLSNRCTL – Production :46:27Copyright (c) 1991, 2009, Oracle. All rights reserved.Starting /home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait…TNSLSNR – ProductionSystem parameter file is /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraLog messages written to /home/oracle/app/diag/tnslsnr/oracle/listener/alert/log.xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Listening )(PORT=1521)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER————————AliasLISTENERVersionTNSLSNR – Production-APR-2015 07:46:29Uptime0 days 0 hr. 0 min. 0 secTrace LeveloffSecurityON: Local OS AuthenticationSNMPOFFListener Parameter File /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File/home/oracle/app/diag/tnslsnr/oracle/listener/alert/log.xmlListening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)))The listener supports no servicesThe command completed successfully

离开之后,我想你不要忘记一件事:不要忘记想念我。

Oracle 监听lsnrctl命令启动报错(TNS

相关文章:

你感兴趣的文章:

标签云: