Oracle客户端ORA-12541:TNS:无监听器 [英] Oracle client ORA-12541: TNS:no listener

问题描述

我是Oracle数据库的新手，但是有一个问题. 在我的数据库服务器(server1)上，侦听器和数据库实例正确运行，并且我可以使用sqlplus连接到该数据库. 当我使用其他服务器连接到数据库时，我检查了TNS配置并且它是正确的，但是系统显示:

I am new on Oracle database, but I have one issue. On my Database server (server1) listener and database instance run correctly and I can use sqlplus to connect to this DB. When I connect to database by using other server, I check the TNS configuration and it is correct but system says:

ERROR:
ORA-12541: TNS:no listener

我的数据库是Oracle 10gR2

My database is Oracle 10gR2

那我该如何解决这个问题?

So how can I solve this issue?

推荐答案

您需要将oracle设置为侦听所有ip地址(默认情况下，它仅侦听localhost连接.)

You need to set oracle to listen on all ip addresses (by default, it listens only to localhost connections.)

此文件位于:

• Windows:%ORACLE_HOME%\network\admin\listener.ora.
• Linux:$ ORACLE_HOME/network/admin/listener.ora

替换 localhost 为 0.0.0.0

# ...

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
    )
  )

# ...

步骤2-重新启动Oracle服务

• Windows: WinKey + r

  Step 2 - Restart Oracle services

  • Windows: WinKey + r

    services.msc
    

  • Linux(CentOs):

  • Linux (CentOs):

    sudo systemctl restart oracle-xe
    

  这篇关于Oracle客户端ORA-12541:TNS:无监听器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！