Oracle 客户端 ORA-12541: TNS: 无侦听器

我是甲骨文数据库的新手，但我有一个问题。 在我的数据库服务器(server1)侦听器和数据库实例正确运行，我可以使用 sqlplus连接到这个数据库。 当我使用其他服务器连接到数据库时，我检查 TNS 配置是否正确，但系统显示:

ERROR:
ORA-12541: TNS:no listener

我的数据库是 Oracle 10gR2

那么我该如何解决这个问题呢？

617622 次浏览
小开

According to oracle online documentation

ORA-12541: TNS:no listener

Cause: The connection request could not be completed because the listener is not running.


Action: Ensure that the supplied destination address matches one of the addresses used by
the listener - compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or
TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener on
the remote machine.
小开

I also faced the same problem but I resolved the issue by starting the TNS listener in control panel -> administrative tools -> services ->oracle TNS listener start.I am using windows Xp and Toad to connect to Oracle.

小开

Check out your TNS Names, this must not have spaces at the left side of the ALIAS

Best regards

小开
最佳答案

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

Step 1 - Edit listener.ora

This file is located in:

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

Replace localhost with 0.0.0.0 

# ...


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


# ...

Step 2 - Restart Oracle services

  • Windows: WinKey + r

    services.msc

  • Linux (CentOs):

    sudo systemctl restart oracle-xe

enter image description here


提交答案