远程连接oracle数据库

远程连接oracle数据库：
1.需要一个tns文件
2.找到本地服务器客户端的tns文件，然后将要连接的服务如这样儿式的：
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ZhaoYun-PC)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )


PROD=
 (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.158.176.28)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = PROD)
    )
  )
  

拷贝到本地的tnsnames.ora文件中，然后打开plSql选择服务名，输入用户名和密码即可。