我在两台计算机上安装了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上也设置类似的内容?
1条答案
按热度按时间8yoxcaq71#
监听程序配置:
系结至
localhost
。它只能接收该位址上的联机。如果您要将它开放给远端联机,请使用“0.0.0.0“做为IP位址。这会让监听器接收服务器上任何NIC上的联机。