配置客户端和服务器之间的连接Oracle 10g [英] Configuring the connection between client and server Oracle 10g

问题描述

我安装了oracle服务器，它正常工作。但是，安装在另一台机器上的客户端不工作。

I've installed the oracle server and it's working properly. However, the client which is installed in another machine is not working. The error TNS-12541: TNS:there is no listener appears.

我的TNSNames.ora：

My TNSNames.ora:

SCP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.2.39)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DatabaseIO)
)
)

在服务器机器中，我可以连接到databaseIO。

In server machine I can connect to the databaseIO.

还有其他配置吗？

推荐答案

在注释中，您有来自 lsnrctl status 的摘录：

In a comment you have an extract from lsnrctl status:

Listening Endpoints summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services summary...

您的侦听器仅侦听 127.0.0.1 ，因此只能从服务器进行连接。没有在您的外部地址 10.0.2.39 上侦听任何内容，因此该地址上端口1521的连接失败。

Your listener is only listening on 127.0.0.1, so connections can only be made from the server. There is nothing listening on your external address 10.0.2.39, so connections to port 1521 on that address fail.

您的 listener.ora 可能有一个 ADDRESS ，或没有 ADDRESS ，这将默认为 localhost：1521 。您需要将其修改为：

Your listener.ora presumably has something either a single ADDRESS, or no ADDRESS at all, which will default to localhost:1521. You need to modify it to something like:

LISTENER =
...
    (ADDRESS_LIST =
      ...
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.2.39)(PORT = 1521))
    )

或您机器的主机名。理想情况下，这将通过 netca 完成，而不是手动编辑文件。

or your machine's host name if that's resolvable to that address. Ideally this would be done through netca rather than by editing the file by hand.

这篇关于配置客户端和服务器之间的连接Oracle 10g的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！