首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >Linux错误: 111:连接拒绝LSNRCTL

Linux错误: 111:连接拒绝LSNRCTL
EN

Database Administration用户
提问于 2014-06-04 16:57:53
回答 1查看 44.2K关注 0票数 1

我在启动侦听器时遇到了问题,我正在使用CentOS6.5和Oracle 12cR1。

数据库已成功安装。

现在我的问题是,当我启动侦听器时,会显示以下错误:

代码语言:javascript
运行
复制
LSNRCTL> service
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=gaurav)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
   Linux Error: 111: Connection refused
 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "tuts" has 1 instance(s).
Instance "tuts", status UNKNOWN, has 1 handler(s) for this service...
 Handler(s):
  "DEDICATED" established:0 refused:0
     LOCAL SERVER
 The command completed successfully

我的主机名是gaurav

所以我在hosts文件中创建了一个条目

代码语言:javascript
运行
复制
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
 192.168.1.1        gaurav      oracle

此外,我还创建了一个listener.ora文件,其内容如下:

代码语言:javascript
运行
复制
LISTENER =
  (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST =gaurav)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

sid_list_listener=
   (sid_list=
   (sid_desc=
   (oracle-home=/home/oracle/app/oracle/product/12.1.0/dbhome_1)
   (sid_name=tuts)))

我能够平平我的主机gaurav

有人能帮我解决这个问题吗?

编辑

代码语言:javascript
运行
复制
[oracle@gaurav ~]$ lsnrctl start

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 05-JUN-2014 22:38:57

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

Starting /home/oracle/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr:  please wait...

TNSLSNR for Linux: Version 12.1.0.1.0 - Production
System parameter file is /home/oracle/app/oracle/product/12.1.0/dbhome_1 /network/admin/listener.ora
Log messages written to /home/oracle/app/oracle/diag/tnslsnr/gaurav/listener/alert/log.xml
 Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gaurav) (PORT=1521)))
 Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=gaurav)(PORT=1521)))
  TNS-12541: TNS:no listener
  TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
  Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
 ------------------------
 Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date                05-JUN-2014 22:38:59
Uptime                    0 days 0 hr. 0 min. 1 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oracle/app/oracle/product/12.1.0/dbhome_1 /network/admin/listener.ora
Listener Log File         /home/oracle/app/oracle/diag/tnslsnr/gaurav /listener/alert/log.xml
 Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gaurav)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "tuts" has 1 instance(s).
Instance "tuts", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
EN

回答 1

Database Administration用户

回答已采纳

发布于 2014-06-04 20:03:09

在我看来,你似乎没有启动侦听器,但它已经启动了。您的问题似乎是tcp连接,而不是ipc。因此,侦听器正在运行,您无法使用tcp访问它。使用telnet gaurav 1521进行测试

如果telnet不提供连接,防火墙就会阻塞您。停止/编辑防火墙。

票数 2
EN
页面原文内容由Database Administration提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://dba.stackexchange.com/questions/66568

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档