Oracle远程连接数据库总结

配置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端口