配置tnsnames.ora
orCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.xx.xx)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )
主要的参数为HOST、PORT、SERVICE_NAME
可能的问题:
* 连接超时:很大可能性是windows自带的防火墙开着,屏蔽了1521端口
配置tnsnames.ora
orCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.xx.xx)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )
主要的参数为HOST、PORT、SERVICE_NAME
可能的问题:
* 连接超时:很大可能性是windows自带的防火墙开着,屏蔽了1521端口