PLSQL Developer 访问远程Oracle服务器

在Oracle安装目录下找到 tnsnames.ora 文件

如下在里面加入Oracle服务器信息
DB =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 服务器地址)(PORT = 端口通常是1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = 服务名称)
   )
 )
如：
 
ORCL_23 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.23)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )