plsql连接远程数据库

修改instantclient_11_2(plsql安装目录)下的tnsnames.ora

ORCL =      # ORCL  连接时显示的名称
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521)) # host 服务器名或IP  port 端口
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)    # orcl  实例名
    )
  )