oracle远程连接快速配置，只需要修改一个

参考ocacle安装或者实例 路径：C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN

找到文件 tnsnames.ora 配置文件

修改：

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




ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 远程连接地址)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )