oracle ORA-12541:TNS:当我希望从另一台计算机进行远程连接时出现无监听程序错误

wlp8pajw  于 2022-11-22  发布在  Oracle
关注(0)|答案(1)|浏览(167)

我在两台计算机上安装了Oracle数据库19C,我正试图从另一台计算机访问同一个数据库。
我尝试通过Oracle SQL开发人员与localhost一起工作(两台机器都与localhost一起工作)。我暂时停止防火墙,我有ping,我还添加到防火墙tcp端口1521。
但当我尝试从机器A远程连接到机器B与以下代码的错误消息,我得到:ORA-12541: TNS:no listener .

sqlplus MyUserName/MyPassword@192.168.1.11:1521/orcl

计算机A中的listener.ora:

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

计算机A中的tnsnames.ora:

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

我知道在SQL Server中,您需要启用远程连接以远程连接到数据库。我们是否需要在机器A中的oracle SID上也设置类似的内容?

8yoxcaq7

8yoxcaq71#

监听程序配置:

(ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))

系结至localhost。它只能接收该位址上的联机。如果您要将它开放给远端联机,请使用“0.0.0.0“做为IP位址。这会让监听器接收服务器上任何NIC上的联机。

(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))

相关问题